HI Luke,

Sorry for all the inconvenience caused.

Tab1 structure

Create Table Tab1

(

name varchar(25),

description varchar(25),

Category varchar(25)

)

Sample data for Tab1

insert into tab1 (name,description,category) values ( 'caneditacc','editing','Acc')

insert into tab1 (name,description,category) values ('candeleteacc','deleting','Acc')

insert into...

Luke,

Pressed send button accidentally.

Tab1 DDL is as follows

tab1

(

name varchar(25),

description varchar(25),

category varchar(25)

)

tab2

(

groupid varchar(25),

description varchar(25),

field1 bit ,

field2 bit,

..

field(n) bit)

here name from Tab1 is represented as field column in tab2....

Luke,

DDL for Tab1 and Tab2 are provided below

Tab1

(

name varchar(25),

description varchar(25),

category varchar(25)

)

HI Luke,

can we use Pivot for bit field data. I have seen people using Pivot for getting aggregate result based on some criteria.

Please find the more samples below

tab1

(CanChange,Changegroup,Security)

(Canedit,changepermission,Accounts)

(canadd,addpermission,Accounts)

(candelete,deletepermission,Accounts)

(canupdate,ChangeGroup,Secuirty)

tab2

(g2,group2,CanChange)

(g2,group2,Canedit)

(g2,group2,canadd)

In...

Thank you guys for clarification.

Cheers,

Vids

HI Yeh,

I tried creating a function to hold the values from the select statement.

When they are executed separately they are fine but when used to return table...