Viewing 15 posts - 1 through 15 (of 104 total)
Okay. And this will keep the most recent record? I want to keep the most recent record and set the others as Published = 0
May 30, 2017 at 3:14 pm
May 30, 2017 at 2:00 pm
May 9, 2017 at 2:12 pm
Thanks Chris!
How would I do a derived column?
May 9, 2017 at 2:12 pm
Oh my goddness... I figured it out. I had included the update table in my sub query. Rookie mistake! Sheesh!
April 4, 2017 at 11:12 am
April 4, 2017 at 10:37 am
April 4, 2017 at 10:35 am
Thank you, Luis.
April 11, 2016 at 2:43 pm
John,
How would I select and check against the table I made and inserted into. I am not sure how to check against a column of sys.all_columns...
Here is what I have...
April 11, 2016 at 2:42 pm
Thank you VERY much, John!
April 11, 2016 at 8:28 am
I guess it was meant to do then... 😉
Thanks again!
January 22, 2016 at 5:55 am
That worked! Thank you SO MUCH!!!!!!!!
January 21, 2016 at 3:00 pm
brad.mason5 (1/14/2013)
For debugging dynamic sql, I usually will add a PRINT @sql statement above the EXEC
January 14, 2013 at 7:56 pm
Viewing 15 posts - 1 through 15 (of 104 total)