SQL and the JOIN Operator
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
2011-03-03 (first published: 2009-10-07)
46,907 reads
JOIN
RE: Need Help Writing a CASE Statement???
Once you have all null values updated to 7.45 in the table, you may want to set Col014 to not null and set a default value of 7.45 on the field to prevent any more nulls.
2005-03-09
RE: Build query by using function
Try this: SELECT SerialNumber, PassFail, CASE WHEN [PassFail] = 1 THE 'Pass' ELSE 'Fail' END AS Expr1 FROM TestLog (Note, this does not include any test for a NULL or any other number..., you may want to look up CASE in BOL and see if you want to include more...)
2004-12-06
RE: MSDE 2000 sample databases
You might also try www.gotdotnet.com, www.asp.net, http://sourceforge.net/These are all oriented to developers (as thats what I am)
2004-11-01
RE: SP Newbie 2 questions
Hi Josh, You are welcome. and( SS.status_id = @entry or @entry is null) if @entry is null this will always evaluate to true, thus return all the rows no matter what SS.status_id is. if @entry is not null this will only evaluate to true if SS.status_id = @entry, thus returning only the rows with the […]
2004-07-16
RE: 70+ columns in a single table.
So my 284 column table shouldn't be so bad??Nothing like inheriting that and then having the owner tell me how it should be able to respond to almost any query in under 30 seconds (26Mil rows or approximately 25GB of raw data)
2004-04-28
2004-01-30
1 reads
RE: DTS Numbers export to Excel ends up as text
Don't use the '$' character in the name. Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface
2003-12-08
2003-08-20
1 reads
RE: Using IDENTITY_INSERT with linked servers
I agree that this should be done with stored procedures. It's to maintain a total of four environments (live, uat, sys-test and dev), so I was hoping to have the SP's on a single environment rather than having to maintain the same SP's in four places. I guess it's not the end of the world […]
2003-07-29
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers