SQL Server doesn't support the concept of color. Are you talking about Reporting Services or something else?

I have also received emails from both favourkarume11 and favourkarume12.

How about this: SET @auto='MD,RD,RS'

Are you entering non-NULL values in both storeNo and depoNO? A foreign key should only cause an error if you enter a non-NULL value that is not found in...

For what it's worth, you can accomplish the same thing with an outer join and an aggreaget function:

CREATE TABLE #Test(ID int IDENTITY(1,1), FirstName varchar(10), LastName varchar(10), Email varchar(10))

INSERT INTO #Test(...

If the column names and sample data you've listed are correct, you should be getting back row 3 and not row 2. I suspect that there's something wrong with...

Because SUM ignores NULL values, one way to do it is simply to find out whether any row is NULL and if so return N/A. One way to do...

This is SQLServerCentral.com, not MySQLCentral.

If I understand you correctly, you just want to extract one string from another. For that you need to use SQL's string manipulation functions, such as they are. ...

You can search the syscomments table: SELECT DISTINCT OBJECT_NAME(id) FROM syscomments WHERE text LIKE '%YourTextHere%'

You could try casting the datediff output from integer to a more precise decimal format. That way you don't lose precision early in the calculation and you can even...

You need to use dynamic SQL. Something like:

DECLARE @sql varchar(1000)

SET @sql = 'SELECT * INTO dbo.' + @TableName + ' FROM ' + @TableName +...

More information would be useful here. For instance, do you know if the slowdown is caused by sp_transform or by the select in CPOS.RP_TotalAccessories?

I think you're missing some quotes.

Try AND o.NAME = ''' + @tablename + ''''

Doesn't selecting into a temp table (SELECT * INTO #a FROM whatever) lock tempdb for the duration of the operation?