So many people misrepresent their skills and experiences. So many people survive for long periods of time in jobs without significant accomplishments. I've seen DBA teams of 8-10 with 1...

I'll ask and see.

And then they want/need something different once you deliver it!

Part of it seems to be that users aren't sure of what the want and their desires change as they start...

This has been answered here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=340&messageid=347558&p=3

Why do you need to create a view? I'm not understanding something about what you are looking for.

The text you give for the example does not show in the sample table. Can you post exactly what you are looking for with multiple dates and sales? At hour...

That's a good idea. I'll look at making the change.

And for the last word today...

This was an interesting debate. However I agree with Loner that we should get back on topic.

Red Gate has promised a "licensing clarification" tomorrow...

Thanks and please let me know if I'm ranting too much.

Maybe it's time to go back to talking about windmills and cool cars

Thanks for the advice.

BTW, anyone got good recommendations on what to read to get up to speed on BI/DW practices? I'd like to educate myself a but more between now...

The site name is the address. There's a "Files" tab where you specify the file.

What are the results you are looking for?

A sum will give you a count, such as

select sum( tl.pinid)

, datepart( hh, t.transactiondate) 'hour'

from transactions t

inner join...

Wow, not sure you need all the subqueries. Try converting some of those to joins.

like

update researchdaily set spfac1 = b.spfac from researchdaily

join (...) a

inner join researchdaily...

John has great suggestions, but how are you calling BCP? Is this something a person runs or is it automated?

Chris,

Valid comments and I did email Mr. Boule and did not get a response. I also emailed someone else at Quest.

Also, I received 2 or 3 email complaints about the...