Forum Replies Created

Viewing 15 posts - 196 through 210 (of 859 total)

  • RE: Today's Random Word!

    L' Eomot Inversé (9/14/2012)

    jasona.work (9/14/2012)

    crookj (9/14/2012)

    SQLRNNR (9/14/2012)

    Cliff Jones (9/14/2012)

    capnhector (9/14/2012)

    Ray K (9/14/2012)

    Supertramp

    (what I'm listening to right now)

    super freak

    Super man

    super ex girlfriend

    Supercali...... Nevermind.

    Nirvana

    Moksha

    valhala

    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 14, 2012 at 6:15 pm

    #1538235

  • RE: Today's Random Word!

    crookj (9/14/2012)

    SQLRNNR (9/14/2012)

    Cliff Jones (9/14/2012)

    capnhector (9/14/2012)

    Ray K (9/14/2012)

    Supertramp

    (what I'm listening to right now)

    super freak

    Super man

    super ex girlfriend

    Supercali...... Nevermind.

    supercalifornication?

    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 14, 2012 at 6:13 pm

    #1538234

  • RE: Difference between a CROSS JOIN and a 'comma'

    SQL Kiwi (9/14/2012)

    capnhector (9/14/2012)

    was responding to the backwards compatibility comment.

    Ah, that was just a 'joke' comment about the reason behind the parsing behaviour.

    ahh. i need to get my...

    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 14, 2012 at 9:52 am

    #1537992

  • RE: Difference between a CROSS JOIN and a 'comma'

    SQL Kiwi (9/14/2012)

    capnhector (9/14/2012)

    i could see this going away in the next version of Sql Server (version after 2012). Reason being *= and =* no longer work as of...

    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 14, 2012 at 9:46 am

    #1537982

  • RE: Difference between a CROSS JOIN and a 'comma'

    SQL Kiwi (9/14/2012)

    GSquared (9/14/2012)

    Or "by design because they hoped it would never come up and couldn't figure out a good solution for it". I've seen that one before too....

    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 14, 2012 at 8:34 am

    #1537880

  • RE: Today's Random Word!

    Ray K (9/14/2012)

    Supertramp

    (what I'm listening to right now)

    super freak

    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 14, 2012 at 7:44 am

    #1537826

  • RE: Downloading files for Import?

    Another gnu program to look at is cURL. It is a little more complex than wget but can download every protocol under the sun

    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 14, 2012 at 6:17 am

    #1537766

  • RE: who gave 'sa' to the login

    Sqlism (9/13/2012)

    can we find out who gave 'sa' privilege to a login in sql server ?

    Note:

    -auditing is not enabled

    -dont know the approximate date, when the privilege was given

    nope. with...

    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 13, 2012 at 5:32 pm

    #1537582

  • RE: What is Proper Steps to Remove FileGroups

    SQLRNNR (9/13/2012)

    stanlyn (9/13/2012)

    Gail,

    From that article, did you read the very last part as show here:

    It is quite simple to fix this error, but you will need to delete all 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]

    September 13, 2012 at 5:00 pm

    #1537574

  • RE: Access Denied error when trying to attach AdventureWorks2012 .mdf file

    polkadot (9/13/2012)

    I've installed SQL Server 2012 (Enterprise trial) onto my laptop running Windows 7 Home Premium.

    I've downloaded the AdventureWork2012 database to my C:\Downloads folder.

    When I run this statement...

    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 13, 2012 at 4:06 pm

    #1537541

  • RE: Downloading files for Import?

    RBarryYoung (9/11/2012)

    GSquared (9/11/2012)

    SSIS has an FTP object that can be used to automatically download the files. Won't work if it's FTPS, but will for FTP. Will that work...

    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 11, 2012 at 6:38 pm

    #1536536

  • RE: Today's Random Word!

    crookj (9/10/2012)

    Cliff Jones (9/10/2012)

    Daniel Bowlin (9/10/2012)

    Techapalooza

    Reef-A-Palooza

    humdinger

    bell ringer

    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 6:34 pm

    #1535973

  • RE: T-SQL help

    could also use something like:

    insert into table1 (Values)

    SELECT values

    FROM table2

    LEFT JOIN table1

    ON table2.somecolumn = table1.somecolumn

    WHERE table1.somecolumn IS NULL

    at lease i think since...

    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 5:15 pm

    #1535959

  • RE: Concatenate Rows

    it works over your small data set. not sure if you can get rid of the distinct with so many columns you are grouping by.

    here is the solution:

    WITH RN...

    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 4:24 pm

    #1535948

  • RE: Are the posted questions getting worse?

    quick question to the threadzians, is any one else going to be at #sqlsat154 in St Louis? wondering if its going to be a lonely first professional event for...

    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:26 am

    #1535722

Viewing 15 posts - 196 through 210 (of 859 total)