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. 🙂

    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 !!!!!!!!!!!!

    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 =...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    December 11, 2012 at 11:27 pm

    #1567706

  • RE: Which Statement will execute sucessfully

    easy one for friday ...

    December 6, 2012 at 9:58 pm

    #1566437

  • RE: Aggregates

    bitbucket-25253 (12/5/2012)

    Nice back to basics question - thanks

    +1

    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...

    December 3, 2012 at 2:17 am

    #1564765

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