Hi,

Thanks for your response. I would like to know is there any scenario where I can look that example.

Thanks,

blnbmv

Hi RBarryyoung,

I really appreciate for your help and thanks for your solution. I was referring to T1 table only everytime even If I have duplicate records and also even...

Understand the SQL, especially on SQL Server, works best as a set-manipulation language, not as a procedural language. The standard approach to this type of problem is NOT to...

Hi,

First of all, I really thank you for your efforts and your way of solving the issues of the members in this community.

I will try to explain what exactly I...

Hi jeff,

Thanks for your interest. I dont want to update my fromtable. I just want to insert into

Initially the target table contains the below records that is...

Hi members,

I thank each and every Member for giving support in solving my issue and also I am proud about moderators and also Mentors of this group as there doing...

Hi jack,

Thanks a lot.

I issue is resolved.

Thanks,

sainath

Hi

I am new to this forum and also I am new to sql server can you please suggest me like what sort of certifications will be there and where can...

Hi,

So you mean to say cursor and while both take temp tables and also you said that you wont do like that then can pls explain me how you would...

HI,

First of all I appreciate for your answer. Actually its not an interview question. I have a 1 million records in a table and I need to find out one...

hi

Thanks a lot for giving your valuable time in solving the problem. But what i need is i want the tree elements above 70 in one temptable and below...

Hi,

When I was trying the hierarchyup CTE and it was going not stoping on reaching at the top level.

can you please look into that give some solution

thanks,

sainath

hi,

I think when you type sp_help 'tablename' you will get to know what all the foreign keys applied on the table.

sainath

Hi,

I think you are absolutely right and I confirmed that 40 and 60 are also not needed for me. I really appreciate your help.

If u can find any solution...

Hi,

I think even if i miss 40 and 60 also there is no problem. Can u pls send the recursive query for that.

thanks,

sainath