Sorry forgot

GROUP BY MAINVALUE

Yes basic format

SELECT

MAINVALUE,

SUM(CASE WHEN PIVOTCOL = VAL1 THEN 1 ELSE 0 END) AS VAL1,

SUM(CASE WHEN PIVOTCOL = VAL2 THEN 1 ELSE 0 END) AS VAL2,

.....AND SO ON

FROM TABLEX

They are declared as you see. I went and found them one day and forget how to tell what is what.

Besides if your concern is code theft just make sure you have the proper copyrights and stick it too them. If it is code tamper have a disclaimer against that...

Hem, from the error that is odd, unless did you run the app from the server itself or a remote machine. If the server then I believe it was problem...

I believe and I may be wrong that when they created the views and stored procedures they ran them once with WITH ENCRYPTION then opened the in SQL EM and...

I see, what you are doing with subqueries is fine except you lose a lot of bennifits of indexes when you do it this way as it creates a derived...

I actually use a similar item already for an app the is user definable and settings are mobile. With our case we have a file assigned by user id that...

Just as an aside and to poke at Microsoft for fun has anyone seen this: <a href="http://news.zdnet.co.uk/story/0,,t269-s2102244,00.html">.Net vote rigging illustrates importance of Web services</a>.

There are lots of books, web sites and other instruction materials out there. But what are you having trouble with and we can see if we can help (but not...

But the problem error code in the ado reference set states "Data source name not found and no default driver specified", I don't feel it is the server but the...

What is the column datatype of each situation?

I agree with Steve it would be easier. But if you do not want to go that way I will be glad to find code that works like this but...

Do the folowing. Put a break point at

ConnectionString = "Provider = SQLOLEDB; Data Source = " & DBServerName & "; Initial catalog = FastFood; UID=UserFastFood; PWD=fastfood;"

and when you pass...

Basically column order should never matter, it is the way you display that determines what a user will generally see anyway. Column are just for you to control the storage...