Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (5/2/2011)

    Brandie(5/2/2011)

    Ninja, I can hardly throw stones on that particular point. Being a speed reader tends to work against me on the online forums.

    Same here... hence #1 for amount of...

    May 2, 2011 at 8:16 am

    #1318409

  • RE: Are the posted questions getting worse?

    Fal (5/1/2011)

    After a horror week in which half my mirrors crashed, a royal wedding saturated the TV, radio, newspapers (as well as my dreams after a derriere walked up the...

    May 2, 2011 at 6:37 am

    #1318358

  • RE: Eliminating Duplicate Rows in SQL server

    sqlsree (4/29/2011)

    So which one works better when i have huge data? CTE or Subquery??

    According to ColdCoffee, it shouldn't make a difference which you use. Use whichever feels more usable/understandable to...

    April 29, 2011 at 2:12 pm

    #1317957

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (4/28/2011)

    SQLRNNR (4/28/2011)

    Ah suds, I better timewarp to get that new update so I can come back to the present, upgrade my timewarp and then run the new...

    April 28, 2011 at 3:18 pm

    #1317601

  • RE: Data format -cross tab

    sql_2005_fan (4/28/2011)

    Thanks for your help.It works fine. But I need to by pass the null values.

    Say like if addr2 has a null values it should not be added in the...

    April 28, 2011 at 2:04 pm

    #1317542

  • RE: Eliminating Duplicate Rows in SQL server

    ColdCoffee (4/28/2011)

    Stefan Krzywicki (4/28/2011)

    ColdCoffee (4/28/2011)

    Stefan Krzywicki (4/28/2011)

    Also, you don't have to use a CTE for this, you can just use a subquery

    Aren't CTE and SubQuery synonymous except for the fact...

    April 28, 2011 at 1:43 pm

    #1317515

  • RE: Persisted computed columns VS index over computed column

    hillock666 (4/28/2011)

    Hi.

    I'm wondering about marking a computed column as persisted is useful when I'm using a query fully covered with an index.

    I think that this haven't sense, because...

    April 28, 2011 at 1:42 pm

    #1317514

  • RE: uniqueidentifier as input

    sql_2005_fan (4/28/2011)

    @input1 uniqueidentifier

    when the input paramter is not set to null, we should definitley send the value for it,right?

    @input1 uniqueidentifier=null

    then we dont need to send the value to this parameter,right?

    Thanks.

    Right,...

    April 28, 2011 at 1:08 pm

    #1317493

  • RE: uniqueidentifier as input

    MysteryJimbo (4/28/2011)

    Stefan Krzywicki (4/28/2011)

    MysteryJimbo (4/28/2011)

    Alternatively, to reduce index fragmentation you could use NEWSEQUENTIALID()

    If and only if they are generating new uniqueidentifier values for these inserts. If there are existing ids,...

    April 28, 2011 at 1:05 pm

    #1317490

  • RE: Eliminating Duplicate Rows in SQL server

    ColdCoffee (4/28/2011)

    Stefan Krzywicki (4/28/2011)

    Also, you don't have to use a CTE for this, you can just use a subquery

    Aren't CTE and SubQuery synonymous except for the fact that CTE has...

    April 28, 2011 at 1:04 pm

    #1317488

  • RE: Eliminating Duplicate Rows in SQL server

    ColdCoffee (4/28/2011)

    Stefan Krzywicki (4/28/2011)

    ColdCoffee (4/27/2011)

    Try this:

    declare @table table

    ( catid int, catname varchar(25) , refid int )

    insert into @table values

    (1 ,'Lenovo', 21),

    (2 ,'Sony', 22),

    (2 ,'Sony', 22),

    (3 ,'Dell', 23),

    (4 ,'Toshiba', 24),

    (4 ,'Toshiba',...

    April 28, 2011 at 12:15 pm

    #1317442

  • RE: uniqueidentifier as input

    MysteryJimbo (4/28/2011)

    Alternatively, to reduce index fragmentation you could use NEWSEQUENTIALID()

    If and only if they are generating new uniqueidentifier values for these inserts. If there are existing ids, those should be...

    April 28, 2011 at 12:05 pm

    #1317433

  • RE: uniqueidentifier as input

    sql_2005_fan (4/28/2011)

    I have procedure which has uniqueidentifier as one of the input parameters.

    CRETAE PROCEDURE testsp

    @input1 uniqueidentifier

    AS

    SET NOCOUNT ON

    INSERT INTO testtbl(uniid)

    VALUES(@input1)

    GO

    I should send the uniqueidentifier value for this procedure as input,right?

    or...

    April 28, 2011 at 11:55 am

    #1317427

  • RE: Eliminating Duplicate Rows in SQL server

    ColdCoffee (4/27/2011)

    Try this:

    declare @table table

    ( catid int, catname varchar(25) , refid int )

    insert into @table values

    (1 ,'Lenovo', 21),

    (2 ,'Sony', 22),

    (2 ,'Sony', 22),

    (3 ,'Dell', 23),

    (4 ,'Toshiba', 24),

    (4 ,'Toshiba', 24)

    ; with cte...

    April 28, 2011 at 11:04 am

    #1317411

  • RE: Studio Manager Editing

    You can change that value under Tools --> Options --> SQL Server Object Explorer

    Then change the value of Value for Edit Top <n> Rows Command to whatever value you'd like.

    However,...

    April 28, 2011 at 11:00 am

    #1317408

Viewing 15 posts - 1,801 through 1,815 (of 2,838 total)