Viewing 6 posts - 6,826 through 6,831 (of 6,831 total)
I agree with Tim 100%. The code suggested would not necessarily work and presumably would be less efficient than a not check. Very frequently when the qod is a T-SQL...
June 2, 2005 at 8:10 am
#562526
I assumed that too and got it right, but why not make the question match the answer:
Bill needs to show the day of the week for today's date on a...
June 4, 2004 at 8:14 am
#509021
Silly premise for the question, since it would require that the highest sales always occur on the current day. Just don't try rerunning the report
June 4, 2004 at 8:03 am
#509016
I think you can remove leading tab(s) directly within a SELECT, without any CASE or loop, for example:
DECLARE @tabPattern VARCHAR(8)
SET @tabPattern = '%[^' + CHAR(9) + ']%'
DECLARE @tabRemove VARCHAR(200)
SET @tabremove...
May 7, 2004 at 12:55 pm
#505705
I would prefer simply:
CHECK(minit LIKE '[ A-Z]')
Why split it into two checks?
May 4, 2004 at 7:34 am
#505134
You do understand that multiple CASE conditions could be true for the same value and that a single value could be added to every total?
For example, if cas_lbs...
April 30, 2004 at 7:55 am
#504830