May not be the best solution but should work for you calculation try ( ISNULL((CASE When ST1Q1 = 'N' Then Null ELSE ST1Q1 End),0) + ISNULL((CASE When ST1Q2 = 'N' Then Null ELSE ST1Q2 End),0) + ISNULL((CASE When ST1Q3 = 'N' Then Null ELSE ST1Q3 End),0) + ISNULL((CASE When ST1Q4 = 'N' Then Null ELSE […]
2003-06-17
As we all know 'I' (via the constraint object)is enforced by SQL Server whilst the data is still in the data cache, and has been prompted (wanted to say triggered but realise that is bad word) by the change in data value. Now if the data can only be changed by replication, there seems very […]
2003-06-14
1 reads
Another way is SELECT CASE WHEN col2 IS NULL THEN col1 ELSE col1+ ', ' +col2 END FROM ....
2003-06-12
1 reads
Try moving the ',' into the ISNULL function. SELECT Col1 + ISNULL(', ' + Col2, '') This way the comma will show up only when you have a non null value in Col2
2003-06-12
1 reads
2003-06-12
1 reads
Hi Brian, quote: As promised, here's the direct link: http://qa.sqlservercentral.com/testcenter/QOD.asp please help a blind to see. Can I see the overall results of QOD? Can I see with how many points my account has been credited? Cheers, Frank
2003-06-05
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-19
Here is an article I wrote about changing collation. http://qa.sqlservercentral.com/columnists/glarsen/collate_part2_1.asp Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-05-15
You must have a mail client that can be outlook. But is must configured in sql. It is not just adding your email adress. You can also be notified by net send notifications, wich is much easier. You must just add the net send adress in an operator.
2003-05-15
I'm beta testing a new events board that integrates with the forums. If anyone has any local or national events (SQL related), please feel free to run this through the ringer and send any bugs to bknight@sqlservercentral.com . http://qa.sqlservercentral.com/forum/events.asp Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight
2002-03-25
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers