Know your UNION(s), NULL(s), COUNT(s) ?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Todd Carrier » Know your UNION(s), NULL(s), COUNT(s) ?

Add to briefcase

25 posts, Page 3 of 3

Know your UNION(s), NULL(s), COUNT(s) ?

Expand / Collapse

Author

Message

Posted Tuesday, June 10, 2008 11:42 AM

Valued Member

Group: General Forum Members
Last Login: Friday, August 17, 2012 6:07 PM
Points: 62, Visits: 124

re PL/SQL: I confess that I have been visiting the 'dark side'.

Post #514677

Posted Tuesday, September 16, 2008 6:22 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, October 04, 2012 11:13 AM
Points: 257, Visits: 80

I went to check my guess and ran:
WITH DATA (Numbers) AS
(SELECT NULL UNION ALL
SELECT NULL UNION ALL
SELECT NULL UNION ALL
SELECT 1 UNION ALL
SELECT 2 UNION
SELECT 3)
SELECT COUNT(ALL Numbers) AS NULLNumberCount FROM DATA
WHERE Numbers IS NULL

and got:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'WITH'.

Ooops

Post #570134

Christopher Stobbs

Posted Tuesday, September 16, 2008 6:28 AM

SSCommitted

Group: General Forum Members
Last Login: Wednesday, February 24, 2010 4:10 AM
Points: 1,553, Visits: 2,232

if your with is not the first line of code, then you need a ; before it

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

w00t

w00t

Posting Best Practices
Numbers / Tally Tables

SQL-4-Life

Post #570140

Posted Tuesday, September 16, 2008 6:47 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, October 04, 2012 11:13 AM
Points: 257, Visits: 80

Christopher Stobbs (9/16/2008)

if your with is not the first line of code, then you need a ; before it

Ok, it worked. Thanks.

Post #570167

Posted Wednesday, December 05, 2012 11:02 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:40 PM
Points: 1,059, Visits: 1,150

gr8 question....

Post #1393325

« Prev Topic | Next Topic »

Add to briefcase

25 posts, Page 3 of 3

Permissions

Expand / Collapse