Grant Fritchey (6/14/2011)

---

OK. Then the issue still comes back around to what the heck is changing. Well, for what it's worth, statement 7 in one was cheap & quick and...

I asked the developer to make the following changes so far:

> Rewrite UDFs used in SELECT column list that were using CURSORs to generate a comma-delimited list to use the...

PS For NVARCHAR fields it's best to prefix your string literals with the capital N:

INSERT INTO [dbo].[test_insert_number] ([text]) VALUES (N'a0123b')-- works as expected

alexms_2001 (6/14/2011)

---

Who can explain what actually happens when you insert a number _without_ quotes (it actually happened by mistake) into an NVARCHAR field? Here is a simple test:

IF EXISTS (SELECT...

New info:

The StatementSetOptions in the XML are apparently wrong per this bug report:

http://connect.microsoft.com/SQLServer/feedback/details/335971/statistics-xml-always-report-the-same-statementsetoptions#details

The bug report is for one of the 2008 CTPs but the bug is there in my version...

Another option is to use a a Cross Tab Query:

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

My initial thought was to recommend looking into the Search Server built into SharePoint. I have implemented it. It's a great way to expose an organizations disparate data down to...

A third-party FTP tool component be best for this sort of thing. Here is a good one for .NET. The free version may do most of what you need. If...

imani_technology (6/13/2011)

---

My boss has created an SSIS package that calls a view within the source (SQL Server 2008 staging database). I just looked at that view and discovered that...

A dynamic PIVOT will work fine but to take it to the next level please consider using a Dynamic Cross Tab Query for this job. These two comprehensive articles on...

Grant Fritchey (6/13/2011)

---

61 different statements... You're on your own.

I will note that statement 7 & 8 (two of the highest, one in ON & one in OFF) both show ANSI_WARNINGS...

Maybe something along these lines will work:

WITH cte(StudentId, StudentName, TeamId)

AS (

...

Thanks Carsten, I appreciate the post. Good luck!

- Orlando

The proc produces one resultset and the...

I am officially stumped.

Have you been able to recreate the issue in any environment?

If you can recreate it in a non-prod environment I would recommend getting Microsoft Support involved.

I am...