Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 10,144 total)

  • RE: How to shortening this sql code?

    HerryMarkowitz (7/10/2015)

    Hi kyagi.jo,

    Thanks for re-organized that code.

    But my main question is about how to shorten that code.

    I mean I dont want to enter every line from INVENNO 101 to INVENNO...

    July 10, 2015 at 4:05 am

    #1811537

  • RE: Are the posted questions getting worse?

    rodjkidd (7/10/2015)

    ChrisM@Work (7/10/2015)

    rodjkidd (7/10/2015)

    ChrisM@Work (7/10/2015)

    Alvin Ramard (7/6/2015)

    New question: Is the sanity of those trying to answer posted questions getting worse?

    Mine sure is! :hehe:

    Yeah! Stopped answering questions for a...

    July 10, 2015 at 2:31 am

    #1811511

  • RE: Are the posted questions getting worse?

    rodjkidd (7/10/2015)

    ChrisM@Work (7/10/2015)

    Alvin Ramard (7/6/2015)

    New question: Is the sanity of those trying to answer posted questions getting worse?

    Mine sure is! :hehe:

    Yeah! Stopped answering questions for a few days....

    July 10, 2015 at 2:19 am

    #1811508

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/6/2015)

    New question: Is the sanity of those trying to answer posted questions getting worse?

    Mine sure is! :hehe:

    Yeah! Stopped answering questions for a few days. No sign...

    July 10, 2015 at 1:59 am

    #1811502

  • RE: Convert Varchar to Int

    Minnu (7/8/2015)

    Numeric values in the first query should be converted to INTEGER.

    This isn't helpful and doesn't answer the questions which have been posted. Can you please post a table showing...

    July 8, 2015 at 9:24 am

    #1811008

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/8/2015)

    Okay, bite the tongue, keep the sarcasm off the thread Silver Spoon just posted. Nothing you can do there but get yourself in trouble.

    There, I feel a...

    July 8, 2015 at 9:09 am

    #1810999

  • RE: Convert Varchar to Int

    Minnu (7/8/2015)

    Hi,

    first query result :

    1

    2

    11

    20

    32

    68

    100

    124

    246

    256

    second query result

    A1

    A10

    A11

    AB1

    AB10

    B1

    B2

    B21

    B31

    want to generate the complete output in single select statement.

    select

    ColA = CASE WHEN CastableToInt = 1 THEN cast(Data as int) ELSE NULL END,

    ColB...

    July 8, 2015 at 9:08 am

    #1810997

  • RE: Convert Varchar to Int

    @sqletl (7/8/2015)

    When using CAST /CONVERT you cannot convert a field to a different data type if not all the values can actually be converted or are compatible. All the INT...

    July 8, 2015 at 7:15 am

    #1810937

  • RE: Convert Varchar to Int

    Minnu (7/8/2015)

    Hi Team,

    I have a table with column "Data" as VARCHAR, with entries like below.

    1

    11

    2

    A1

    A10

    A11

    246

    AB1

    AB10

    100

    256

    B1

    B2

    124

    20

    B21

    B31

    32

    68

    i want to select the data by converting varchar to int for numberic values and...

    July 8, 2015 at 7:09 am

    #1810934

  • RE: TVF is slower when running as paramerized

    phosplait (6/16/2015)

    So it seems this is definitely an issue of parameter sniffing.

    While option(recompile) did nothing, option(optimize for unknown) brought the dynamic query down to 3 seconds. Still slower, but I...

    July 8, 2015 at 4:33 am

    #1810886

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/7/2015)

    Ed Wagner (7/7/2015)

    andrew gothard (7/7/2015)

    Grant Fritchey (7/2/2015)

    Since I am usually the harbinger of ill tidings on the thread, you guys should know, Skynet seems to be going live.

    "the...

    July 7, 2015 at 8:49 am

    #1810724

  • RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

    robert.sterbal 56890 (7/7/2015)

    Is there a simple way to get a single row table with variable numbers of columns to output with 2 columns?

    i.e.

    colA colB colC

    1 5 23

    colA...

    July 7, 2015 at 8:01 am

    #1810707

  • RE: huge number of rows in table spool

    Grant Fritchey (7/7/2015)

    I'm just surprised you didn't get a table spool in 2008 with a recursive CTE. That's pretty common.

    A recursive CTE plan always features spools. It's not a recursive...

    July 7, 2015 at 5:40 am

    #1810673

  • RE: Turning datediff minutes into dd:hh:mm

    karen.blake (7/7/2015)

    Hi John,

    Thanks for your reply, you might have lost me on that one could you explain that further?

    Chris the datatype is datetime for that field if that helps.

    Thanks. Couple...

    July 7, 2015 at 5:32 am

    #1810672

  • RE: Turning datediff minutes into dd:hh:mm

    I'm with John on this one. What datatype is aetr.CREATE_DATE ?

    July 7, 2015 at 4:02 am

    #1810646

Viewing 15 posts - 2,341 through 2,355 (of 10,144 total)