SQL Server 2000 I have a table that records various actions for people. I want to search for actions where none of several other required actions has been done (exception report). So the basic code I am working with (ignoring the people issue). drop table tblMissingActions drop table Ac...more >>

Hi, could anyone help a newbie? I'm trying to get the following stored procedure working: SET NOCOUNT ON; -- BEGIN TRAN CREATE TABLE ##table ( F1 INT, F2 NVARCHAR (100) ) INSERT INTO ##table (F1, F2) VALUES (7, 'abc') EXEC xp_cmdshell 'bcp "SELECT * FROM ##table (NOLOCK)...more >>

I have a database and need to have a installation program to deploy it. I have two choices for it, (1) msi file (2) smo Which one is better? And for each of the ways above, the database can be created by using T-SQL scripts, db backup files or db attach. Which way is better?...more >>

Hi, I would like to do a multiple insert without hardcoding the values in the Owner_Payee column like in the query below. When I do a distinct count of Owner_payee from the table - amp_allmysubordinates_postings, I can see 110 owner_payees. So, for each and every owner_payee, how can I do...more >>

We had problems accessing one particular table. When I checked sp_lock the table had a table, key and page lock placed on it, but more interestingly the spid value was -2. I don't believe I've ever seen a negative number as the spid before and was wondering what it means. I couldn't use KILL a...more >>

Can any one help on how to create a trigger that rollback data when updating a table. explain: update tableA set columnA='NA' in the event where no commit and rollback is in place as part of the update. I would like the trigger that rolls back the data as it was. can this be possible. ...more >>

i have to perform a select against a nullable column from my stored procedure. my stored procedure has a variable that can also be passed in as null. is there a good way to do this checking without using ISNULL? create PROCEDURE getSkillName @skillid int AS /* either or both of skilli...more >>

Hi all, I have a system, in this case I need 3 tables to work with a shopping cart. PurchaseOrder table defines who makes the order, PurchaseOrderDetails table defines what kind of products and quantities are in each purchase order. Please see below for detailed schema. I have a requ...more >>

I People, I was wondering if someone could take a look at this Stored Procedure and offer a suggestion as to how it could be improved for performance, It takes about five seconds to run which is a little too long. I think the nested loop has a lot of overhead. I have three tables personnel...more >>

since QA is now built into sql server mgmt studio, how do i get to the help system related to tsql syntax, etc?\ thanks ...more >>

Hello, i would like to take a file uploaded via web form from the user's pc into an sql server database, but i have no clue where to get started. could someone possibly point me to the right direction? The files will mainly be ppt files if that helps any. Since i wont be ftping the files anywhe...more >>

Hi everyone. I am new to sql so i figured the best way is to ask around and learn from there.. I have a problem that i would like to know. what sql code would i write if: I wanted to take information from one table and information from another and put ...more >>

Hi, I am not able to execute SQL Jobs and SQL DTS packages.(I am using SQL2000)....I have checked sql server agent and also i restarted the sql servies ....but for no respite. Could anybody please let me know if there could be any other issue. Thanks, Sriram ...more >>

Hi, I am attempting to execute an XPath query against a single xml document stored within SQL Server 2005 and return the results as a typical SQL Server recordset/resultset. I understand how to perform the xpath query, however I am having troubles getting the results back the way I want. An ...more >>

I've been thinking about how my organisation sets and uses table keys in its MS SQL Server 2000 databases, and about the relative efficiency of queries where table keys are 4-byte integers. I can encode a string of 6 characters into an integer, obviously using a smaller character set, while pr...more >>

Using the SQL 2005 "query notification" caching mechanism, I am caching three columns (UserId, UserName, Password) of a table called UserInfo in my web application cache. However, the cache gets invalidated (and needs to be re-loaded) when another column LastUpdateDateTime of the same table gets...more >>

Hi , What is the query for, if we want to display specific value depending on values in column; Eg. we are having table 'StudentMarks' with fields as bellow Table : StudentMarks Fields: StudentID,StudentPercentage if student having percentage > 44 and percentage <= 50 , we have to d...more >>

I have two data connections which one set of results need to be used in the other connection. The first connection will return a list of customer reference codes that are text (1,000's of records) which will need to be used as a parameter in the other connection. Both connections are in differe...more >>

Hi All I have the following requirement on the blogging site which we are developing ---> If a user posts a blog and they use words which are not allowed, then these words should be replaced by empty space. For this we have to maintain the list of such words ( bad words hopefully :-)) in t...more >>