I guess I should see if I can find some more books... a few more and I'm gonna have to buy a new book case, or just dump some ......

Thanks, Alan... is there a book on T-SQL that discusses using Temp tables etc vs TVFs etc? and CROSS/OUTER APPLY too? (although I like SQLKiwi's explanation of the topic)...

Thanks for answering... I was wondering especially about when to use Temp tables etc when writing queries. Most of the stuff I read doesn't cover really complex querying, which...

Does this work? Where's your data for 25?

SELECT CID

,SUM(Worked) AS Hrs_Worked

,SUM(Sick) AS Hrs_Sick

FROM (

SELECT CID

, Hrs

--, Hr_type

, CASE WHEN Hr_Type IN ('Full', 'Part', 'Contract') THEN Hrs ELSE 0 END...

This is a bogus question.

There are times when you need table-valued functions, and even cursors, which a lot of developers strongly dislike. Sometimes, using a cursor is the best...

You need OR, not AND.

select * from #employee

where FirstNm = 'John'

OR FirstNm = 'Linda'

What would you return if the value were NULL? Kind of depends on what you're trying to do. NULL is no the same as zero. NULL means "unknown".

If you're...

This worked...

USE Tempdb;

GO

DROP TABLE #tempTable;

GO

CREATE TABLE #tempTable(

col1 varchar(5),

col2 varchar(5),

col3 varchar(5)

);

GO

INSERT INTO #tempTable VALUES ('aa', '100', 'vv'),

('200', 'bb', 'dd'),

('dd', 'nn', '300');

SELECT COALESCE(TRY_CONVERT(INT,col1),TRY_CONVERT(INT,col2),TRY_CONVERT(INT,col3)) AS Result

FROM #tempTable;

If the TRY_CONVERT...

We don't do your homework... that's your job. the way to test your design is to add a few records to your table and test... did you do that...

Normalization is a beautiful thing. And...

Normalization is a beautiful thing. And...

why not just put each letter in its own rectangle? (and all 3 inside another rectangle). Then you can control the page breaks yourself

Where to start...

you need to get the age of each sale (or whatever it is) in days, so you can put them into [1-30], [31-60], [61-90] days old bins...

I'm calculating...

Welcome to SSC,

Since you're new here, the first thing you should learn about is how to ask a good question. Jeff Moden wrote a terrific article on it, which...

You should definitely read the article Jeff suggested. It's the only reason I'm thinking I shouldn't post this yet. It's just one of those "Ask a better question to get...