Viewing 7 posts - 1 through 7 (of 7 total)
The new vs the old product needs to be chosen based on the "flag" .
If the product_ID or the product_ID_Group appears twice or 2 rows with 2 different flags...
December 23, 2008 at 11:57 am
Based on the help with the query I was trying to create a procedure/function as given below
Before I started to write the procedure or a function, I started doing...
March 16, 2007 at 11:10 am
February 23, 2007 at 11:14 am
The Students and grades was just an example to explain it.
Yes, the no. grades for a student are consistent. I needed to take the end result and then insert it...
Thank you! Ken that worked .
February 23, 2007 at 11:10 am
I am sorry, I did not look that this section was for SQL Server 2005 and posted this question.
I appreciate it if anyone can still help me
January 8, 2007 at 9:16 am
Is this the way it should be done?
DECLARE @x int
SET ROWCOUNT 1000
SET @x = 1
WHILE @x > 0
EXEC sp_dboption 'EJ','Trunc. Log On Chkpt','TRUE'EGIN
DELETE FROM table WHERE conditions
August 24, 2004 at 1:03 pm