Thanks for the tips. I ended up going a different route instead which will eliminate my database from growing. What I did is generate an excel report around midnight...

I went ahead an re-installed, seem to work now. I was trying to avoid this.

I am getting this requirement from DoD DISA STIG for SQL Server 2012

SQL Server must be configured to use Windows Integrated Security. SQL Server Authentication does not provide for...

To clarify things in case I did not. The SQL Server is on a separate Win 2008 R2 than the Web Server (WIN 2008 R2).

The connectionstring for Windows Authentication...

Suggestions were applied. I removed RECOMPILE and renamed the @p parameters to meaningful names.

Also, i ran a load test yesterday with 500 users putting a load on a web page...

I still received timeout errors after i made changes based on the suggestions i was given.

Even after i replaced my splitter with DelimitedSplit8K I still did receive timeout errors.

But...

I went with several recommendations which were.

1. With RECOMPILE

2. Replaced splitter with DelimitedSplit8K

3. Went with INTO #TempFL vs Creating Table #TempFL

And last but not least the SQL in the wild...

I posted my splitter function Above.

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

My understanding was that instead of doing a NOLOCK on each table this would apply to the entire query....

I am using 2 splitter function.

ALTER FUNCTION [dbo].[CommaListIntoTable] (@InStr VARCHAR(MAX))

RETURNS @TempTab TABLE

(id int not null)

AS

BEGIN

;-- Ensure input ends with comma

SET @InStr = REPLACE(@InStr + ',', ',,', ',')

DECLARE...

User has the option to do a multi-select on states so nvarchar(10) will not work but i guess i can do nvarchar(200)...

I just ended up keeping MS Access on my application and did away with the view that was giving me problems. When you import a SQL View to MS Access...

Hi, I was searching the web while waiting on a reply and found similar syntax to what you provide. So I am good to go.