Anyone who knows ASP please have a look if you haven't already: http://www.sqlservercentral.com/Forums/Topic1806628-2799-1.aspx.

If all the settings on the server and instance are correct, and the code runs fine from outside the app, then look to the app and the web server. ...

Using the assumption I made above, here is my shot at a solution:

DECLARE @Table TABLE(

QRSID INT,

Title VARCHAR(20),

ParentID INT,

ResolutionId INT

);

INSERT INTO @Table SELECT...

vijay-367524 (8/5/2016)

---

Hi,

DECLARE @Table TABLE(

QRSID INT,

Title VARCHAR(20),

ParentID INT,

ResolutionId INT

)

INSERT INTO @Table SELECT 1,'Title1',0,4

INSERT INTO @Table...

BLOB_EATER (8/5/2016)

---

Grant Fritchey (8/5/2016)

---

BLOB_EATER (8/5/2016)

---

I would like to get into the mind-set of speakers out there. Now, as it stands I have zero-interest in presenting/speaking due to a lack of...

sqlenthu 89358 (8/4/2016)

---

Is there a way to write this query in better way

declare @listofids varchar(max)

select @listofids = 'abc1001|abc1002|abc1005|abc1090|bcd1020|bcd1120'

select t1.col1,t1.col1,t1.col3,t1.col4,t1.col5,

(select sum((case when @listofids<>replace(@listofids,t2.col20,'') then col15*10 else col15 end)

from table1 t1

inner join...

Here is an updated test. It may not be perfect but it is better than the last regarding test data.

if object_id('dbo.eTally') is not null

DROP FUNCTION [dbo].[eTally]

GO

/****** Object: UserDefinedFunction...

Reworking my test suite, as it generated all 5 address type for everyone.

Actually, I think my solution is quite viable. I created a 1,000,000 row test to compare the two solutions. I also noticed a difference between them where Eirikur's...

Just noticed that you have an entry for Work but tat wasn't included in you priority sort order in the original post. Where do you want that to be...

Jack Corbett (8/3/2016)

---

Lynn Pettis (8/3/2016)

---

Is the code I wrote here really that sophisticated, or is it that I have been doing this so long that for me it...

Is the code I wrote here really that sophisticated, or is it that I have been doing this so long that for me it is a basic SQL query?

Glad it worked.

jasona.work (8/3/2016)

---

Lynn Pettis (8/3/2016)

---

Ed Wagner (8/3/2016)

---

Lynn Pettis (8/2/2016)

---

Well, add another to that list. CF is a pain, especially when the developers embed the SQL code in the CF code,...

What would also help to confirm what is happening to see the execution plan, actual would be preferred.