what data you have provided is not sufficient, take some time to follow the link given above to post a question in the forum, and post the proper information.

although i...

could u post ur DDL and some sample data.

output :

id(No column name)Employee_No

1Yes125504

2Yes121186

3NO129876

output :

Hi,

i am not so clear about your requirement.

As per your question, i think this solution may work for you, try it once and let me know

CREATE TABLE #Details_Emp

...

Thank u all....

i just took a chance

create table XYZ(parent_node_id int, child_id int)

insert into XYZ select 0000000000,0000000001

insert into XYZ select 0000000000,0000000124

insert into XYZ select 0000000000,0000007953

insert into XYZ select 0000007953,0000007954

insert into XYZ select...

:Wow:

Ninja's solution will work , better to use case rather then looping through it. 😎

sry for code alinement's.

as per information given by you,

hope this will work

do let us know if you need something more

CREATE TABLE #temporary(num INT,code_1 VARCHAR(40),code_2 VARCHAR(40))

INSERT INTO #temporary (

num,

code_1,

code_2

) VALUES (

1,...

declare @TestTable table (

ID int,

EmployeeID int,

Salary varchar(12)

)

insert into @TestTable (

ID,

EmployeeID,

Salary

)

values

(1, 5, '1000'),

(2, 6, '2000'),

(3, 7, '1000'),

(4, 5, '2000'),

(5, 6, '2500')

SELECT tt.* FROM @TestTable tt INNER JOIN (

SELECT MAX(id) id,EmployeeID...

hope this will work.

Select id, SUM(L_VALUE), SUM(B_VALUE) FROM (SELECT DISTINCT ID, L_VALUE , B_VALUE FROM MYTABLE) t GROUP BY ID

Hi Suri,

have a look to this link to get idea to create a dynamic pivot query.

http://beyondrelational.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

here is a small document which i found very useful for naming convention.

http://www.cms.gov/DBAdmin/downloads/SQLServerStandardsandGuildelines.pdf