Hi Joe.... thanx...for the reply... can u suggest some good book / link to refer for design methodology....

Yep i dont create dynamic sql in procedure.... but i want to pass...

Hi Thanks for reply,

I agree with Joe... post the problem...

So the problem is I have couple of procedure. One is master procedure and other procedure is called from the...

Hello i am not mentioning any type while defining the cursor. So i suppose it will be default type i.e. read only

oops, sorry... thanx.... yes the query is giving desired output....

nope, it gives

Tranporter_Name State_id

c                          Null

d                          Null  

e                          Null

Hi all, slightly different query, i have two tables, in one table i have list of Traanporters and in other table i have transporters associated with states. for e.g. the data in transporter table...

Hi there,

yep it works....Thanks,

Is it possible to write a single query which returns the resultset in desired format......

select  @sqlcol = @sqlcol + ' ' + COALESCE (rtrim(name), 'NULL') from country_master where id >...

hey thanx for the reply. it seems i can do it with these.

Actually i want a bit complicated output....

I want to write a query which returns null or empty...

Hi Thanks,

But the issue is i want to write a query to fetch the records in desired format. is that possible ?

Regards,

Snehal