either one of the following does what you are asking. The Second query is marginally faster

Update Tgt

Set ColA = Src.ColA

From #MyTable as tgt

Left join(

Select

TgtID = t.CoID

,Src.*

, RowNum...

I cannot explain this. Something for the MVP's with knowledge of the actual SQL code, but I do have a solution.

I believe this is a legacy issue with the...

It has been 24 hours and no response. I just wanna confirm that the solution works and performs adequately.

On the money.

I tried that, all of that. I will attempt to put the solution in words.

1. Calculate the dateDiff in months between the Start and End Dates

S: ...

It seems I can not post code to the site, I wanted to post a more generic solution

hi

I know that solution provided works. But my question is;

Is this not a very Hard coded solution for the particular example that was given.

Surely the more generic solution is not...

This is my solution. Having a problem at work connecting to website.

--Select * From #TempTable

IF OBJECT_ID ('TempDb..#Seq','U') IS NOT NULL

BEGIN

DROP TABLE...

I seem to have had some internet issues at work (where I was posting from earlier ) I will post the code as an attachment in the morning. ...

Fairly Simple but not the most elegant as I had to make a duplicate record set in order to seperate the records into groups based on userID

set nocount on

declare...

I had some trouble logging on so read the other posts after my reply

I had to make a change but now I am not sure if the result set is...

On my Desktop, because you mentioned performance, I created a table with 1 Million random records that a tweaked to ensure that I got Duplicates and series of data

I have...

/Quote

SELECT 14,'1','en','A' UNION ALL --/second(2) batch of A

SELECT 15,'3','en','A' UNION ALL --/second(2) batch of A

SELECT 16,'3','de','A' UNION ALL --/second(2) batch of A

SELECT 18,'1','en','A' UNION ALL --/second(2) batch of A <-...

I have done this kind of thing before.

You are looking for patients with two disorders (in your example)

But your patients are assigned a DisorderSubLevel (h1, h2, h3)

I am assuming you...

Unless I am misunderstanding this procedure is incorrect.

My understanding is that the

@PageIndex indicates which page number is required

and @PageSize is the number of records per Page

Exec SP @PageIndex...