Dear John Mitchell, tertiusdp, David Burrows, ColdCoffee :

Thanks for your excellent effort. With all your help I got it what I want.

Great effort.. Once again thanking you all for...

Table_A

ID USERID USERNAME ISADMIN

11 MIKE 0

22 NILOFAR 0

33 SABY ...

Dear Friend,

Thanks for your effort and quick reply.

The actual problem is:

If the logged user is NOT ADMIN then I should fetch the invoices pertaining to that user.

If the logged user...

Dear Friend,

PFB the DDL Script................ I made a lot of attempt by using "case" and "temp" table etc... but could not arrive any solution.. looking for a good solution..

/****** Object:...

Dear vetri,

What you have provided was sounds fine..but actually im looking for any in-built function like how oracle provided the "DECODE"........

hi,

The decode functionality in oracle is something similar to

"if then else...". But what you have stated is "select case...end"

let me clearly explain you a scinario,

table student contains name...