Forum Replies Created

Viewing 15 posts - 46 through 60 (of 104 total)

  • RE: ADD Constraint - set default 0

    Paul White (9/9/2009)

    KB (9/9/2009)

    It has around 17 lacs of records.

    So i think it can be done through a simple update statement

    Cool. What are 'lacs' though? :unsure:

    Its 1,700,000 rows.

    Hmmm...Will...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    September 9, 2009 at 7:26 am

    #1051082

  • RE: ADD Constraint - set default 0

    Paul White (9/9/2009)

    KB (9/9/2009)

    Is manual update(from NULL to 0), the only solution ?

    There is rarely only one solution to any problem in SQL Server!

    It might be easiest and as good...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    September 9, 2009 at 7:10 am

    #1051054

  • RE: ADD Constraint - set default 0

    Is manual update(from NULL to 0), the only solution ?

    -

    KB

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    September 9, 2009 at 6:59 am

    #1051038

  • RE: Recursive Queries in SQL Server 2005

    Dave Ballantyne (9/3/2009)

    KB (9/3/2009)

    Hi,

    In this article, I need to know what is the purpose of SortKey in CTE.

    In the hierarchy, will the Top level row is returned first??

    (In our project...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    September 3, 2009 at 8:38 am

    #1048788

  • RE: Recursive Queries in SQL Server 2005

    Hi,

    In this article, I need to know what is the purpose of SortKey in CTE.

    In the hierarchy, will the Top level row is returned first??

    (In our project we need only...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    September 3, 2009 at 8:16 am

    #1048769

  • RE: Precedence inside a Data Flow task

    Erik Kutzler (8/20/2009)

    You can add multiple Data Flows to the Control Flow and set precedence constraints between each Data Flow.

    Instead of adding that many data flow tasks,

    is there any...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    August 20, 2009 at 7:43 am

    #1042103

  • RE: Which one runs faster?

    Hi All,

    One more on performance.

    TableA has 140columns.

    TableB has 40columns.

    In one application, it has been used the 1st query below.

    (but for processing only 15 columns are needed)

    If I change the query...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    July 29, 2009 at 11:08 pm

    #1032165

  • RE: Which one runs faster?

    Michael Valentine Jones (7/29/2009)

    KB (7/29/2009)

    Hi,

    Which query executes faster in sql server 2005, if table has some 50k rows.

    select count(id) from table --id being primary key

    OR

    select count(*) from table

    how to...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    July 29, 2009 at 10:56 pm

    #1032157

  • RE: Query results to a text file in a specified path

    Ramesh Babu (6/24/2009)

    declare @CodeLen int,

    @strSQL varchar(4000)

    SELECT @CodeLen = MAX(DATALENGTH(Code)) from History_temp

    --print @CodeLen

    set @strSQL='SELECT POL_NO [Policy]

    ,Name

    ,AGY_NO [Agency]

    ,Initials

    ,cast(Code as varchar( ' +@CodeLen + ')) [Code]

    ,Method

    ,createdOn AS [Received...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    June 24, 2009 at 6:20 am

    #1014580

  • RE: Query results to a text file in a specified path

    Hi,

    I am using the below cmd to generate Report.

    but the problem is I'm not able to trim the column "Code" which is of varchar(max)....

    in the report generated i can see...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    June 24, 2009 at 3:35 am

    #1014496

  • RE: Query results to a text file in a specified path

    Thanks all for the help,

    -

    KB

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    June 23, 2009 at 7:53 am

    #1013941

  • RE: Query results to a text file in a specified path

    ps (6/23/2009)

    if you're running this query from query window, you've option to save the results in 1)grid, 2)text and 3) file. There are three buttons on the top right side...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    June 23, 2009 at 7:20 am

    #1013897

  • RE: SQL Server 2000 vs SQL Server 2005

    Lynn Pettis (6/9/2009)

    Favor please.

    Post the table DDL and some sample data for the tables along with the expected results. I was looking at your query and I think it...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    June 11, 2009 at 2:38 pm

    #1008260

  • RE: SQL Server 2000 vs SQL Server 2005

    Lynn Pettis (6/9/2009)

    Favor please.

    Post the table DDL and some sample data for the tables along with the expected results. I was looking at your query and I think it...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    June 9, 2009 at 3:13 pm

    #1007084

  • RE: SQL Server 2000 vs SQL Server 2005

    GSquared (6/9/2009)

    Can you post both execution plans? Can't really figure out the difference without looking at those.

    I am sorry, right now I do not have permissions to see execution...

    Thanks,
    Santhosh

    Human Knowledge Belongs To The World !!

    June 9, 2009 at 2:56 pm

    #1007072

Viewing 15 posts - 46 through 60 (of 104 total)