Forum Replies Created

Viewing 15 posts - 4,081 through 4,095 (of 14,953 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/7/2011)


    GSquared (6/7/2011)


    GilaMonster (6/7/2011)


    The client-from-hell is no more.

    Woohooooooooooo!!! Time for you to celebrate!

    I think that means either all of us have to buy you a drink, you have to...

  • RE: Are the posted questions getting worse?

    GilaMonster (6/7/2011)


    The client-from-hell is no more.

    Woohooooooooooo!!! Time for you to celebrate!

    I think that means either all of us have to buy you a drink, you have to buy all...

  • RE: Are the posted questions getting worse?

    ALZDBA (6/7/2011)


    What's with the watermark on our SSC ??

    Is it webmaster fun, or is SSC changing logo ?

    What watermark?

  • RE: Duplicate

    The only difference I see between the rows is column Acct_Row, but your post says, "BUT I DON;T WANT OUTPUT BASE ON ACCT_ROW".

    So, what do you want the output based...

  • RE: TSQL

    CREATE TABLE #TempPermissions

    (uid SMALLINT,

    UserName VARCHAR(100),

    Group_Name VARCHAR(100),

    NT_Group VARCHAR(3),

    ...

  • RE: Duplicate

    The Acct_ID column is identical within the Acct_No value, but you say don't use the only value that actually does differentiate the rows. Your requirements, as stated, are different...

  • RE: TSQL

    Create the temp table, use sp_MSForEachDB to insert into it from each database, then select from it after that.

  • RE: Mathematical Theory (controversy!)

    mister.magoo (6/7/2011)


    Steve Jones - SSC Editor (6/7/2011)


    Craig Farrell (6/6/2011)


    calvo (6/6/2011)


    GSquared (6/6/2011)..."Billion" means two different things on different sides of The Pond.

    wow. I was about to question this when I looked...

  • RE: merging result sets when using a loop

    Definitely sounds like more fun than I usually allow myself to experience. 😛

    If you aren't familiar with Between, are you familiar with using "In" in Where clauses, to filter a...

  • RE: Mathematical Theory (controversy!)

    Steve, when you originally envisioned SSC, did you imagine it would end up having debates on the meaning of "philosophy" and the definitions of "1" as part of the content?

  • RE: merging result sets when using a loop

    It really depends on what you're trying to do.

    If you absolutely have to loop through results and get them into a single resultset, the best way is usually to insert...

  • RE: Datatype question

    You're running into issues with padding and implicit conversion.

  • RE: System Database - MODEL corrupted

    Were files changed after the shutdown? Or have you confirmed corruption is the issue already?

    You should be able to restore the model database from a backup. Do you...

  • RE: What is the replacement of AWE?

    Lowell (6/7/2011)


    AWE was the work around for 32 bit systems, because hard drives got larger than the upper limit of the # of address the system can keep track of...

  • RE: What is a good SQL Server strategy for copy/move database tables between two location in different networks?

    odanwada (6/7/2011)


    My problem here is both the systems are not on same network... How to configure Replication if Both the servers are on different network...

    Use SQL Server authentication, instead of...

Viewing 15 posts - 4,081 through 4,095 (of 14,953 total)