Viewing 15 posts - 9,946 through 9,960 (of 59,065 total)
Please see the following article. I consider it to be the "GO TO" article for such queries.
https://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
January 23, 2019 at 7:39 am
January 22, 2019 at 9:22 pm
In what way can I have a result of a table that the columns...
January 22, 2019 at 9:11 pm
Agreed with the others. Nice job on the article, Kimani .
BTW/FYI... you CAN actually call a stored procedure from within a function using OPENROWSET. Because...
January 22, 2019 at 8:12 pm
January 22, 2019 at 7:07 pm
Please don't use EOMonth. If you're trying to write criteria to isolate a month in your queries, use the standard of "SomeDate >= FirstOfMonth and SomeDate < FirstOfNextMonth". It'll work...
January 22, 2019 at 6:48 pm
I could easily put together a test in a VS project but it...
January 22, 2019 at 11:52 am
Bruce-12445 - Monday, January 21, 2019 11:16 PMthanks Jeff the OPENQUERY solution solved all discrepancies.
Thanks for the feedback, Bruce.
January 22, 2019 at 11:03 am
January 22, 2019 at 11:02 am
However, you'd almost...
January 22, 2019 at 10:57 am
Viewing 15 posts - 9,946 through 9,960 (of 59,065 total)