This line:

4 SQLNCHAR 0 1000 "\r\0\0" 3 LastName SQL_Latin1_General_CP1_CI_AS

is missing a backslash-n, but that seems to be a trick from SQL Server Central. I need to dig further.

Jeff Moden (9/13/2013)

---

Ah, but you CAN call a stored procedure though a SELECT using OPENROWSET. If you need to pass parameters to the sproc, it becomes a bit of...

datediff(YEAR, BirthDate, getdate())

CREATE TABLE #table1(col nvarchar(1));

CREATE TABLE #table2(col nvarchar(1));

INSERT INTO #table1 SELECT 'A' UNION ALL SELECT 'B' UNION ALL SELECT 'C';

INSERT INTO #table2 SELECT 'X' UNION ALL SELECT 'Y' UNION ALL SELECT...

SELECT object_name(object_id)

FROM sys.columns

WHERE name = 'WS_ID'

Maybe you could explain in the first place why you expect there to be a function with that name? What does this query return:

SELECT name, type, schema_id FROM sys.all_objects where...

Filtering in the report is probably OK, if that filter only removes a smaller set. But if the filter removes one million rows of one million two hundred, that's really...

I realised that CTE3 is not necessary, so the query can be simplified to:

WITH CTE1 AS (

SELECT OS.OrderID, d.thedate,

...

Given the data you posted, the expected output is 13 I hope, as there is no exclusion before the 14th.

Anyway here is a query. I'm fairly sure it can be...

If you have users defined from SQL logins, they may not map to SQL logins on the new servers. Mapping is on SID, so even if there is a login...

Have a look at this thread from the MSDN forums, where I answer a similar question. Hopefully it should get you started.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/36b98d06-fe73-4849-ba68-c8a2110afba0/how-can-i-divide-transaction-on-fifo-basis

If that does help you, please post your table...

What sort of environment is this? Are both computers in the same domain? Do you only have a workgroup?

Getting MSDTC to work when you don't have the trust from a...

pietlinden (9/13/2013)

---

One question though... when you remove the subscript from the array, does it act like a collection or something and you can just use IN(@Collection)??? Just trying to...

That should work. That is, if you have...

Which version of SQL Server were running prior to SQL 2012?

How is the connection string set for the application?

When you use an application role and use connection pooling, you must...