never mind the dynamic right now - what do you get when you run these two statements?

--statement #1

select p.*

from

(SELECT Title,convert(char,Quality_date,112) Quality_date,serviceType,Amount

from (select Title,Quality_date,TOT_ALL_RECS from DATA_QUALITY_OVERVIEW_TOTALS_AND_PERCENTAGES) p

--statement #2

select p2.*

from...

I understand that your VB code says 3.8...

But - just put this into Excel and you get:

5.23853E-32

You got something stinky happening in the VB code....

One last thing to consider... Since Excel is so "eager" to hijack the handler for .CSV files, often enough I simply create those as my "excel integration" solutions. That...

Jim Russell (11/20/2007)

I also...

Jeff Moden (11/21/2007)

Heh! If that's true, guess I need to give you...

you want to look up the CROSS Apply example from the "XML Best Practices for SQL Server 2005". You can do ALL of that in one shot (no variable,...

R2ro (11/21/2007)

WHERE

(A = @varA AND @varA IS NOT NULL) OR --line1

(B = @varB AND @varB IS NOT NULL) OR --line1

(C = @varC AND @varC IS NOT NULL) OR

(@varA IS...

You're doing a full transpose - so it gets a bit messier than that... Assuming you DO have SQL 2005 (since that's the forum you're on), here's an UNPIVOT/PIVOT method...

keep in mind that this tactic kills any possibility of using indexes, AND will choke unless the two operands are of the same data type. Meaning - this will...

now THAT's something I can understand (wi$ea$$ that is....)

:hehe:

Sorry to be contrary, but...

I'm assuming that's XP Pro 64, since that's the only one that technically can run the trial edition (according to system requirements).

error 40 / error 53 usually means "no one...

It would help if we knew what the ID is that relates them to each other. Is there a patientID? an encounterID? something? Also - a table name...

aureolin (11/16/2007)

More constraints equals better data quality, at the price of system usability. Less constraints equals more usability at the price of system integrity. As DBA's almost everyone will say...

I was happy that I still needed to look several of those up....But you've now taught me some new ones....ugh.

By the way - I'm thinking you meant AWHFY (and...