Post reply

How to write the Query

  • June 12, 2012 at 3:38 pm

    #147157

    Hi,

    I have a table with the following data structure-

    IDF1F2F3

    11nullnull

    1null1null

    1nullnull1

    I want to get the result in the following way -

    IDF1F2F3

    1111

    how can I write the Query?

    Any kind of help is appreciated.

    Thanks in advance.

    Maks............

  • June 12, 2012 at 3:48 pm

    #1500087

    h_maksuda (6/12/2012)

    Hi,

    I have a table with the following data structure-

    IDF1F2F3

    11nullnull

    1null1null

    1nullnull1

    I want to get the result in the following way -

    IDF1F2F3

    1111

    how can I write the Query?

    Any kind of help is appreciated.

    Thanks in advance.

    Maks............

    Like this maybe? You'll have to test it.

    select ID, max(F1), MAX(F2), MAX(F3)

    from dbo.MyTable

    group by ID

    order by ID;

  • June 13, 2012 at 1:16 am

    #1500176

    Hi All,

    I have used sys.dm_exec_query_stats and sys.sysprocesses to find long running queries particulary more than 60 minutes. But, as am not gud at sql scripting not able to join these two dmv's that would give results with database name, host name, spid ,user name , elasped time taken in minutes and sql text. Also, it should automatically kill queries that are running more than 60 minutes.

    Group: Awaiting for any response as early as possible.!

    Thanks.!

  • June 13, 2012 at 1:21 am

    #1500179

    glamourth (6/13/2012)

    Hi All,

    I have used sys.dm_exec_query_stats and sys.sysprocesses to find long running queries particulary more than 60 minutes. But, as am not gud at sql scripting not able to join these two dmv's that would give results with database name, host name, spid ,user name , elasped time taken in minutes and sql text. Also, it should automatically kill queries that are running more than 60 minutes.

    Group: Awaiting for any response as early as possible.!

    Thanks.!

    You really should start your own thread for new questions like this one.

  • June 13, 2012 at 7:58 am

    #1500379

    Thanks Lynn Pettis. I think it's working....

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply