Hi,

I should have been cleared in my Description.

What I want is the following.

1. Group by ParentID and only select the MAX RevNR for Each Group.

The result will have all the...

Hi,

I donno what I am missing.But this one task is proving to be the most challenging for me.

Sorry for the lack of experiance on CTE.

Can anyone please review the following...

Hi ,

This is What I tried.

Finally I am trying to get Document ID as well into the Final Table.

CTE work fine if I execute from "WITH" till end.

--Indent Numbering

--select *...

Hi,

I cant get this it work.I have created over 7-8 temp table in the query.Everything works fine exxcept Putting CTE Data into Final Temp Table.

Regards

Ravi T

Hi All ,

I got answer to my query but ran into another problem.

I am not able to Add rCTE to a Temp Table.

and Every Part has a DocID how do...

Thanks Jacob,It worked like charm.

Regards

Ravi T

Hi,

thanks for the reply.It worked

Thanks

Hi Sean,

Thanks for the response.

Number of resulting coloumns will be consistant.

From the query you posted ,i could not get the result...

HI all,

Ive hit another wall!!!!!!!!.......i have another data set which has date stored as text and the format is dd/mm/yy.Now how...

Hi Mark,

yes i can do that but,how will sql know that my text is in dd/mm/yyyy format and not in mm/dd/yyyy...

Hi,

Have you gone through the following post.I had a similar problem.

http://www.sqlservercentral.com/Forums/Topic1322992-392-1.aspx

Regards

Ravi T

Hi,

I am using report server in native.The default one.

Regards

Ravi T

Hi all,

I am having one more trouble with the query.I have one more column added to this query called "attempt".

I want to show ans...

DECLARE@Student...

Hi,

How do i query the above result by using where clause?..

i want to use where Student Name like "Stu%"

regards

Ravi T