That is the problem. For the "quirky update" to work you need a clustered index on...

The only change to my code that I could suggest is 1) make sure you have declared the clustered index properly, and 2) change the index hint from 0 to...

Awesome! ...

Lynn Pettis (4/20/2009)

---

Here is another attempt at solving your problem:

CREATE TABLE #CheckIn

(

CheckInID INT IDENTITY(1,1)

,UserID INT

,Comment VARCHAR(50)

)

-- insert some...

Triggers, yes,...

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...