Forum Replies Created

Viewing 15 posts - 61 through 75 (of 99 total)

  • RE: Data Insert issue

    Thanks Phil.

    Begin and Commit tran worked. Does this avoid logging ?

    I have insert and Update . No delete required.

  • RE: Data Insert issue

    Phil Parkin (12/23/2013)


    After creating your temp table, try putting an index on its Id column.

    Phil,

    I have done so, but have same results.

  • RE: Pass a parameter to OpenQuery?

    Jeff Moden (8/30/2012)


    It's been several years since I've had to work with OPENQUERY but I believe the following will work...

    select <stuff ...>

    from OPENQUERY(Banner_Prod, 'SELECT a.Major

    ,a.FIRSTNAME AS NameFirst

    ,a.MIDDLENAME AS NameMiddle

    ,a.LASTNAME AS...

  • RE: select top 1 value per group

    not a secrete 🙂

    I have product related data in database. one of the ex.dev wrote query to fetch results in 3 with top1 as I mentioned. Now I have got...

  • RE: select top 1 value per group

    yes, but I have to add some other conditions and they worked with your logic 🙂

    I would thank you both for valuable suggestions

  • RE: select top 1 value per group

    Thank you Sean Lange, it worked 🙂

  • RE: Fetching records optimally

    Thank you Sean.

  • RE: Fetching records optimally

    tried case

    SELECT NAME ,

    CASE WHEN id = 4

    ...

  • RE: How to Use SQL Profiler

    I got the answer

    Beginning with SQL Server 2005, the server reports the duration of an event in microseconds (one millionth, or 10-6, of a second) and the amount of CPU...

  • RE: How to Use SQL Profiler

    I have completed the profiling and now have all the data in table 🙂

    I am using following query to extract results. I have observed that for statements data is saying...

  • RE: How to Use SQL Profiler

    thank you very much SSCrazy. These queries are really great to have. Can I modify these queries to extract queries executed by specific user?

    I want to use profiler too, as...

  • RE: XML Column Read

    thank you. 🙂

    this is what I have implemented

  • RE: on delete trigger

    thank you SSCrazy

    it worked 🙂

  • RE: how to read trace table

    Lowell (10/15/2012)


    it's fairly easy.

    first, doa SELECT * FROM sys.traces; you'll probably see traceid = 1(the default trace) plus any other traces you have created (2,3,4 etc)

    select the trace id...

  • RE: Dynamic column name?

    not sure about your exact problem.

    can't you use "AS" in your select statement ?

    select column as Date from ...

Viewing 15 posts - 61 through 75 (of 99 total)