A different approach maybe?

Is it possible to build a table that links a 'web-product-attribute' to a 'crm-product-attribute' in some way? Is this some kind of general structure that is always...

What is the type of the variables? If you're using integers, your division is an integer division, truncating the fractional part.

Check the division operator in BOL for more info.

There should be some stuff in the Scripts section about this.

An alternative is parsing the list of values in a temporary table (or table variable) and joining the source table...

This is only possible using a dynamic query.

Try this:

CREATE PROCEDURE sp_Proc1

@listofValues As varchar(50)

AS

DECLARE @stmt varchar(4000)

SET @stmt = 'select * from tbl1 where col1 in (' +...

Difficult problem.

I would probably go for the separate table. This keeps both functionalities (data and auditing) neetly separated and gives you the greatest flexibility in the future.

It will also avoid...

I hate those SELECT * statements. I will slap my collegues around the head for using it

Well, anyway, luckily I don't think anyone is subscribed to...

OK. Stupid me... All values in the select clause have to be contained either in an Aggregate or a group by.

So change the query to..

SELECT T.*...

In general, Task Manager's Process view is not a good place to look for the memory that a process uses. Just add all the values and compare that to the...

So, in fact you are looking for duplicates.

You can use the CHECKSUM(*) function for that.

SELECT *

FROM (SELECT *, CHECKSUM(*) AS cs FROM table)

GROUP BY cs

HAVING COUNT(*)...

Just to complete this.

When you resolved the issue during development, you probably changed the value of QUOTED_IDENTIFIER.

SET QUOTED_IDENTIFIER OFF

I guess your server was running out of (virtual) memory. And the CryptoAPI function needed more than was available. This could be a memory leak in some application or just...

If I understand you correctly, in the *web products attribute table* you have one row per product containing all the attributes.

In your CRM table, you have one row per product...

To count the number of shifts, you have to group by the date.

SELECT bf_table.COUNT(*) as breakfast,

       lu_table.COUNT(*) as lunch,

 ...

Great that everything is up and running. But this still seems strange to me.

A trigger is something that is fired on the server. The application interacting with the database has...

Are you sure about your ASP.NET code?

Secondly, is the SQL Server on the same machine as the IIS Server? If different boxes, are you sure both machines can access each...