Forum Replies Created

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

  • Reply To: SQL MI Stop/Start Billing

    The way this question is asked it would be 11 hours, but I do get the confusion: that's what happens when British people try to Americanize the question, LOL. 17:05pm...

  • Reply To: Concatenating Dynamic SQL

    Email had "Select @SQL" on the site it said "EXEC (@SQL). In first case you get 2 statements concatenated into one, in second case you get 2 separate recordsets. None...

  • Reply To: The Counter Offer - Part 1

    How about this: You like the job you currently have but even though you liked your original salary after 3 years of 2.5 - 3% raises you now feel that...

  • RE: Logical Query Processing Filters

    WOW! 10% got it right. Congrats! LOL

  • RE: Presentations that are Easy on the Eyes

    GeorgeCopeland - Friday, June 2, 2017 7:27 AM

    Light backgrounds. Microsoft spends millions of dollars every year user testing the Office suite. For...

  • RE: Email Formatted HTML Table with T-SQL

    I usually first create an HTML document using some WYSIWYG (what you see is what you get) tool apply all the formatting I want through the interface and then look...

  • RE: Email Formatted HTML Table with T-SQL

    I've never had a problem with any of the email clients. Simple HTML is recognized by all of them.

  • RE: Email Formatted HTML Table with T-SQL

    This subject is very dear to my heart - I had to do so many projects that send emails to customers. One thing I always do is create HTML templates...

  • RE: Counts Puzzle

    skyline666 (8/27/2008)


    Yes thats a good point, temporary tables only exist for the life of the stored procedure (when prefixed with one #), I temporarily forgot about that ;).

    That's not exactly...

  • RE: Counts Puzzle

    skyline666 (8/26/2008)


    ian treasure (8/26/2008)


    Shouldnt this be

    SELECT C.CATID, COUNT(*)

    FROM #DATA DINNER

    JOIN #CATEGORY C ON (C.VAL1 = DINNER.VAL1) OR (C.VAL1 IS NULL)

    GROUP BY C.CATID

    (was ON C.VAL1 = D.VAL1)

    Nope, its this:

    SELECT...

  • RE: Reformat via query?

    "Format C:\ COMPLETE" Takes me back to DOS days pranks. Nowadays we just add couple of zeros to the end of daily sales numbers. πŸ˜›

  • RE: CASTing

    Simon Facer (5/27/2008)


    The REPLICATE('-', 8000) has an implicit cast to NVARCHAR, try this to explicitly CAST it to NVARCHAR(MAX):

    declare @C nvarchar(max)

    set @C = N'hello' + CAST(replicate('-',8000)...

  • RE: CASTing

    About size of nvarchar(max)

    I tried this:

    declare @C nvarchar(max)

    set @C = N'hello' + replicate('-',8000)

    print len(@c)

    the result was still 4000. Can someone explain why it wasn't more since...

  • RE: A Function Gotcha with the Use of an Asterisk

    Another alternative to drag-and-drop is click on word Columns then Ctrl+C to copy then in query window position your coursor where it should go and Ctrl+V to paste. This way...

  • RE: Largest Unit

    That reminds me of an old joke:

    What’s the difference between mechanical engineer and computer geek?

    Mechanical engineer thinks Kilobyte is 1000 bytes.

    And computer geek thinks kilometer is 1024 meters. πŸ˜€

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