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...
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
June 2, 2005 at 8:10 am
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...
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
June 4, 2004 at 8:14 am
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
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
June 4, 2004 at 8:03 am
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...
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
May 7, 2004 at 12:55 pm
I would prefer simply:
CHECK(minit LIKE '[ A-Z]')
Why split it into two checks?
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
May 4, 2004 at 7:34 am
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...
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!
April 30, 2004 at 7:55 am
Viewing 6 posts - 6,826 through 6,831 (of 6,831 total)