Why do you have the "go"s in there?

Why not:

select * from tbl

if not exists(select * from othertbl)

insert into tbl1(fld1)

values(val1)

else

select 'done'

Sorry to hear that. Maybe you shouldn't have made that previous post :w00t:

old, but it works

http://www.sqlservercentral.com/articles/Administering/pushftp/473/

http://www.sqlservercentral.com/scripts/Miscellaneous/30830/

Where did you get the errors? From a client? It might be an issue there.

SQL doesn't report space issues, unless you add enough data that you run out of space...

There is no best idea. There are ideas that make sense at times and in situations.

Grab a calendar, muti year

Grab a dart

Send b) into a)

Boy if I lost this job I hope I could get an IT job. I guess you never know.

I would probably struggle along in another IT job for another 10...

Usually you enclose stuff in the tag. So for code, you'd highlight the code, then click the "code" item to the left and it brackets what you've highlighted with [...

Tab settings can be inconsistent, and so if you try to line things up, or open someone else's code, 2 tab stops could result in things being unreadable. Plus everyone...

It's not so much that they give different advice, that if you decide to go and restore pages or work through the corruption, the $250 is a cheap few hours...

I'm not sure you need to change ladders. Making big saves, however, does make you look good, it's remembered, and it might mean that at review time you stand out...

Great editorial and interesting responses. Thanks for the break, Phil, I had run snowboarding yesterday 🙂

I wonder if we'll start to change the way we write procedures in the future?...

Why did this thread start?

I feel old until I read some of these posts.

Been driving on four wheels for 26 years, 25 cars in that time, if you include the...

Ha, I rarely drink at home. It's all you guys at TechEd and Pass that get me into trouble!