Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 8,416 total)

  • RE: Datetime data type

    ISDATE certainly isn't perfect:

    SELECT

    ISDATE('200801'),

    CAST('200801' AS datetime) /* 2020-08-01 */

    Among the improvements in SQL Server 2012 is the new TRY_PARSE function:

    SELECT

    ...

    January 13, 2012 at 11:09 pm

    #1433650

  • RE: Creating million row test tables?

    Regarding:

    GSquared (1/12/2012)

    Another way is to get something like RedGate's data generator.

    For any serious usage, this is a much better approach than hacking something together based on NEWID. There are...

    January 13, 2012 at 10:51 pm

    #1433648

  • RE: Returning a column per date in a range

    Jeff Moden (1/13/2012)

    On one hand, you seem to support avoiding counting rCTEs and then you seem to justify their use on the other.

    Yikes. No, what I objected to (reasonably...

    January 13, 2012 at 10:44 pm

    #1433645

  • RE: Returning a column per date in a range

    Jeff Moden (1/13/2012)

    SQL Kiwi (1/13/2012)

    LutzM (1/13/2012)

    The main reason some of us go beyond a "it works in the context" solution is because there are people out there who -unlike your...

    January 13, 2012 at 10:03 pm

    #1433634

  • RE: How to insert multiple rows into a table with identity column

    CELKO (1/5/2012)

    This is only one reason why good SQL programmers never use this proprietary non-relational "feature" in their code.

    Back to foundation. SQL is a set-oriented language. When you do...

    January 13, 2012 at 9:31 pm

    #1433631

  • RE: How to insert multiple rows into a table with identity column

    nigel. (1/13/2012)

    And it looks he's succeeded! No sign of the OP :crying:

    The simple question was answered long before Joe posted. It seems the questioner has his or her answer,...

    January 13, 2012 at 9:17 pm

    #1433628

  • RE: How can you write a view with Variables in a subquery?

    This is the outline of a solution:

    CREATE FUNCTION dbo.NameOfFunction

    (

    @Buyers varchar(100),

    @ReceivedDate date,

    ...

    January 13, 2012 at 9:14 pm

    #1433627

  • RE: Returning a column per date in a range

    LutzM (1/13/2012)

    The main reason some of us go beyond a "it works in the context" solution is because there are people out there who -unlike your great attitude- copy a...

    January 13, 2012 at 8:29 pm

    #1433625

  • RE: Understanding and Using APPLY (Part 2)

    LadyRuna (1/13/2012)

    The only thing not mentioned, or emphasized in this is the performance of using APPLY.

    For tiny databases / small result sets, this is awesome. For large result sets, it's...

    January 13, 2012 at 8:05 pm

    #1433624

  • RE: Query Plan Execution Order

    Sergiy (1/13/2012)

    How stupid does it sound?

    I don't find the analogy useful at all, to be honest. Instead, imagine four people. One reads rows from table A, one reads...

    January 13, 2012 at 7:55 pm

    #1433623

  • RE: SQL Server equivalent to DB2 HEX

    Peter Brinkhaus (1/13/2012)

    What's the data type of Column1 one in DB2? It looks like a structure containing 6 columns...

    I have to say Peter, this is one of the best posts...

    January 13, 2012 at 7:46 pm

    #1433622

  • RE: MERGE INTO

    GSquared (1/13/2012)

    jez.lisle (1/13/2012)

    I need to be able to Insert or Update the fields depending on what the source table has done.

    Yes, but if there are two (or more) rows in...

    January 13, 2012 at 7:29 pm

    #1433621

  • RE: Are the posted questions getting worse?

    sjimmo (1/13/2012)

    If one has a vote, and all votes are equal, I would say no.

    I think a lot of issues were brought to the surface with a lot of comments...

    January 13, 2012 at 7:53 am

    #1433261

  • RE: MERGE INTO

    jez.lisle (1/13/2012)

    I get this error below

    Msg 8672, Level 16, State 1, Line 2

    The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a...

    January 13, 2012 at 7:39 am

    #1433253

  • RE: Are the posted questions getting worse?

    What's the general feeling about asking Steve to remove that "Question for the Experts" thread? +1 vote here.

    January 13, 2012 at 7:05 am

    #1433222

Viewing 15 posts - 1,156 through 1,170 (of 8,416 total)