Forum Replies Created

Viewing 15 posts - 271 through 285 (of 458 total)

  • RE: Niagara Falls

    SQLkiwi (8/2/2011)

    I'm not sure we should be singling out Canadians here. If anything, the US situation is the exception, since SQL Server uses a SQL collation by default for...

    August 2, 2011 at 8:03 am

    #1362175

  • RE: Display records only if they have multiple child records

    fsnell (7/22/2011)

    Thank you. I will have to test it Monday.

    Not familiar with the "with" statement...will have to research that one.

    again, thanks, and will let you know.

    Google "Common...

    July 25, 2011 at 7:53 am

    #1357782

  • RE: Display records only if they have multiple child records

    fsnell (7/24/2011)

    I am still confused about how Group By de-duplicates, as I have never seen it refered to that way, or used for that purpose, but will take your word...

    July 25, 2011 at 7:35 am

    #1357759

  • RE: "Normal" tables vs local temporary (i.e. #) tables

    I'll run this up the flag pole - might not be relevant.

    You said you're doing "complicated and convoluted calculations". Might you be using UDFs for that? If so, you...

    July 22, 2011 at 6:38 am

    #1357008

  • RE: OPENROWSET() Intermittently Fails to Read Excel File

    SwePeso (7/22/2011)

    Use IMEX=1 in your extended properties for the driver.

    Thanks, but that's not the issue here.

    The same query on the same Excel file works fine immediately after (and...

    July 22, 2011 at 6:19 am

    #1356994

  • RE: standard deviation Q

    If you are computing the standard deviation for the entire population of data -- and not a sample of the population -- then the formula is different. The function...

    July 18, 2011 at 8:15 pm

    #1354588

  • RE: How can I do a COUNT with different parameters??

    Something like this? You want all quotes after the specified date, per ticker?

    SELECT c.Symbol, c.CountFrom, Count(*) As QuoteCount

    FROM #CountInfo c INNER JOIN

    #priceData p ON (c.CountFrom < p.quote_date AND c.symbol...

    July 18, 2011 at 8:08 pm

    #1354587

  • RE: What works better? Running a stored procedure or a query for the data sets in a report for SSRS?

    Ninja's_RGR'us (7/16/2011)

    Actually SSRS use sp_executesql in the background so you get the same benefits as the sp on that level.

    Ah, thanks for that point. Makes sense that would be...

    July 16, 2011 at 8:12 pm

    #1353909

  • RE: DateTime or nvarchar

    ashkan siroos (7/5/2011)

    My manager wants to change all datetime fields to nvarchar because it is easier to code string against datetime...

    Why is it "easier" to code that way? ...

    July 16, 2011 at 11:27 am

    #1353867

  • RE: What works better? Running a stored procedure or a query for the data sets in a report for SSRS?

    My (admittedly untested) guess is that executing an ad hoc query in RS for a dataset is no different from running one in SSMS or any other application: you lose...

    July 16, 2011 at 11:00 am

    #1353863

  • RE: loops

    The Dixie Flatline (7/11/2011)

    Jason,

    Although we often use hate language when we joke about cursors, blind hatred is not our motivation. The simple fact is they are far...

    July 16, 2011 at 10:41 am

    #1353862

  • RE: XP_cmdshell DIR

    Are you allowed to use CLR?

    I got fed up with a number of work-arounds I had to get file information, so I created a CLR-based TVF to return several attributes...

    July 13, 2011 at 7:42 am

    #1352159

  • RE: In-CASE you need to SUM...

    brazumich (7/11/2011)

    rmechaber (7/11/2011)

    Can someone explain to me why you might expect the SUM(CASE) construct wouldn't work? I use this all the time and thought it was pretty straightforward T-SQL.

    Honest...

    July 11, 2011 at 8:04 am

    #1351088

  • RE: In-CASE you need to SUM...

    Can someone explain to me why you might expect the SUM(CASE) construct wouldn't work? I use this all the time and thought it was pretty straightforward T-SQL.

    Nice try at...

    July 11, 2011 at 7:38 am

    #1351069

  • RE: July 4

    Michael Poppers (7/5/2011)

    Koen Verbeeck (7/3/2011)

    Thank god for Will Smith and aliens 😉 😀 :hehe:

    And Will's GF...and Judd Hirsch (still see him weekly in "Numb3rs" reruns)...and.... Now if someone can...

    July 5, 2011 at 11:18 am

    #1348480

Viewing 15 posts - 271 through 285 (of 458 total)