Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Calculating working hours between 2 dates.

    not a fan of all those magic numbers.... 960? 465? 450? 585?

    Also, i'm thinking the nine times "DATEADD(DD, DATEDIFF(DD, 0, @EndDate), 0)" is called, and the nine times "DATEADD(DD, DATEDIFF(DD,...

  • RE: Database Standards Parsing

    you are indeed lucky. NONE of the providers i've had to deal with can figure out how to pass UNformatted phone numbers! not to mention they often can't be consistent...

  • RE: Database Standards Parsing

    "Functions that call functions are forbidden"... i'll bite. let's assume your data has telephone numbers stored in some format, and you want them to always be returned in a standardized...

  • RE: Encrypting Data With the Encrypt Function

    encrypt is not a recognized function name in sql 2005. pwdencrypt() is, however

Viewing 4 posts - 1 through 4 (of 4 total)