What is your question?  Remember we can't see your screen and we don't know anything about your data.  We'll need the actual execution plan as a minimum here to help...

That's not the full output of that query.  And did you run it while the index creation statement was running?

John

What is the wait type for the SPID that's attempting to create the index?

John

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...