Sorry for the thread necro, but found it interesting today that CNN had "Database Administrator" #7 on the "Best Jobs in America" list.

link

One way to accomplish this is to do a crosstab or Pivot on write_off_code.

I just built it in to Mark's code from above

create table test_acc (

...

How many different possible write-off amounts are there? And are they fairly static?

Hi David,

The problem seems to be that you are grouping by the write off code in the #test_payments table. This forces the query to give a separate row for...

Looks like he put the question in the subtitle (I missed it the first time too)

Here it is:

I want to use the values executed by...

As I explained above, I think the problem is varchar...

Actually, THIS might be the problem

EXEC sp_executesql @cmd,N'@ClientName varchar(37),

@ClientSeq int,

@Phone char(14),

@GreatPlainsID char(10),

@ClientID char(9),

@ConglomerateID varchar(9),

@ConglomerateFlag tinyint,

@License char(14),

@State char(4),

@Attrition char(1),

@ClientType char(1),

@Active tinyint',

@ClientName=@ClientName,

@ClientSeq=@ClientSeq,

@Phone=@Phone,

@GreatPlainsID=@GreatPlainsID,

@ClientID=@ClientID,

@ConglomerateID=@ConglomerateID,

@ConglomerateFlag=@ConglomerateFlag,

@License=@License,

@State=@State,

@Attrition=@Attrition,

@ClientType=@ClientType,

@Active=@Active

You convert your phone number like to a char(14), which would...

If you run the query statically does it work? In other words, if you assume knowledge of the parameters, type out the query yourself with the like statement, and...

ulteriorm (10/1/2010)

---

@getoffmyfoot

Even after considering various scenario's i was not very confident in both the queries performing the same tasks( Or maybe they are). I was replacing the logic in...

Never understood the christmas eve gift opening.

1) Its not christmas yet

2) 'Santa' hasn't come yet

3) Give me something to play with christmas eve and good luck getting me to bed.

4)...

Well, I've never tried it myself, so I'd probably refer to this article[/url] some guy wrote.:Whistling:

Or I'd do the running total in whatever my frontend was.

That's correct.

On the other hand, you can define multiple CTE's for use with one query.

They threw me off at first, too.

This might help clarify[/url]

A CTE is more like a temporary view or a derived table than a temp table or table variable.

They are used for very different things. Temp tables are temporary...

First and foremost, someone is going to point out to you that you probably dont need a cursor here, so it may as well be me.

Second, its tough to tell...