Viewing 15 posts - 16 through 30 (of 44 total)
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...
August 21, 2008 at 7:55 am
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...
August 11, 2008 at 7:57 am
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...
August 11, 2008 at 6:34 am
Ya that's correct have to use the multiple datename function
for that requirement
Thank's for helping me.
Chandru.
August 11, 2008 at 6:05 am
Hi,
Can you be more precise in your table structure..
i.e
Pri_ID RefID ...
August 8, 2008 at 5:27 am
Yes Chris i too tried in that way but it will create problem
Let me try in a different scenario
Thanks
Chandru.
July 30, 2008 at 6:42 am
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...
July 30, 2008 at 5:56 am
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)...
July 30, 2008 at 5:10 am
Hi ,
Can you post some sample data for Us??
Thanks,
Chandru.
July 23, 2008 at 5:15 am
Thanks Hari,
I got the Required O/p thanks for your reply.
Regards,
Chandru.
July 16, 2008 at 2:08 am
Hi,
You can achieve this through the Linked server concept
plz study that concept in online.
July 15, 2008 at 7:36 am
Nice logic hari..
Thanks for posting the code.....
July 15, 2008 at 6:40 am
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
...
July 15, 2008 at 4:00 am
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...
July 11, 2008 at 7:01 am
Viewing 15 posts - 16 through 30 (of 44 total)