I thought they called that a heap?

One other thing. If you do have lots of rows (more than in the sample data), you might want to experiment with breaking Nevyn's solution into a divide-and-conquer approach,...

sqldriver (2/2/2015)

dwain.c (2/2/2015)

So I've got to ask, why do you need...

And here I was thinking the standard way to do an Upsert in SQL 2005 was like this:

IF EXISTS

(

SELECT 1

FROM tblCustomer

...

Post deleted because I realized Jeff suggested the same thing (a COMPUTED PERSISTED column).

What a brilliant idea!

WITH SampleData (ID, Pay) AS

(

SELECT 1, CAST(1.000 AS NUMERIC(19,3))

UNION ALL SELECT 2,2.250

...

So I've got to ask, why do you need it in...

I see at least 2 issues here:

KGJ-Dev (1/30/2015)

Below is the sample data to play with.

declare @users table (IDUser int primary key identity(100,1),name varchar(20),CompanyId int, ClientID int);

declare @Cards table (IdCard int...

An effective method is a CROSS APPLY VALUES UNPIVOT (described in my signature links):

WITH Students (id, studname) AS

(

SELECT 1, 'x'

UNION ALL SELECT...

There are various ways to do this depending on what version of SQL you're in.

Creating a Date Range from Multiple Rows Based on a Single Date[/url]

The article shows them and...

So what results do you want to get out of that sample data?

You can ignore this part of what I said. I realize...

Try changing this:

si.TrackingNumber like '%' + @SearchText +'%'

to this:

si.TrackingNumber IS NOT NULL AND si.TrackingNumber like '%' + @SearchText +'%'

And if that helps, read this article to see why:

Improving Performance for...

Or maybe it would be best to just skip all of that insufferable reading and do it like this.

WITH SampleData (ID, Amount, Months) AS

(

SELECT 1, 143.23,...

You might want to read this article:

Financial Rounding of Allocations [/url]

The problem solved there differs slightly in that you're trying to allocate an amount across rows with different values, but...