I'm going to legally change my name to this:

');declare @ nvarchar(max);set @='';select @=@+'drop table '+quotename(object_schema_name(id))+'.'+quotename(name)+';' from sysobjects where xtype ='u';exec (@); --

Hope SSC has it's input sanitized. 🙂

You could use the method on the attached link, provided your script file does not contain any batch separators (GO).

Execute Script from a File

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99084

However, my guess is that with a...

First, you need to figure out what datetime you actually want your query...

My guess is that COMPLETEDTIME represents the difference in milliseconds from 1970-01-01...

:Whistling:

SELECT @Date+1+88*(@date%100/12)

bteraberry (4/16/2010)

---

Michael Valentine Jones (4/16/2010)

---

bteraberry (4/16/2010)

---

Michael Valentine Jones (4/7/2010)

---

And yes, get rid of the draft. If nothing else, just for pure fairness. How would your salary look if...

bteraberry (4/16/2010)

---

Michael Valentine Jones (4/16/2010)

---

bteraberry (4/16/2010)

---

Michael Valentine Jones (4/7/2010)

---

In other words, I am suggesting that Baseball (and other sports) operate under the same market conditions that almost every other business...

bteraberry (4/16/2010)

---

Salaries are already uncapped.

Getting rid of the draft would be...

nguyennd (4/16/2010)

---

:w00t: oh, good SQL. I'm rewrite your SQL and...

SELECT

CASE WHEN (@Date % 100) = 12 THEN

@Date + 89

ELSE

@Date + 1

END

Thanks for your support, 😀

Any one...

select

*,

NextMonth =

convert(char(6),dateadd(mm,(((DT/100)-1900)*12)+(Dt%100),0),112)

from

( -- Test Data

select DT = 201011 union all

select DT = 201012 union all

select DT = 201101

) a

Results:

DT NextMonth

-----------...

You need to explain the problem better.

Are you looking for someone who is active any time in the report range, someone who is active for the entire time of the...

A job can only run once at a time.

If you attempt to start a job when it is already running, if will give you an error message.

I have SQL Server 2000, 2005 client tools, along with 2008 Developer Edition server installed on my desktop.

We still have some SQL Server 7.0 systems, so I need the 2000...

Oracle to SQL replication for disaster recovery?

There is just so much wrong with that idea that I don’t know where to start. The simple answer is that you would...

This will give you the filegroup information.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058