Forum Replies Created

Viewing 15 posts - 166 through 180 (of 326 total)

  • RE: New Year's Math

    Yes, Patience is the key..

    nice question.. too much to read though. 🙂

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    January 2, 2013 at 11:05 pm

    #1573173

  • RE: Santa's List

    Yes, Filtered Santa Gifts..

    Thanks For the question.

    Happy holidays to all !!!

    Merry Christmas and Happy New Year !!!!!!!!!!!!

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 25, 2012 at 6:34 am

    #1571411

  • RE: Column to Generate a Confirmation Number

    ncurran217 (12/21/2012)

    I need to add a column to my existing table that counts up with every record added. But I want it to be something along these lines =...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 21, 2012 at 10:14 am

    #1571003

  • RE: Aggregates in T-SQL

    Lokesh Vij (12/21/2012)

    Yggaz (12/21/2012)

    Lokesh Vij (12/21/2012)

    I do not agree with this. COUNT(*) only considers counting the number of rows. It does not even bother to take a look at the...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 21, 2012 at 9:29 am

    #1570983

  • RE: Aggregates in T-SQL

    Koen Verbeeck (12/20/2012)

    Easy question. I didn't even had to check to 3rd query, because the second one gave (NULL,0) and there was only one answer in the list with that...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 21, 2012 at 4:24 am

    #1570836

  • RE: What will the max id be?

    easy ...truncate resets the identity;

    It's a coincidence , I was just discussing it with my colleague about inserting a row in between identity inserted column. And yes, Truncate popped up...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 18, 2012 at 11:20 pm

    #1569898

  • RE: index legth

    bruce-347665 (12/13/2012)

    let say that we have a varchar(100) column and a index on that column

    in mysql I can set the index length to any number smaller than 100.. if I...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 13, 2012 at 6:31 am

    #1568282

  • RE: Transaction is SSIS

    MuraliKrishnan1980 (12/13/2012)

    Hi Friends,

    I am trying to implement transaction in SSIS for the first time. We are going to migrate few records from source to destination tables using DFT. We are...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 13, 2012 at 6:22 am

    #1568278

  • RE: Need Help in SSIS

    sagar0838 (12/13/2012)

    while loading 10000 records if the SSIS package got failed at 9000th record,how do we reload from 9001 record ,can anyone please help me out on this

    there is as...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 13, 2012 at 6:11 am

    #1568275

  • RE: IDENTITY INSERT

    bitbucket-25253 (12/12/2012)

    Thanks for reminding me of the basics ....

    +1

    when I saw identity question , I was sure it's cam out of Lokesh mind's bucket ...

    Thanks for the basic reminder..

    I...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 12, 2012 at 9:47 pm

    #1568139

  • RE: Renaming a procedure

    Toreador (12/12/2012)

    Hugo Kornelis (12/12/2012)

    Using sp_rename to rename a programmability item does not change its definition in sys.sql_modules. That's why Books Online recommends to use DROP / CREATE instead.

    I've never...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 12, 2012 at 4:13 am

    #1567809

  • RE: Renaming a procedure

    dineshbabus (12/11/2012)

    Instead of saying modify using alter script, Author could have said drop and recreate with new name. Luckily igot it correct.

    +1

    I thought the same thing ,and was looking...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 11, 2012 at 11:27 pm

    #1567706

  • RE: Which Statement will execute sucessfully

    easy one for friday ...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 6, 2012 at 9:58 pm

    #1566437

  • RE: Aggregates

    bitbucket-25253 (12/5/2012)

    Nice back to basics question - thanks

    +1

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 5, 2012 at 9:19 pm

    #1565998

  • RE: LIKE a vowel

    Bex (12/3/2012)

    I'll hold my hand up and say I got this right by means of a lucky guess.

    Very interesting question and excellent, full answer.

    Thanks, Tom!

    Bex

    I got it correct by...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

    December 3, 2012 at 2:17 am

    #1564765

Viewing 15 posts - 166 through 180 (of 326 total)