Forum Replies Created

Viewing 15 posts - 211 through 225 (of 859 total)

  • RE: error while attaching adventureworks in 2008r2

    i found installing from the script file was the easiest for me. i had to go and remove any full text stuff as i dont have full text indexing...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    September 10, 2012 at 8:16 am

    #1535714

  • RE: Fun with Outer Joins

    SQLKnowItAll (9/10/2012)

    capn.hector (9/10/2012)

    SQLKnowItAll (9/10/2012)

    I suppose I don't understand the point. We know that when records do not exist in the RIGHT table that NULLs are returned. So why...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    September 10, 2012 at 8:07 am

    #1535706

  • RE: days into completed weeks only

    LoosinMaMind (9/10/2012)

    Hi

    how do i easilty convert days into weeks (obviously Days/7 will give me weeks as decimal)

    Problem i have is I only want to count completed weeks:

    ie: 20...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    September 10, 2012 at 7:47 am

    #1535691

  • RE: Fun with Outer Joins

    SQLKnowItAll (9/10/2012)

    I suppose I don't understand the point. We know that when records do not exist in the RIGHT table that NULLs are returned. So why would we...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    September 10, 2012 at 7:40 am

    #1535685

  • RE: format for phone number

    In my shop we store the 10 digit us number as a VARCHAR(16) (to allow for international numbers) but do not store any country code information or formating with the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 29, 2012 at 6:43 pm

    #1531690

  • RE: Selecting records based on count

    Take a look at HAVING. from your description i think that is what you are going to want.

    http://msdn.microsoft.com/en-us/library/ms180199.aspx

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 27, 2012 at 4:03 pm

    #1530552

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/24/2012)

    I completely spaced asking, but who from The Thread is going to be here in OKC for #sqlsat125?

    Im going to be at #sqlsat154 in St Louis and am...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 24, 2012 at 5:21 pm

    #1530003

  • RE: Reverse Of Number without Using reverse()

    Here is one with a rCTE. to put it back together you can use FOR XML PATH or SELECT @var = @var + part. i have done one...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 3, 2012 at 3:24 pm

    #1521652

  • RE: Reverse Of Number without Using reverse()

    Well here is my solution. since we can order by when we take our substring we can just put the FOR XML PATH ('') in that query and not...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 3, 2012 at 9:25 am

    #1521471

  • RE: rolling monthly analysis

    Chrissy321 (8/2/2012)

    I'm fascinated.....I am working with Lynn's code.

    Say I wanted certain clients those whose ClientID was < than 3.

    Clearly I can add any conditions to the final SELECT statement but...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 3, 2012 at 7:58 am

    #1521407

  • RE: Intersecting Date Ranges

    diamondgm (8/3/2012)

    diamondgm (8/2/2012)

    Very cool, thank you for the pointers and the link to Jeff's article capn.hector!

    Will run some tests in the morning 🙂

    @Capn; Sorry I missed your question in the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 3, 2012 at 7:53 am

    #1521403

  • RE: Query Help- Cursor change into FOR WHILE LOOP, TEMP TABLE

    Sean Lange (8/2/2012)

    morepainot (8/2/2012)

    Sean Lange (8/2/2012)

    morepainot (8/2/2012)

    Sean Lange (8/2/2012)

    Well the code certainly looks a lot better. But it doesn't help me identify why you are getting an invalid object name....

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 2, 2012 at 3:42 pm

    #1521164

  • RE: rolling monthly analysis

    Lynn Pettis (8/2/2012)

    That's what I get for not checking first.

    LOL :w00t::w00t:

    i posted what i had figuring on working on it and actually expecting some one to beat me to...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 2, 2012 at 2:25 pm

    #1521135

  • RE: rolling monthly analysis

    Here using a full join where both sides are null we can get all our new or old clients and depending on where the nulls are can assign whether they...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 2, 2012 at 1:41 pm

    #1521120

  • RE: Intersecting Date Ranges

    i like the cross apply however you can turn it into an Inline Scalar Function (an iTVF that returns 1 value, Thanks Jeff http://www.sqlservercentral.com/articles/T-SQL/91724/) by using the following function.

    CREATE...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    August 2, 2012 at 12:42 pm

    #1521078

Viewing 15 posts - 211 through 225 (of 859 total)