Forum Replies Created

Viewing 15 posts - 1 through 15 (of 44 total)

  • RE: Improve running time of custom function

    Jeff Moden (7/29/2015)

    I got off work just about an hour ago (9PM) and I've been looking at this code and I have to admit a bit of confusion. I...

    July 30, 2015 at 9:45 am

    #1816193

  • RE: Improve running time of custom function

    WayneS (7/29/2015)

    One thing that I note here is that you are using a Multi-Statement Table-Valued Functions, and they consist of just inserting data into the (output) table variable to be...

    July 29, 2015 at 3:09 pm

    #1815945

  • RE: Improve running time of custom function

    Jeff Moden (7/29/2015)

    Before I make any suggestions, I need to know two things, please.

    1. How many rows are in the NetworkItem table?

    2. How often does data change in...

    July 29, 2015 at 2:44 pm

    #1815936

  • RE: efficiency of query approaches

    GilaMonster (3/20/2011)

    What does your testing show? Have you looked at the execution plans, duration and IO statistics of each?

    The 4 queries return the same result like:

    SKUGroupIDSKUMain

    S20003120003S200031

    M20003220003S200031

    T20003320003S200031

    A10092110092A100921

    B10092210092A100921

    G30005130005G300051

    March 20, 2011 at 12:30 pm

    #1301051

  • RE: combine queries

    terrance.steadman (7/10/2009)

    Greetings,

    Please take a look at the code again, especially in the WHERE clause.

    WHERE

    (

    @OtherAddressDetails = 'member address'

    AND OtherAddressDetails = @OtherAddressDetails

    ...

    July 10, 2009 at 9:09 am

    #1023122

  • RE: combine queries

    Jack Corbett (7/10/2009)

    In order to eliminate the IF...ELSE we need to know what you would expect returned and in order to know that it would be helpful if you posted...

    July 10, 2009 at 9:00 am

    #1023113

  • RE: combine queries

    terrance.steadman (7/10/2009)

    Greetings,

    I had missed that the IF statement was on the variable when considering the 2 statements. So, here is a slightly modified statement from the one I had...

    July 10, 2009 at 8:48 am

    #1023100

  • RE: combine queries

    kramaswamy (7/10/2009)

    The two cases look identical, am I missing something?

    Depending on what you want to do, you could do something like:

    declare @OtherAddressDetails nvarchar(1000)

    set @OtherAddressDetails ='member address' -- or to...

    July 10, 2009 at 8:46 am

    #1023095

  • RE: how to nest hierarchical rows

    Bevan keighley (4/6/2009)

    The first list is sorted by nodeID - the second list starts with the parent (the one with no parentID listed) and then lists the child, then it's...

    April 6, 2009 at 9:09 pm

    #973049

  • RE: .NET Guid.Empty and equivalent uniqueidentifier

    gtschech (4/2/2009)

    Guid.Empty is a GUID consisting of all zeros.

    yours

    Günter

    Thank you very much.

    April 5, 2009 at 8:50 am

    #972166

  • RE: Find the dependents on a column of primary table

    GSquared (2/24/2009)

    You could build something using the sys.foreign_key_columns system view. Not sure why you wouldn't want to use Joins.

    Thanks for your reply.

    The reason I do not want to use...

    February 28, 2009 at 7:04 am

    #951523

  • RE: Invalid column name and ALTER TABLE

    Sergiy (6/19/2008)

    Easiest way - in QA menu click Query -> Show Server Trace.

    When I comment out the last (the 3rd SELECT query that has the problem) and turn on the...

    June 20, 2008 at 2:32 pm

    #832079

  • RE: Invalid column name and ALTER TABLE

    Sergiy (6/18/2008)

    You missed the point:

    When your procedure (or batch ) is being compiled

    Run you full batch with Trace ON and you'll see - no statements are executed.

    So can you tell...

    June 19, 2008 at 8:47 am

    #831156

  • RE: Invalid column name and ALTER TABLE

    Sergiy (6/17/2008)

    When your procedure (or batch ) is being compiled there is no RowID in the table yet.

    Howerver, if I comment out the last query, and let the 2...

    June 18, 2008 at 8:20 am

    #830481

  • RE: Invalid column name and ALTER TABLE

    Howerver, if I comment out the last query, and let the 2 preceeding queries run, I can see the rowID column in result DTSs. That is weird.

    Any idea?

    June 18, 2008 at 8:19 am

    #830479

Viewing 15 posts - 1 through 15 (of 44 total)