Your question forced me to look up the definition of the grain of a table... good thing to do.

Identifying the level of detail

The level of detail that is available in...

Can't vouch for any of this, but here's a discussion very similar to what you're trying to do.

I think I understand what's up with this... D3 apparently consumes JSON data. check out Mike Bostock's site... If you look at the bottom of the page,...

Is there any kind of consistency in the Excel files? Do the contents of Sheet1 always go to a specific table? If the sheet sequence and column sequences are consisent,...

If you have any say in the structure of the database, stay away from a design where you have dates/information for column names. Been there, done that. It was an...

Sounds like homework. So I'm not going to give you a direct answer, because then you wouldn't learn anything. And this forum isn't an answer machine...

If you're...

Did this ever work in Access? If so, I would look at the RowSource properties of the various forms involved, so you know what's coming from where. Once you...

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...