what the error means is that when using cascades you are not allowed to have more than one possible path for the cascade action to occur!!

ex

T1 <------------------------------ T2

 ^                                           |

 |-----------------T3 <-------------|

In...

can you post the DDL of EmployeeTests and Categories ?

not really, let me check 

The purpose was to check the INSERT statements. With varchar you get NO errors it will simply truncate the values. If those columns were declared as CHAR it will bomb...

Remi, the issue is not your query he needs to aggregate the data before your query is implemented. No matter which method you use the aggregation has to happen first...

if you have unit testing in place a quick way to find those is to convert all varchar to char and perform the tests you will find the errors and then...

sure I would love to see your app scale! ... it will be good for you

Then I will see you comming for help and...

Make sure the remote server is not running under "Local system account"!

don't get me started with the unnecessary use of cursors and where is

@myVar='10,80,90' used in there ?

I had thought of doing it this way, but was trying for something in 1 query instead of multiple.

Like I said Create a view with your original code then

the "second" query...

Just add a little string manipulation

SELECT convert(datetime, Left(MyDateString,8) + ' ' + Right(MyDateString, 12) ) as Converted

from MyTable

you should always try to separate data from presentation !! use sql for what is good at : Retrieve data (not mixed with Metadata) and ASP for dynamic Page building

If you want a long one I have this themes for you:

- DBA vs Developers

- Oracle vs SQL Server

- Indentity vs Natural Keys

...

but I would have never imagine that "multiple...

This is probably the longest thread ever !!!

Is this thread STILL alive???

Can you continue in a new one .... sheeshh