Forum Replies Created

Viewing 15 posts - 2,476 through 2,490 (of 15,381 total)

  • RE: Triggers Logging

    deebabat (8/12/2015)

    Am trying to keep track of some triggers in a new database I just inherited in order to troubleshoot some issues, I would like to know the start time,...

    August 12, 2015 at 7:22 am

    #1819308

  • RE: Real to Float

    wedneyyuri (8/12/2015)

    Good question.

    So, what's the correct way to do the conversion?

    DECLARE @REAL REAL= 43.39061;

    SELECT @REAL

    SELECT CONVERT(FLOAT, @REAL)

    SELECT CAST(@REAL AS FLOAT)

    If you...

    August 12, 2015 at 6:48 am

    #1819296

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/11/2015)

    Sean Lange (8/11/2015)

    Alvin Ramard (8/11/2015)

    SQLRNNR (8/11/2015)

    Eirikur Eiriksson (8/11/2015)

    Steve Jones - SSC Editor (8/11/2015)

    Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000...

    August 11, 2015 at 1:58 pm

    #1819126

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/11/2015)

    SQLRNNR (8/11/2015)

    Eirikur Eiriksson (8/11/2015)

    Steve Jones - SSC Editor (8/11/2015)

    Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.

    Would...

    August 11, 2015 at 1:30 pm

    #1819112

  • RE: Pull top 3 max values for each account

    maria.witkowski (8/11/2015)

    Not sure which is more efficient?? The table has about 40k rows in it. But I will try both! Thank you again!

    I don't think that Eirikur realized you...

    August 11, 2015 at 1:23 pm

    #1819107

  • RE: Pull top 3 max values for each account

    Luis Cazares (8/11/2015)

    You can use a code like this:

    WITH RowNums AS(

    SELECT *, ROW_NUMBER() OVER(PARTITION BY account ORDER BY date DESC) rn

    FROM SomeTable

    )

    SELECT...

    August 11, 2015 at 9:49 am

    #1819034

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/11/2015)

    Sean Lange (8/11/2015)

    OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:

    ATTRIBUTE1 nvarchar(1)

    ATTRIBUTE2...

    August 11, 2015 at 9:46 am

    #1819029

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/11/2015)

    SQLRNNR (8/11/2015)

    Sean Lange (8/11/2015)

    Jack Corbett (8/11/2015)

    Sean Lange (8/11/2015)

    OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns...

    August 11, 2015 at 9:34 am

    #1819022

  • RE: Are the posted questions getting worse?

    Jack Corbett (8/11/2015)

    Sean Lange (8/11/2015)

    OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50....

    August 11, 2015 at 9:14 am

    #1819011

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/11/2015)

    Sean Lange (8/11/2015)

    Alvin Ramard (8/11/2015)

    Sean Lange (8/11/2015)

    OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1...

    August 11, 2015 at 9:09 am

    #1819007

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/11/2015)

    Sean Lange (8/11/2015)

    OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:

    ATTRIBUTE1 nvarchar(1)

    ATTRIBUTE2...

    August 11, 2015 at 8:59 am

    #1818997

  • RE: Are the posted questions getting worse?

    OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:

    ATTRIBUTE1 nvarchar(1)

    ATTRIBUTE2 nvarchar(1)

    .

    .

    .

    ATTRIBUTE50 nvarchar(1)

    August 11, 2015 at 8:50 am

    #1818990

  • RE: Are the posted questions getting worse?

    Ed Wagner (8/11/2015)

    The silver spoons need to be ordered again. Better get at least a case.

    Here's a quote I don't think I've every seen before:

    Unfortunately I get your code...

    August 11, 2015 at 8:09 am

    #1818964

  • RE: Small Money, Money, Float - what's the best

    RonKyle (8/11/2015)

    When you have to perform division it will round

    Dividing isn't limited to interest though. Calculating averages will also do this. I think I'll stick with four...

    August 11, 2015 at 7:20 am

    #1818936

  • RE: Sproc inside a Try-Catch block?

    Quatrei.X (8/11/2015)

    Yeah, I already thought of dynamic sql, but didn't like the idea since my procedure is a long one and it'll make the script less readable and harder to...

    August 11, 2015 at 7:18 am

    #1818933

Viewing 15 posts - 2,476 through 2,490 (of 15,381 total)