Well - I was assuming you were giving us a reasonably complete picture of the formats you were going to have. The point was - the CAST predicate is VERY...

sg - why don't you just print the @sql variable so you can see where the syntax error is?

PRINT @sql

would do the trick....If you don't see it - post...

Actually - if you only have to trim ONE of the tables, then make the non-trimmed on the base table. It will give you a shot at maybe using...

Don't confuse display with storage. In SQL 2005 and below - every datetime field has a data and a time component. You've already zeroed out the time component...

don't bother - CAST will convert all of them correctly.

select cast(dte as datetime)

from

(select '1/2/90' as dte UNION ALL

select '11/1/91' as dte UNION ALL

select '1/02/05' as dte UNION ALL

select '1/02/95' as...

The subquery that select a column from the outer table is cumbersome and confusing in terms of semantics. It always has more concise and clear way for this type of...

Are you sure you're in the correct database? Perhaps you got lucky and your predecessor actually DID store this thing in Master (where the sp_ stuff should live).

Have you...

The error is trying to tell you that the column you are trying to make into a primary key has duplicate values in it (each row must has a unique...

Frances L (1/14/2008)

---

Matt:

select count(*) from...

Just remember - there are OODLES of data on HL-7 floating around. You're going to need some "focus" above and beyond "go study HL7". Last time I checked...

If they can't give you a width - then perhaps work on the "split into integers": meaning one field with the VarChar version, and four more to capture the octets.

Take...

Now - keeping in mind that you might not want to SEE the the padded version, you might be able to create a calculated field that "pads" your number sequence...

The only way you will ever get that to order correctly is to either split the numbers into separate columns, or pick a width for each of the numeric sections...

It still doesn't get around issues with the data like Jeremy was getting at.

Is there a guarantee that issues are addressed in the order they occurred in?...

There is something fubar there, that's for sure.

When you run the sub-report by itself what does it do? Does it prompt for a parameter and show you the total...