Forum Replies Created

Viewing 15 posts - 4,681 through 4,695 (of 15,381 total)

  • RE: Applying Multipal filters for item selection.

    How about if you turn this into consumable ddl and data? Then show us what you have tried. It is not totally clear what you expect for output here either.

    Please...

    May 30, 2014 at 8:48 am

    #1717802

  • RE: uses of string splitters

    Luis has a photographic memory;-)

    Me too...but they stopped making film for this model a long time ago.

    Stuff like that, I put it in my briefcase or add the url to...

    May 30, 2014 at 8:05 am

    #1717784

  • RE: Joining two tables and dealing with null values

    SQLRNNR (5/30/2014)

    Well, at least it is working.

    I find it odd that nobody was interested in Sean's points on ebay. Seems very uneducated or crass of people - sheesh.

    I know!!!...

    May 30, 2014 at 7:36 am

    #1717769

  • RE: uses of string splitters

    Luis Cazares (5/29/2014)

    Sean Lange (5/29/2014)

    Here is an example of a real world case for using a splitter. This iTVF will return a string with the proper case. I did not...

    May 30, 2014 at 7:17 am

    #1717762

  • RE: Joining two tables and dealing with null values

    mattech06 (5/30/2014)

    Thanks Sean, that did the trick...give yourself a 1000 points!

    Glad that worked for you and thanks for letting us know.

    (the points don't really help, I tried to sell them...

    May 30, 2014 at 7:07 am

    #1717754

  • RE: Today's Random Word!

    crookj (5/30/2014)

    Ed Wagner (5/30/2014)

    Stuart Davies (5/30/2014)

    Sean Lange (5/29/2014)

    SQLRNNR (5/29/2014)

    Sean Lange (5/29/2014)

    Ed Wagner (5/29/2014)

    SQLRNNR (5/29/2014)

    Sean Lange (5/29/2014)

    SQLRNNR (5/29/2014)

    Sean Lange (5/29/2014)

    Ed Wagner (5/29/2014)

    Sean Lange (5/29/2014)

    Ed Wagner (5/29/2014)

    Sean Lange (5/29/2014)

    Stuart Davies (5/29/2014)

    Ed Wagner...

    May 30, 2014 at 7:06 am

    #1717751

  • RE: Just curious, what are your SQL pet peeves ?

    SQLRNNR (5/29/2014)

    Sean Lange (5/29/2014)

    SQLRNNR (5/29/2014)

    Sean Lange (5/29/2014)

    Luis Cazares (5/29/2014)

    JOIN keywords on the right of the tables.

    +1000 That one drives me nuts!!! (ok I know it is a short trip)

    NOT a...

    May 29, 2014 at 3:02 pm

    #1717606

  • RE: uses of string splitters

    Here is an example of a real world case for using a splitter. This iTVF will return a string with the proper case. I did not write this and sadly...

    May 29, 2014 at 2:58 pm

    #1717603

  • RE: uses of string splitters

    KoldCoffee (5/29/2014)

    in the book SQL Server Common Table Expressions Joes 2 Pros by Steve Stedman et al., I read about the use of splitters to count the number of times...

    May 29, 2014 at 2:51 pm

    #1717600

  • RE: Just curious, what are your SQL pet peeves ?

    SQLRNNR (5/29/2014)

    Sean Lange (5/29/2014)

    Luis Cazares (5/29/2014)

    JOIN keywords on the right of the tables.

    +1000 That one drives me nuts!!! (ok I know it is a short trip)

    NOT a fan of that...

    May 29, 2014 at 2:42 pm

    #1717596

  • RE: Just curious, what are your SQL pet peeves ?

    SQLRNNR (5/29/2014)

    Sean Lange (5/29/2014)

    Luis Cazares (5/29/2014)

    JOIN keywords on the right of the tables.

    +1000 That one drives me nuts!!! (ok I know it is a short trip)

    NOT a fan of that...

    May 29, 2014 at 2:42 pm

    #1717593

  • RE: uses of string splitters

    KoldCoffee (5/29/2014)

    interesting. Still looks like a main use for splitters is to literally split it up into columns when built in functionality of ssis or import/export wizard isn't enough.

    Or when...

    May 29, 2014 at 2:39 pm

    #1717591

  • RE: Decimal(65,2) in MySQl to Sql server Data Type

    Jeff Moden (5/29/2014)

    Mr. Kapsicum (5/29/2014)

    Hi,

    This Data Type is of the Source Table. We Insert Data from Mysql DB to SQL Server.

    The Data Type for few columns in Source Table is...

    May 29, 2014 at 2:36 pm

    #1717587

  • RE: uses of string splitters

    KoldCoffee (5/29/2014)

    in the book SQL Server Common Table Expressions Joes 2 Pros by Steve Stedman et al., I read about the use of splitters to count the number of times...

    May 29, 2014 at 2:26 pm

    #1717583

  • RE: Decimal(65,2) in MySQl to Sql server Data Type

    Matt Crowley (5/29/2014)

    I am compelled to post this link here:

    XKCD: What if[/url]

    That is awesome. Hadn't seen that one before.

    May 29, 2014 at 2:24 pm

    #1717581

Viewing 15 posts - 4,681 through 4,695 (of 15,381 total)