I just do this:

IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME ='newtable') DROP TABLE newtable;

mwyss (2/28/2014)

---

below86 (2/28/2014)

---

paul.knibbs (2/28/2014)

---

Since video games are fair game for adaptation (they're even planning a Minecraft movie...words fail me :crazy:) I wouldn't mind seeing an adaptation of Planescape: Torment. It's...

I may be only one of a few who actually liked the Green Lantern movie, it could have been better. But the whole concept lends itself to easily change...

paul.knibbs (2/28/2014)

---

Since video games are fair game for adaptation (they're even planning a Minecraft movie...words fail me :crazy:) I wouldn't mind seeing an adaptation of Planescape: Torment. It's one of...

Wonder Woman!! Linda Carter is still hot.

george sibbald (2/27/2014)

---

below86 (2/27/2014)

---

I have often said I avoid stored procedures for the most part. But this too has always seemed odd to me. You are essentially replacing the...

I have often said I avoid stored procedures for the most part. But this too has always seemed odd to me. You are essentially replacing the entire code when...

If you want to use the name of a calculated field I think the only way to do it would be to do a sub query. But for a...

Thanks for posting this script. I took what you did and applied it to another SQL I got here that looked for values in stored procedures. I don't...

bob_balok (2/21/2014)

---

So I guess I have to reply to this since it seems like such a fantasy to people. I am the guy who's company lets us work from...

Steve Jones - SSC Editor (2/21/2014)

---

BigAl (2/20/2014)

---

Steve: Thanks for the editorial! Amen! Disconnect every now and then! And I agree/have had similar experience as many of the posters here. I've...

Thanks Sean, I was trying to figure out something similar the other day and couldn't think of how to get it down to one row per ID. Without doing...

I would love to work remotely. Anyone willing to let me work from Hawaii? 😎

I would be willing to work around any time zone differences. 😀

To the other...

This looks to be a double posted question.

Here is what I replied to the other post. Why would you need 2 when statements? Never mind I see why, didn't...

See if this does what you want.

declare @startdate datetime;

declare @trandate datetime;

set @trandate = '02/05/2012';

set @startdate = (select casewhen @trandate between '06/04/' + cast(year(@trandate) - 1 as char(4)) and '05/04/' +...