Be very careful about using the money datatype. Given your variable names it sounds like you might be doing some calculations? The money datatype is NOT accurate when doing calculations....

Here is how you could do the static one.

select CID,

MAX(case when Rank = 1 then ID end) as ID1,

MAX(case when Rank = 1 then Amount end) as Amount1,

MAX(case when...

You need a crosstab for this. If you know the max number of columns you can use a static crosstab. If you don't know ahead of time how many there...

zoom19 (6/7/2013)

---

Yes You are right because primary key created on TableName and Columnname Column......

and I am inserting same tablename and columnanme into table .But I have to ,this the...

Once I add the primary keys, the insert statements you posted have lots of duplicate key errors.

Good job posting ddl and lots of details. However you ddl does not contain any primary keys. Can you post the primary keys?

Also, fwiw you do not need a...

Rog Saber (6/7/2013)

---

I need to add time to a value. The value is stored as char(4) - example '0630'.

I know to use the dateadd function but how do I format...

It is not really possible to map out RI as a hierarchical model as you are discuss. This is because there is nothing that prevents circular references and that sort...

Hi and welcome to the forums. It is very unclear what you are trying to do here.

In order to help we will need a few things:

1. Sample DDL in...

DBayliss (6/7/2013)

---

Hi ,

What would be the best way to dynamically self join a table to create the example contained with the excel spreadsheet?

The number of rules can vary depending on...

Nobody is consistently that lucky, that indicates a fair amount of skill laying under all...

How about create table statements and insert statements? If you really need some help you have to put in some of the effort. After all you are getting 100% of...

ChrisM@Work (6/7/2013)

---

Sean Lange (6/6/2013)

---

... In lieu of using a permanent table I use a view that creates the tally table on the fly. 0 reads to access it and I...

Wow that is super slick Jeff. Don't why none of the rest of us thought about that.

Thanks for sharing Lowell. This is a great script.