Looks like I deleted the group by from my original code as I cleaned it up for posting, sorry. But, yes, we were definately thinking along the same lines.

If you don't mind me asking, which version did you select?

I had to fix some of the data in the second data set you PM'ed as the number of columns did not match. Some of the selct statements only...

James.N (4/17/2009)

---

Hi ,

Can any one help me with T-SQL correct syntax for this logic.

I wanted to upsert my destination(D) table...

does this accomplish what you are looking to do?

with MessageCount (

ID1,

MsgCount,

StartDate,

EndDate

) as (

select

...

Brain_Killer (4/21/2009)

---

Christopher Stobbs (4/21/2009)

---

ok here is break down of the code:

--Month

WHERE [YourDate] BETWEEN

DATEADD(mm, DATEDIFF(mm,0,DATEADD(mm,-1,GETDATE())), 0)

AND DATEADD(ms,-3,DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0))

The from part of the date:

Step 1: DATEADD(mm,-1,GETDATE() = get the...

I need related sample data between the two tables. The data previously provided results in an empty result set. I'm not sure what values to actually change or...

Jeff Moden (4/20/2009)

---

I knew it would stumble on VARCHAR(MAX)... I just didn't realize how bad. However, on the thread that Flo has been orchestrating, he sent me a PM...

Here is another attempt at solving your problem:

CREATE TABLE #CheckIn

(

CheckInID INT IDENTITY(1,1)

,UserID INT

,Comment VARCHAR(50)

)

-- insert some sample data

INSERT...

Sounds like you need to redefine your problem somewhat. How about providing something closer to the actual problem we are working on. Can you give me something closer...

Instead of searching through 300+ posts, could we get bruce t's problem posted to a new forum thread and a link added here for anyone interested to follow to that...

Is there more to the real world data that would support the sequence of data entered? is there a date field or other form of identification that signifies the...

Goldie Graber (4/20/2009)

---

As a post script, I ended up using Bevan's method.

It works well on tables with up to a few million records. Takes a minute or two.

When I had...

Mr Dassin,

You really have missed the point. Stop with the hyperbole and attacks on SQL Server (and all its cousins). Provide straight, well supported facts. Provide actual...

ooommmmmmmmmmmmmmmm