the top and bottom rows are determined by their order....I'm betting your procedure does not have an ORDER BY clause.

with out that, SQL server does not guarantee the order or...

here is a simple procedure i use all the time;

stick in the master database, and because it starts with "sp_" and uses the catibility views, it will be functional...

why not create a user defined function on the server, ie dbo.mydate()

that returns a specific datetime value; it could return something like the calculated last business day, or a...

Thank you! I consider that very high praise coming from you!

I'll submit both the 2000 and the 2005 scripts to the scripts here;

I had slapped together an article on...

Lynn what browser are you using? is...

i saw that after you posted....i'm embarrassed to offer it now , since STUFF is such a better solution

i think it goes to how much business data would be lost.

if the system crashed half an hour before the next log backup, and you had to restore to the...

first, let me thank you for the CREATE TABLE and INSERT code; it helps enourmously. way to go!

here's one way to do it; here i'm assuming the column is exactly...

did you drop your temp table so it can be recreated with the new column?

you had a few errors in what you were trying to do;

dbcc inputbuffer returns a table with 3 columns...you have to capture the columns.

your concatenation was not quite right;

hre's a...

maybe you are comparing it to the way oracle works? oracle is very user centric...delete a user, and you delete all the data owned by that user. could be gigs...

with massive updates like that I think it is a lot easier to undo or stop if you did the updates in batches, instead of trying to do the whole...

I'd seen a similar requirement before, so I created this procedure...you have to pass it two parameters: the tablename and the search term.

it uses dynamic sql to quiery just the...

ok, it's the middle of the night, and to boost my coolness, i answered a hundred or so questions in the Question of the Day section;

they don't get added...

oops duplicate reply from me somehow...