Topics
Started by
Posts
Last post
Task: carve a sp to perform a bulk insert from a txt file into a table variable which can then be f…
4 replies
I am using the below query, where [LR-DB003] is my linked server and some other @Session variables.…
6 replies
I have to create a unique(combined) filed based on the Id when I Insert Data eg. if next Id = 2 th…
9 replies
Declare NValue int Set NValue =40 create table RTable ( ID int NULL, Number int NUL…
5 replies
[font="Courier New"]DECLARE @TABLE TABLE ( EmpID CHAR(3) ,Category CHAR(1) ) INSERT INTO @T…
5 replies
I am trying to get the max effective date from the following query but the way I am doing I need to…
3 replies
3 replies
I am attempting to perform an update to an xml column (AttributeList). What my update needs to do …
1 replies
Hello all. I ma using the following query to pull back data. The MergeHistory table has a column na…
2 replies
I need to conditionally Order by some_column_name, but if that's column record is equal to some pa…
2 replies
I was under the understanding that during an update the order of the columns and variables were res…
12 replies
I have the following code that executes a dynamic sql to populate a table variable (ignore the flow…
3 replies
Hi, I have a insert statement in which destination table does not exist, in this case transaction w…
4 replies
Assume existing tables Table1,Table2 and Table3 in SS2K5 database "Teamwork", each with many rows o…
4 replies
I am creating reports using SSRS 2005 from my DB say DB_A. I require data from another SQL 2000 DB,…
3 replies
Viewing 15 topics - 10,081 through 10,095 (of 12,234 total)
You must be logged in to create new topics.