Forum Replies Created

Viewing 15 posts - 391 through 405 (of 938 total)

  • RE: Forum Etiquette: How to post data/code on a forum to get the best help

    Hey Jeff, people trying to get answers in the newsgroups can certainly learn from your experience. The only thing I would add is that it also helps if people...

  • RE: How to join a table-valued Function

    Sergiy (10/17/2007)


    Mike, it would be nice if you'd pay some attention to the name of the forum.

    It's on top of the page, between "Home" and "T-SQL".

    There is no point to...

  • RE: How to join a table-valued Function

    Sergiy,

    Would it make you feel better if I said this feature was introduced in SQL 2005, as I did a couple of times in the first couple of posts of...

  • RE: How to join a table-valued Function

    Example removed at Sergiy's request.

  • RE: How to join a table-valued Function

    Something like this should do the trick, using [font="Courier New"]censored[/font]:

    Sample code removed at Segiy's Request

  • RE: NULL Equals NULL?

    That brings up the Y10K problem, and Joe Celko's descendants will be cursing your name for not addressing it in the 21st century 🙂

  • RE: NULL Equals NULL?

    You got it. Think of it like this - if you use a function in a WHERE clause or in an ON clause of a JOIN, SQL is forced...

  • RE: NULL Equals NULL?

    That's because the integer/smallint/tinyint data types have higher precedence in conversions, so the implicit conversions will try to convert character types to int* types. The COALESCE function you used...

  • RE: NULL Equals NULL?

    Hi BonnieMan,

    COALESCE() is different from ISNULL(), and I would guess that the difference in performance you experienced is probably owing to the differences in how COALESCE() and ISNULL() implicitly cast...

  • RE: NULL Equals NULL?

    I just performed a quick + dirty test to see the performance difference of using COALESCE in the WHERE clause. I ran three tests on the same simple data...

  • RE: Cancelling Customers

    Another classic editorial Steve   If I keep reading yours I might eventually get the hang of it

  • RE: The Pitfall of "Not Equal To" Operator in Queries!

    Worth noting that you can use use " select * " rather than " select 1 " or " select 12345 " for that matter.

    I have a sneaking suspicion that using select...

  • RE: Sprint''s New Business Model

    It's been reported that they've grandfathered in some sort of long-term "loss-leader" contracts from back in the day just to keep their sales numbers up (those pesky shareholders want to...

  • RE: Sprint''s New Business Model

    The soldiers reported having been Sprint Nextel customers for several years prior to this incident.  When they arrived back in the States, Sprint Nextel was more than happy to upsell...

  • RE: Sprint''s New Business Model

    One thing that's really confusing about the Sprint Nextel situation is that the customers they are firing are not bad customers.  These appear to be people who pay their bill...

Viewing 15 posts - 391 through 405 (of 938 total)