an old favourite :

"Spaghetti Coding" - code with no discernable structure or comments, loads of GO TO statements

[for the older folk]

"Black Hole" - a project that gets loads...

Found your post a bit confusing, [what . net technology are you referring to?] but as I understand, you're trying to populate a table from a .net form using...

From your description, I do not understand why you group on value and time...

group your rows on lab - correct

Group your columns on Parm only - this gives one...

You could try to add a trigger on the items that updates the header total

*by adding the entire item total when item records get inserted, and

* adding the...

This could have a myriad of causes.

Could you perhaps elaborate on the connection / authentication types used in your reports ? are there specific error messages generated ?

The most obvious...

Guess that mostly depends on where you're at ? 😀

Business Intelligence is a rather wide field

As your post is in a SQL forum... See if you can get your hands...

From your description I assume that Pin is supposed to be unique ? therefore using it as Key

This is not the most elegant solution, but it should return what you've...

I have had a similar problem after loading an additional instance of SQL Express on my machine.

This was resolved by re-applying protocol settings in SQL Configuration Manager, and restarting the...

IIS timeout has occurred. Check IIS Connection timeout setting on your Reportserver. Does not sound like a huge report, so not sure why the timeout occurs. This is by default about...

I have on occasion used up to 7 joined tables in an Update, and get problems when not aliasing the updated table. not sure why

UPDATE A

    SET A.HomeScore = 14,

         ...

Easiest might be to load your query into a string variable and exec the variable in your proc.

Eg.

declare @SQL as varchar(8000)

set @SQL = 'Select * from Customers WHERE CustomerCode IN ('...

Hi.

SQL's answer to the "Oracle Materialised view" is the "SQL Indexed View"

See:

http://www.microsoft.com/technet/prodtechnol/sql/2005/ipsql05iv.mspx

Try using the Create View statement in Query Analyser instead of the View Designer. I have had quite a few similar occurrances where Enterprise manager validates syntax or connections incorrectly,...

I would use a cursor to retrieve all employees that have duplicates, then load the first record found in a sorted list for this employees into a temp table variable.

declare...

Good day.

We have been using the Cognos toolset for the past 5 years on a SQL backend. Before that, we used SAS, and are currently investigating the use of SQL2005, QlikView,...