Dear all,

I'm sorry for responding to your replies and i also please you for not clearly explaining my requirement

i have incorparated the following logic to generate the...

Thanks kevriley & peso for helping me...

Chandru

Hi peso ,

Actually my requirement is like i wanna to produce the o/p like

Monday , August 11, 2008 but if i try with the Query that you have posted...

Dear all,

I have got the solution for my problem but is it anyother way to optimize

this solution

select datename(dw,'2004-01-07 00:00:00') + ' , '

+ datename(mm,'2004-01-07 00:00:00') + +' '+

datename(day,'2004-01-07...

Ya that's correct have to use the multiple datename function

for that requirement

Thank's for helping me.

Chandru.

Hi,

Can you be more precise in your table structure..

i.e

Pri_ID RefID ...

Yes Chris i too tried in that way but it will create problem

Let me try in a different scenario

Thanks

Chandru.

Hi Chris,

1.More than one rows will be returned

2.And i dint understand what is need of using a local temp table here??

And if we use a temp...

Yes Chris you are correct

then Can you help me on this

My scenario is nothing but

If new fk_id is passed (i.e fk_id which is not present in custom_data table)...

Hi ,

Can you post some sample data for Us??

Thanks,

Chandru.

Thanks Hari,

I got the Required O/p thanks for your reply.

Regards,

Chandru.

Hi,

You can achieve this through the Linked server concept

plz study that concept in online.

Nice logic hari..

Thanks for posting the code.....

Here is the another solution fro my problem

Check it out...

alter procedure get_screen_report

(

@screen_id int

)

as

begin

drop table random

drop table temp

...

Dear all.,

I have got the solution for my problem the following is the procedure i have created..

if object_id('get_screen_field_report')is not null

drop procedure get_screen_field_report

go

create...