i still get the same error saying "The Declare cursot SQL construct or statement is nto supported"

but if goves me the optiopn to continue... so if i click continue it...

rbarryyoung (8/18/2008)

---

This should work:

Declare @sql varchar(max)

Set @sql = 'Update T

Set '

Select @sql = @sql

+ CASE When ORDINAL_POSITION = 1 Then ' ' Else ', ' End

+ '['+COLUMN_NAME+'] =...

no not EVERY field is a string - but everyfield that is a string got this weirdness appended to the end of it.

anyone?? any idea how to write somethgin to strip that code out of all the fields in a particular table?

ah ha! that makes sense - never had to do a comment in sql - now i know (and knowing is half the battle - Gi Joooooooe)

it does seem...

looks like this could work but i am confused by the following line of the query:

--AND MAX(Price) >= 0

what is with the two minuses. if i leave them in,...

unfortunately no. ...

i am looking to find the top 10 highest individual charges (individual records)...

no, trust me, its not homework - i wish it was. it is for my job - a healthcare facility that uses another area hospital's pharmacy services and we...

ok now tha ti am looking at this i was wondering if you could just clarify something.

so it looks like what you were gettign at with the proposed query is...

ooh that is slick - lemme give it a try!

so it turns out that  my database is a mysql 4 database but the principles behind the query should be the same.  i tried the query suggested by Grasshopper and...

i think the problem may be that i am using mySQL 4.0 and i need to be on at least 4.1 for this to work. so now i have...

well i appreciate your efforts thus far.  as you said, hopefully someone else can chime in on this one.  one last question - do you knwo of a good mySQL...

i know this is a SQL server forum but for this particular project i happen to be using mySQL - that prob has something to do with it.

i was hoping...