Really late payments and refusal to pay legitimate bills are one of the big warning signs of a company that is about to go bankrupt.

If they're out of money, a...

Ninja's_RGR'us (4/21/2010)

---

Michael Valentine Jones (4/21/2010)

---

Tell them to pay your boss everything they owe him first and you want a $10,000 retainer before starting any work.

That should cut off any further...

Tell them to pay your boss everything they owe him first and you want a $10,000 retainer before starting any work.

That should cut off any further discussion. If they...

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.