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

PS @@VERSION = Microsoft SQL Server 2005 - 9.00.3073.00 (Intel X86) Aug 5 2008 12:31:12 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows...

Steve Hindle-535638 (6/13/2011)

---

Apologies - my first post should have said db_owner (fixed database role) and not dbo (user). If a user DOMAIN\steve is a member of the db_owner database role...