Forum Replies Created

Viewing 15 posts - 571 through 585 (of 616 total)

  • RE: TSQL by Duration(Respone Time)

    I'm not entirely sure what you are asking, however in general if you are doing performance tuning like that you can take the Profiler results and store them into a...

  • RE: best way to find nulls? where [MyColumn] is null

    Pseudo code Jeff, Pseudo code.

  • RE: 10/23/07

    Ok, maybe its because I have no idea what a golf leaderboard is supposed to look like but I thought it was DENSE_RANK.

    IE an answer might be

    Joe 277 1

    John 277...

  • RE: best way to find nulls? where [MyColumn] is null

    To the best of my knowledge that really is the best way to do it. If the columns are indexed that should go fairly quickly though.

    Kenneth Fisher

  • RE: How do I find the differences?

    If you are pulling a file from excel it could have been loaded into it orriginally. Also the small squares arn't always carrage returns.

    There are some functions out...

  • RE: How do I find the differences?

    Ok .. just to see try

    select * from upload where LTRIM(RTRIM(people_code_id)) ='P000008270'

    Also confirm that the string 'P000008270' is correct in this particular query. You may be dealing...

  • RE: How do I find the differences?

    Its possible you have some weird ascii character that may be invisible but still there. Its an unusual thing to have happen but it does happen. Try running...

  • RE: How do I find the differences?

    Because you have to have some kind of condition to test on. If you did a NOT EXISTS (SELECT * FROM TABLE1) with no condition then the where clause...

  • RE: How do I find the differences?

    select distinct p.first_name

    ,p.last_name

    ,p.people_code_id

    from people as p

    inner join peopletype as pt

    on p.people_code_id=pt.people_code_id

    where p.deceased_flag='n'

    and pt.people_type='alum'

    AND NOT EXISTS (SELECT * FROM Upload WHERE Upload.First_Name = p.First_Name

    AND Upload.Last_Name = p.Last_Name

    AND Upload.People_Code_Id = p.People_Code_Id...

  • RE: How do I find the differences?

    Once you have the excel data into a table do something like this :

    INSERT INTO ExcelTable

    SELECT Field1, Field2, ...

    FROM DBTable

    WHERE KeyInfo NOT IN (SELECT KeyInfo FROM ExcelTable)

    At least that...

  • RE: How do I find the differences?

    I'm not sure if this is the best approach or not but I would use a DTS package. Load the excel file into a temporary table. Update it...

  • RE: sp_executesql

    If it makes you feel any better debugging sp_executesql can be a royal pain.

    Here is a quicky sample

    declare @tablename nvarchar(50)

    declare @sql nvarchar(1000)

    SET @tablename = 'sysobjects'

    set @sql...

  • RE: Alter column datatype from text to varchar

    Unfortunatly in SQL 2000 you can not convert from text directly. What enterprise manager is doing behind the sceens is creating a temp table, loading it with the data...

  • RE: Deadlock issue

    I would try changing the count(*) to a count(1). It is marganally faster. Also do you have any where conditions, groupings etc on the count? If so...

  • RE: SQL 2000 - Detached a database. Reattached and the file is read only

    If the process you killed is a long running command .. say a large insert .. then when it is killed it does a rollback. If you do another...

Viewing 15 posts - 571 through 585 (of 616 total)