Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 1,957 total)

  • RE: Try..Catch.. and @@Trancount>0 location

    Barkingdog (4/18/2010)

    The following extract is from http://msdn.microsoft.com/en-us/library/ms175976.aspx

    ...

    Shouldn't the

    IF @@TRANCOUNT > 0

    COMMIT TRANSACTION;

    GO

    test occur after BEGIN TRANSACTION but just before the "BEGIN CATCH?

    No, the...

    April 18, 2010 at 4:40 pm

    #1153521

  • RE: Convert Function

    vaibhav.tiwari (4/17/2010)

    Except if sdate includes a time, in which case dates such as '16/04/2010 12:23:21' will not be returned

    I am not getting please explain...

    What Jeff said....

    (I was just about to...

    April 17, 2010 at 10:28 am

    #1153356

  • RE: Convert Function

    vaibhav.tiwari (4/17/2010)

    mister.magoo (4/16/2010)

    yes, you are converting the date to a varchar and then comparing that - which will just be an alphanumeric comparison.

    You need to convert your reference date, which...

    April 17, 2010 at 7:06 am

    #1153320

  • RE: Company Rewards

    In one of my previous jobs, we used to have extra holidays if you charged 18+ days in a month as well as cash bonuses and believe me those holidays...

    April 16, 2010 at 2:33 am

    #1152632

  • RE: Convert Function

    yes, you are converting the date to a varchar and then comparing that - which will just be an alphanumeric comparison.

    You need to convert your reference date, which are currently...

    April 16, 2010 at 2:03 am

    #1152623

  • RE: How to find unused Stored Procedures in SQL Server 2005/2008

    Thanks for the interesting Article!

    I wonder did you ever take a look at this blog post about using DMVs to analyse store proc usage ?

    Five DMV Queries That Will Make...

    April 15, 2010 at 9:10 am

    #1152196

  • RE: RDLC Local Print packaged control install?

    Good, thanks for letting us know it helped

    March 29, 2010 at 11:53 am

    #1141619

  • RE: RDLC Local Print packaged control install?

    "Your web app" - that means you need to read Gift Peddie's previous post ...

    March 29, 2010 at 10:44 am

    #1141561

  • RE: CASE WHEN Multiple Choices

    You're welcome - thanks for the feedback.

    March 29, 2010 at 8:22 am

    #1141459

  • RE: CASE WHEN Multiple Choices

    Matt Miller (#4) (3/26/2010)

    You can also do it this way:

    AND (P.PAprojmngrid =

    CASE

    WHEN @Discipline = 'Surveying' THEN '07'

    WHEN @Discipline = 'Civil Engineering' THEN '04'

    WHEN @Discipline = 'Geotechnical' THEN '03'

    WHEN...

    March 26, 2010 at 6:06 pm

    #1140842

  • RE: RDLC Local Print packaged control install?

    Hi, it is not clear if you mean you need the Report Viewer (as in the previous reply) or the Reporting Services Client Printing control....

    so in case you wanted to...

    March 26, 2010 at 5:23 pm

    #1140829

  • RE: Cross apply Ambiguity

    Matt Miller (#4) (3/26/2010)

    While I do see the problem - isn't this a problem with any subquery (i.e. not specific to CROSS APPLY) ? Without fully qualifying every instance...

    March 26, 2010 at 5:15 pm

    #1140828

  • RE: CASE WHEN Multiple Choices

    LHendren (3/26/2010)

    I have a GridView that I am trying to display projects by Project Manager ID's via a DropDown pick. Only some of the projects have been assigned Project...

    March 26, 2010 at 5:10 pm

    #1140826

  • RE: how best should I handle this

    Paul Morris-1011726 (3/26/2010)

    Looks good... let me play with it to see for sure.

    I do have a question, so as to understand this better... What is happening in this piece of...

    March 26, 2010 at 10:48 am

    #1140551

  • RE: Getdate with previous date

    WHERE shipdate >= DATEADD(d,DATEDIFF(d,'19000101',GETDATE())-1,'19000101')

    AND shipdate < DATEADD(d,DATEDIFF(d,'19000101',GETDATE()),'19000101')

    March 26, 2010 at 9:59 am

    #1140479

Viewing 15 posts - 1,846 through 1,860 (of 1,957 total)