Chris Lane (3/11/2009)

I created a local user account just like the article stated with the same name as in the article, problem is I can't browse the Reports Server...

BIDs is not the same as the full blown Visual Studio.Net that is why you don't see those other templates when using BIDS. You need Visual Studio to do web...

Hi,

I created a local user account just like the article stated with the same name as in the article, problem is I can't browse the Reports Server websites in...

Does anybody have any idea why I don't see the Business Intelligence Project Templates for Visual Studio 2003? My local SQL 2000 has SP3.

I used to believe in plural table names but not anymore and going back to Boyce and Codd they argued against using plurals for table names. I already know a...

Yes, that is exactly what I need, but what to call the Question to group join table?

Question

QuestionID PK

QuestionGroup Or Just Group? Group by itself seems to vague.

QuestionGroupID PK

JOIN TableName...

I completely agree with the large datasets and importing data then for performance it makes more sense to combine them in the same proc. It shouldn't be all that...

Cool, thank you for your answer and suggestion it is much appreciated!

I am trying to get the the AVG of the HourlyRate for all hourly employees but I need to use the deductionHrlyRate because the individual rates must subtract 1 if 2nd shift.

The...

DOH you are right I am already doing that with the Max(SalDate)

I thought I needed the Distinct because in the EmpSalary table there is an entry for each raise an employee...

As far as I know the only way to rename a worksheet in a workbook through code is to use the Excel API. Which I don't think you can do they...

Hi Andy,

Can you please explain why you think a single update proc doesn't need an explicit Transaction?

Your super proc is a good example but I guess I would probably still...

Thank You!

I see what I was doing wrong with the cast now, Thanks for the correct answer!

Query ANalyzer doesn't like to run eithier of those statements because of a datatype mismatch. I still think it is incorrect without the cast and I can't seem to get...