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

Script comments have been noted as well. Thanks for those.

I think we'll do our best to avoid more ads, especially bigger ones. I think the Google ones are relatively unobtrusive,...

Actually I was hoping for people to post comments, questions, and thoughts on products. And I was hopeing to have vendors respond, post press released, etc. I hoped to minimize...

Interesting responses. I interviewed about 5 years ago with someone (I had a decade of SQL Server experience at the time) and they gave me a paper test with 15...