Forum Replies Created

Viewing 15 posts - 3,841 through 3,855 (of 26,490 total)

  • RE: Simple SQL challenge - who can solve

    DuncEduardo (5/11/2016)

    Yes but you've explicitly stated numbers corresponding to calendar months from Jan - Nov. I try to avoid any form of "hard-coding".

    Nice solution though

    Luis's solution only has a table...

    May 11, 2016 at 9:38 am

    #1878291

  • RE: Duplicate entries

    DPD0011 (5/11/2016)

    I appreciate the help, new to SQL.

    select

    rn = row_number() over (partition by a.yyyymm, a.rcvdate, a.dispdate order by c.issuedate asc),

    a.yyyymm,

    ...

    May 11, 2016 at 9:16 am

    #1878281

  • RE: Are the posted questions getting worse?

    I always wonder when it appears that users have access to SSMS.

    May 11, 2016 at 9:11 am

    #1878276

  • RE: Duplicate entries

    DPD0011 (5/11/2016)

    SQL 2012

    Need to see the code you actually tried to run. The row_number() function has been a part of SQL Server since SQL Server 2005.

    May 11, 2016 at 9:08 am

    #1878273

  • RE: Duplicate entries

    DPD0011 (5/10/2016)

    Thank you for the tips, when I run the query I receive this error:

    Msg 195, Level 15, State 10, Line 2

    'row_number' is not a recognized function name.

    What version of...

    May 11, 2016 at 8:58 am

    #1878265

  • RE: Are the posted questions getting worse?

    Why are people still using SQL-89 style joins?

    May 10, 2016 at 4:46 pm

    #1878010

  • RE: different execution plan query cost

    You might want to try using OPENQUERY and running the query on the remote server and sending back only the data you need.

    Hopefully I made all the right changes:

    select *...

    May 10, 2016 at 4:37 pm

    #1878009

  • RE: passing a date value is not updating the table

    anjaliagarwal5 (5/10/2016)

    Hi All,

    have the follwoing stored prcoedure

    Create procedure Test

    (

    @TestDate1 smallDatetime = NULL,

    @TestDate2 smallDatetime = NULL,

    ...

    May 10, 2016 at 3:44 pm

    #1878003

  • RE: different execution plan query cost

    Steve T (5/10/2016)

    I'm running 2 exact queries. One in production and one in dev. They both connect to the same LINKED server for data and I'm getting vastly different...

    May 10, 2016 at 3:39 pm

    #1878001

  • RE: sp_helptext returns There is no text for object on a Stored Procedure

    Welsh Corgi (5/10/2016)

    I need to get the error message from the user.

    Mail Server is down.

    Thanks.

    You do realize the more information you provide up front, the less back and forth there...

    May 10, 2016 at 2:56 pm

    #1877996

  • RE: Update statement

    anjaliagarwal5 (5/10/2016)

    Hi All,

    I am passing three date variables in the stored procedure. Depending on whichever variable has value in it, it will be assigned to the Testdate column of...

    May 10, 2016 at 2:51 pm

    #1877993

  • RE: sp_helptext returns There is no text for object on a Stored Procedure

    Welsh Corgi (5/10/2016)

    Now I need to allow a group to be able to Script Table as ... on a Test Server.

    It worked on Production for a Developer on Production by...

    May 10, 2016 at 2:49 pm

    #1877991

  • RE: RANDom traps for the unwary

    Bill Talada (5/9/2016)

    I believe scientists rely on hardware solutions such as radioactive decay detection devices to get true randomness.

    I stay away from pseudo random data generation and try to approach...

    May 10, 2016 at 2:43 pm

    #1877990

  • RE: Passing different values

    Phil Parkin (5/10/2016)

    anjaliagarwal5 (5/10/2016)

    Hi All,

    I am passing a parameter as @col1. I need to set col3 to 100 if @col1 =1 else col3 will be any value that is...

    May 10, 2016 at 2:31 pm

    #1877985

  • RE: Passing different values

    anjaliagarwal5 (5/10/2016)

    Hi All,

    I am passing a parameter as @col1. I need to set col3 to 100 if @col1 =1 else col3 will be any value that is passed in....

    May 10, 2016 at 2:29 pm

    #1877983

Viewing 15 posts - 3,841 through 3,855 (of 26,490 total)