Just for fun, using the SQL 2012 LAG function, this query matches ChrisM's first result:

SELECT LinkingID, ID1, ID2

,rn=CASE WHEN ID3=ID2 AND ID4=ID1 THEN 2 ELSE 1...

Brandie Tarvin (1/23/2015)

---

Have you tried recreating the proc without the versioning? (I.E. without the "; 1") and then executing it through your code that way? Then see if it still...

We believe we have isolated the problem to a different method used to call the SP from C#.Net.

We are working through the recoding on that and I expect to see...

A couple of clarifications...

Numbered stored procedures: http://beyondrelational.com/modules/2/blogs/77/Posts/19618/0289-sql-server-deprecated-features-numbered-stored-procedures.aspx (This was new to me but I could have done without the information since clearly it will be deprecated).

The first profiler trace posted...

I'm hoping that anyone with knowledge of older versions of .Net Framework and Crystal Reports might be able to help me with this one:

http://www.sqlservercentral.com/Forums/Topic1653942-391-1.aspx

Thanks in advance for taking a look.

The answer...

I can also confirm that in SQL 2008 if you remove the CTE it works.

This also works, but sort of defeats the purpose.

CREATE TYPE test_list AS TABLE(a int);

GO

CREATE FUNCTION dbo.test_function...

Runs fine on this version of SQL:

Microsoft SQL Server 2012 - 11.0.2218.0 (X64)

Jun 12 2012 13:05:25

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601:...

Indeed there are many ways. Jeff's articles are great. There is also this one:

https://www.simple-talk.com/sql/performance/the-performance-of-traversing-a-sql-hierarchy-/

What exactly are you trying to get out of that second SELECT?

Is this what you are looking for?

SELECT XMLRECORD

FROM (SELECT @xml) a (XMLRECORD)

CROSS APPLY XMLRECORD.nodes('/row') t(p)

where p.value('(./c1)[1]', 'VARCHAR(8000)')...

Another way using Erikur's sample data and no ROW_NUMBER():

CREATE TABLE #A (num1 TINYINT NOT NULL PRIMARY KEY);

INSERT INTO #A(num1) VALUES (1),(2),(3),(4),(5);

CREATE TABLE #B(ltr CHAR NOT NULL PRIMARY KEY);

INSERT INTO #B(ltr)...

Sean Lange (1/20/2015)

---

dwain.c (1/20/2015)

---

Sean Lange (1/20/2015)

---

Ed Wagner (1/20/2015)

---

Brandie Tarvin (1/20/2015)

---

Sean Lange (1/20/2015)

---

We are finally starting to move our ERP to a new system (well new to us but still rather...

ashokputta9 (1/19/2015)

---

Hi everyone i want split the data this below format..

1.Split the RR ("PL:TW RR:1.8%,PL:TX RR:0.9%") into LowendRR ("PL:TW RR:1.8%") and HighendRR ("PL:TX RR:0.9%")

2.Split the LowendRR ("PL:TW RR:1.8%") into LowendPL...

I'm going to backtrack a minute here and ask why you have a process to calculate your user account balances?

Doesn't that imply that, between processing runs the balance is not...

Using the first of your examples:

SELECT

Method = 'Integer Inclusive',

t.RID,

t.Num,

s.LowerBound,

s.UpperBound

FROM...