Viewing 15 posts - 54,946 through 54,960 (of 59,067 total)
Lowell does do a great job, but lemme ask you Cees... have you calculated the header or are you going to manually change it in the code?
September 20, 2007 at 7:06 am
That IS a good article... thanks, Ken.
September 20, 2007 at 7:02 am
Heh... You beat me to it!
And, if you can't afford that kind of schooling for the company, at least read about change management and change control. Use Access or...
September 20, 2007 at 6:57 am
Ummm.... wouldn't a CHECKSUM or BINARY_CHECKSUM at the row level be a little easier?
September 20, 2007 at 6:50 am
And, if you want to make sure it's a table...
IF Object_ID('tempdb..#fred','U') IS NOT NULL
September 20, 2007 at 6:36 am
Heh... yeah... I've run into this a couple of times my own self... most of the time, I pummeled the vendor until they provided correct data.
When all hope was lost,...
September 19, 2007 at 10:56 pm
And, people wonder why I didn't spend the money to go to PASS. S2D2 if you know what I mean ![]()
Sorry it worked out...
September 19, 2007 at 10:51 pm
One of the easiest and fastest ways is to dump the query results into a temp table that has a "line ID" column that is an IDENTITY column... in ACCESS,...
September 19, 2007 at 9:28 pm
Or, the OP could post the offending code, sans password, so we can actually try to troubleshoot the command for him ![]()
September 19, 2007 at 9:17 pm
That was the key, Serqiy... thanks ol' friend.
September 19, 2007 at 9:14 pm
Hey there, Greg! You finally made it! Welcome to the "mosh pit" ![]()
September 19, 2007 at 7:28 pm
Hi, It looks like my question is too difficult or not so clear, so I... |
September 19, 2007 at 7:25 pm
Heh...
Thanks for the nice compliment, Chris...
September 19, 2007 at 7:13 pm
First off and as a bit of a side bar... you don't need the BEGIN/COMMIT pair because the default settings for SQL Server are to treat each UPDATE as an...
September 19, 2007 at 7:11 pm
Viewing 15 posts - 54,946 through 54,960 (of 59,067 total)