Viewing 15 posts - 1,606 through 1,620 (of 1,923 total)
Buddy, small tweaks in the code will get you there!
For this requirement,
The SELECT statement for the INSERT should return these records:
A,5
C,1
These are the records in #ListUpdate that are not in...
May 5, 2010 at 10:31 am
Wonderful question and equally wonderful explanation. The basics is hit in the nail! Thanks for this!
May 5, 2010 at 10:10 am
Hey there! I have coded an below-par code for this requirement! This is what that struck my mind! Pro'ly there are many altenative super-fast , minimal-code, optimal-performance code available....
May 5, 2010 at 8:34 am
Please go through this following article to understand how to post data to get the best help:CLICK HERE FOR FORUM POSTING ETIQUETTES - JEFF MODEN[/url]
When u do so, i am...
May 5, 2010 at 8:02 am
Ok, i can understand what you want your code to do. I am in the middle of writing a query for you, but it will take time, In the meanwhile,...
May 5, 2010 at 7:59 am
kramaswamy (5/5/2010)
DECLARE @Field1 INT
DECLARE @Field2 INT
DECLARE @Field3 INT
DECLARE @Field4 INT
SELECT @Field1 = Field1, @Field2 = Field2, @Field3 = Field3, @Field4 = Field4
FROM @Test
Wont this populate the local variables with the...
May 5, 2010 at 7:55 am
Dear Lavanya, you have not even provided one of the requisites that Gianluca has asked for! Please provide us those and then we will provide you with awesome code! Guessing...
May 5, 2010 at 1:53 am
~Edit : My bad, posted in the wrong thread! 😀 ! Sorry!
May 4, 2010 at 10:46 pm
Jason's code will perfectly delete the duplicate rows.
As a side note, mbrady5, please post the table structures (create table scripts), some sample data cokked-up from your original data (as...
May 4, 2010 at 8:38 pm
emily-1119612 (5/4/2010)
So conceptually I want to truncate #Lists and Insert all records from #ListUpdate into #Lists. This would give me my desired results. From a coding/practical perspective I want to...
May 4, 2010 at 8:33 pm
Gianluca Sartori (5/4/2010)
Nice code, Mr. Coffee!Looks like you specialized in pivot/unpivot lately...
Oh am flattened! :blush: Thanks, Mr.Tally from Italy!!
Of late this PIVOT and UNPIVOT requirements are coming in large...
May 4, 2010 at 8:29 pm
When you run my code, i get these values in @test-2 table before and after the UPDATE.
SELECT * FROM @test-2
1. BEFORE Update
ID ...
May 4, 2010 at 2:01 pm
Hey i might have got what you wanted. Here is the full code:
First the test environment; sample data and the schemas
Note: I have used the same schema provided by you...
May 4, 2010 at 1:56 pm
Hey Kumar, based on the sample data and your requirement, i have arrived half-the-way.
This will not produce the full result, but i have come to a point where i have...
May 4, 2010 at 1:25 pm
Paul White NZ (5/4/2010)
Hey, would anyone like to see the SQLCLR solution to this same problem? 😉
I would love to, Mr.BlackCap! Please shoot it out!
May 4, 2010 at 6:40 am
Viewing 15 posts - 1,606 through 1,620 (of 1,923 total)