Forum Replies Created

Viewing 15 posts - 196 through 210 (of 326 total)

  • RE: Partitioned index

    I got it right ... :w00t:

    friday rocks.... :hehe:

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

    November 1, 2012 at 10:24 pm

    #1555278

  • RE: Halloween Protection

    cool ; i didn't know ....

    nice question

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

    October 30, 2012 at 10:03 pm

    #1554472

  • RE: create table variable dynamically

    gsd1 (10/30/2012)

    Thanks for all the replies...

    As Sean Lange suggested, I tried with temp table (instead of temp variable).

    I faced these problems.

    1. I have to build the sql statement. So...

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

    October 30, 2012 at 8:38 am

    #1554187

  • RE: create table variable dynamically

    gsd1 (10/29/2012)

    Hello Friends.

    What is the best way of creating table variable dynamically?

    Thanks & Regards,

    that's a good one.. creating dynamic variable dynamically...:-P

    you might be able to create the table variable dynamically...

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

    October 30, 2012 at 3:17 am

    #1554047

  • RE: Use of IIF function in Crystal Reports

    anandhaksc (10/30/2012)

    Hi,

    so,its like a Ternary operator in Java?

    yes like ternary operator..

    .or conditional operator in C (if i remember correctly that's what it called)...

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

    October 30, 2012 at 2:55 am

    #1554040

  • RE: While Import data into Sql server 2008 from excel sheet

    sreenu_rvkl (10/30/2012)

    When change datatype max then also get same error

    I once face this issue while loading an image in binary format and saving it to the database ..

    If the length...

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

    October 30, 2012 at 2:44 am

    #1554036

  • RE: How would you convert this date in SSIS or after lodaed in database 2007-02-20 05:20:36.449923

    ya convert it to what ??

    it looks like datetime2 ...

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

    October 30, 2012 at 2:39 am

    #1554034

  • RE: LEAD - 1

    oh , I got it wrong , I thought instead of null, it will give default 0 as output..

    ..

    learned something though 😉

    thanks for the question...

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

    October 30, 2012 at 1:01 am

    #1554011

  • RE: SELECT (Transact-SQL)

    I found the glitch ..

    nice question...

    thanks

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

    October 25, 2012 at 11:15 pm

    #1553033

  • RE: PARSENAME

    Jamsheer (10/24/2012)

    Thanks for Good question..

    "Eid Mubarak" to all my SQL Friends.. 🙂

    Eid mubara Jamsheer..

    I knew of the PARSENAME ..there is a wonderful use of this for taking out the dot...

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

    October 24, 2012 at 11:52 pm

    #1552509

  • RE: STR

    A new one for me ...

    thanks

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

    October 17, 2012 at 10:17 pm

    #1550290

  • RE: COALESCE

    gosh.. I almost overlooked the quoted null ..:w00t:

    nice question....:Whistling:

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

    October 16, 2012 at 10:50 pm

    #1549861

  • RE: how to add data to two table

    Eugene Elutin (10/16/2012)

    santoshupadhayay87 (10/16/2012)

    i want to add three table to the datbase out of which two are from one table and one is of another table can anyone please...

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

    October 16, 2012 at 5:51 am

    #1549488

  • RE: how to add data to two table

    santoshupadhayay87 (10/16/2012)

    i want to add three table to the datbase out of which two are from one table and one is of another table can anyone please help me...

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

    October 16, 2012 at 5:20 am

    #1549469

  • RE: Load CSV file into temptable

    Let me know if this helps..

    CSV FILE : Test.csv

    a,b

    1,A

    2,B

    3,C

    Then in the SSMS :

    create table #test(a int,b varchar)

    BULK INSERT #test1

    FROM 'C:\Test.csv'

    WITH

    ...

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

    October 15, 2012 at 11:24 pm

    #1549372

Viewing 15 posts - 196 through 210 (of 326 total)