Forum Replies Created

Viewing 15 posts - 16 through 30 (of 44 total)

  • RE: Generate random number

    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...

  • RE: Date function

    Thanks kevriley & peso for helping me...

    Chandru

  • RE: Date function

    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...

  • RE: Date function

    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...

  • RE: Date function

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

    for that requirement

    Thank's for helping me.

    Chandru.

  • RE: Retreiving the Childs in a single statement.

    Hi,

    Can you be more precise in your table structure..

    i.e

    Pri_ID RefID ...

  • RE: Problem with alias name

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

    Let me try in a different scenario

    Thanks

    Chandru.

  • RE: Problem with alias name

    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...

  • RE: Problem with alias name

    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)...

  • RE: SELECT and GROUP BY

    Hi ,

    Can you post some sample data for Us??

    Thanks,

    Chandru.

  • RE: Left Outer join

    Thanks Hari,

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

    Regards,

    Chandru.

  • RE: Replication

    Hi,

    You can achieve this through the Linked server concept

    plz study that concept in online.

  • RE: Need to remove duplicate records and get distinct values

    Nice logic hari..

    Thanks for posting the code.....

  • RE: Dynamic Pivot

    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

    ...

  • RE: Dynamic Pivot

    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...

Viewing 15 posts - 16 through 30 (of 44 total)