Nope, sorry.

Hmm, I hadn't thought of that.

Ah, that's easy then: can't be done.

Heh. Good point.

Well, I am pretty lost as to exactly what you are trying to do. Please read this article and then provide the information that it recommends: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Glad I could help.

Well, for one thing, you cannot have a GO in the middle of a stored procedure. You shouldn't need it either.

Actually, the query that you poseted was syntactically incomplete.

What does this query return?

SELECT Customer, [CategoryType], DealMonth

, STDEV(Trade_Count) AS Trade_Count_Stdev

, COUNT(Trade_Count) AS Trade_Count_Records FROM #T2

GROUP BY Customer, [CategoryType], DealMonth

This sounds like an RDP font mapping issue. Try lowering your display size and/or color density. If that does not work, then try playing around with the settings...

I think that the second choice would be better stated as "Delete * From Table".

The problem is, the "Delete table" choice could mean the "Delete" table menu selection from SSMS,...

Not true. SMO works just fine with sql2000, I used to...

Agreed, Jeff.

Without the business reason for this, it is really hard to understand why a BIGINT IDENTITY column would not fulfill the requirement.

Exactly, Grant.

The general rule of thumb that you want to follow is: if columns in two different tables hold the same values and are intended to match each other then...

Lowell (1/21/2009)

---

really, i think there are only like 6 questions that keep getting repeated over 90 percent of the posts, and the other 10% are the ones that we enjoy.

The...

Here you go. this is certainly not the fastest, but my brain is not working right now.

;With calltimes as (

Select callstart as calltime From calltable

UNION

Select callend From...