Going through your code I found your function, dbo.fn_CSVToTableString. You obviously did NOT read the article I posted a link to for you. There are two major issues...

kevin_nikolai (3/29/2014)

---

Hi Jeff / Lynn, I updated the query I posted.

Added '1_Script.txt' , collation is 'SQL_Latin1_General_CP1_CI_AS'.

Added function to cater for multiple SRID's via the parameter ( @SRID...

Jeff Moden (3/29/2014)

---

Lynn Pettis (3/29/2014)

---

kevin_nikolai (3/28/2014)

---

Hi Sean, I managed to create scripts which only includes the very minimum records, therefore no need to compress them. Attached the 3 scripts. First...

A clustered index on StartBusinessDate + an identity column would probably be a better clustered index on the table.

kevin_nikolai (3/29/2014)

---

Hi Lynn,

Since the highest level reached is 1, for simplicity sake, you can remove the following:

DECLARE @lvl_limit AS int = 2;

and

WHERE lvl < @lvl_limit

----------------------------------

You can use...

I haven't been to many of the WIT sessions but the few I have been at and from what I have read, these groups are NOT made up of just...

Missing additional details, such as what columns are used to link the two tables, is it the ID column or the NAME column? Is there always a one to...

For this particular issue, possibly no real benefit. The problem we are having is that we can't see what you see which means all we can give you are...

Here is where I am going to start you. Since you have declared the input parameter to the stored procedure as NVARCHAR(MAX) I would not use a T-SQL CSV...

kevin_nikolai (3/28/2014)

---

Hi Sean, I managed to create scripts which only includes the very minimum records, therefore no need to compress them. Attached the 3 scripts. First script is to create...

river1 (3/28/2014)

---

Hi,

I'm doing this query:

DECLARE @TESTE BIGINT

DECLARE @DB VARCHAR(100)

SET @DB ='SGCTCENTRAL'

SET @TESTE = ('SELECT MAX(CODIGO) FROM '+@DB+'.DBO.SINCRONISMO')

SELECT @TESTE

I get this message:

Msg 8114, Level 16, State 5, Line 8

Error converting...

Jeff Moden (3/29/2014)

---

tlunsf (3/28/2014)

---

It is comments like...

dost ind (3/29/2014)

---

I want to write rolling 12 SQL query with following data , input will be FY and period no ie @FY=14, @P=3

my result should show rolling 12...

shashianireddy (3/29/2014)

---

I HAVE TABLE LIKE BELOW 3000 ROWS

NAME ADDRESS IDNO EMPCODE

SVR HYD ...

Not sure if this will help but it is a place to start:

http://msdn.microsoft.com/en-us/library/ms162819(v=sql.120).aspx