Not sure exactly what you're looking for here but I'll give it a shot. In BI, ad hoc generally means something that cannot be addressed or generalized to a process,...

Are they on the same server? If not are they linked servers? If so,

Select p.UserID, e.Name, p.Prodoct

From ProductDatabase.dbo.tableProduct As p

Join EmployeeDatabase.dbo.tableEmployee As e

On p.UserID = e.UserID

hth

Sorry. Please disregard. Better to handle in the query and then group on "week".

Second day and I'm still enjoying the discussion. No matter which side you're on (I think the vast majority here are on the correct side), the good thing about hot...

The article was excellent. It went a long way as an intro on the benefits of thinking set-based in SQL. The "technical" reasons were stated very clearly (eventually). I look...

Flo, Thanks very much for this post. Very helpful to me as well.

From within BIDS - Report Designer, on the Data tab click the dataset drop-down and choose new dataset to create as many datasets (queries) as needed. Each query may...