You'll probably get much more advice on this once you've posted the DDL and some examples (test data and expected results). But, until then, one thing that I'd question...

tosscrosby-60625 (1/20/2010)

---

Isn't that...

I just took a closer look at the code and realize that the insert doesn't specify the column names.

Try adding the list of columns right before the VALUES clause

insert into...

One thing that jumps out at me is that column5 is defined as a date, but your script tries to insert a string ('column5') there that cannot be converted to...

Looks like you may already have what you need, but since I'd just a couple of weeks ago had a similar case, I figure I'll share it. The main...

It looks as though the resume-hunter has come around in attitude. Congratulations to Lynn, Gail, Gus and the rest of you for not only helping him/her with the technical...

Gianluca,

I had to read your last post twice to be sure you'd said you were talking about a bruhaha in Italy, and not in the US. There's been...

The 2008 BOL (link provided by Cliff) is moderately ambiguous, don't you think?

The following table lists and describes the severity levels of the errors raised by the SQL...

Bravo! Excellent example of explaining a technique that, once understood, seems so very natural. And, once again the discussion adds tremendously by making it clear that this is a...

Cliff Jones (1/12/2010)

---

Ernie Schlangen (1/12/2010)

---

Can someone verify for me that this is different in SQL 2008 vs SQL 2005? I get a different result using 2005 (I don't have...

Cedric,

Thanks for the link about Table Types.

The QOD asks about table types, but the BOL link in the explanation refers to user defined data types. I find nothing about...

Comparison of data can be a bit tricky if you don't have any absolute way to tie the rows of the two tables to each other. Because of this,...

I have heard a response to "wouldn't touch it with a ten-foot pole" as "Heck. I wouldn't touch it with a six-foot Romanian". (Sorry, Gail, but the pun...

You've made a good start by seeing that the key to this is using DATEDIFF and DATEADD with the "mm" option. I just went through a similar process to...

I just posted in the "save my job" thread a question to the OP as to what he expected to get in SSC that he didn't already get from SQLTeam...