I meant do you even have permission to create one?  If you do, you'd do it something like this:

ALTER TABLE Table3
ADD DescColour AS (
    CASE

It's likely to be a table scan caused by the non-sargable LIKE operators that are causing you pain, by forcing a scan of the whole table.  I imagine that if...

WHERE ORDERS.Status IN ('New','Open')
AND ((FSLog.IDNum IN (16,19,116,136,225) AND FSLog.CompletedDate IS NULL)
OR ((FSLog.IDNum IN (345) AND FSLog.CompletedDate IS NULL) OR (FSLog.IDNum IN(333) AND FSLog.CompletedDate IS NOT NULL)))

Santhosh

Have you tried looking in the sysdtslog90 table?  It's a while since I used it, but I think it's in msdb.

John

You're welcome.  I see what Thom was saying now.  My solution concatenates the values into a single column.  Your expected results contain six columns.  But if your happy with what...

WITH Partitioned AS (
    SELECT
        (ROW_NUMBER() OVER (ORDER BY Id) - 1) / 6 AS PNo
    ,    Id
    FROM @TestData
    ) 
SELECT DISTINCT
    STUFF((
        SELECT ', ' ...

What happens if there are more than three groups?  Do you need to add more and more columns if there are?

Is this for a report?  I would recommend...

Does t2 have the same structure as test_tbl?  If so, why are you trying to insert the value "99.999" into a varchar(5) column.  And why is the column varchar at...

So you only want to look in columns called MEMBER_FIRST_NAME?  Or do you want to look in all columns?  If it's just the one column name, query INFORMATION_SCHEMA.COLUMNS to find out...

I think I'd be happy to go with the recommendations therein.  Don't be afraid to tweak the settings if necessary to improve performance, though.

John

Do you have a link to the article, please?  Our standard is as follows:
·          For servers that have NUMA configured, MAXDOP should not exceed the number of CPUs...

Nicole

How about a trigger on sysjobhistory?  I think that's legal, although I've never tried it.

John