First would be based on the ID and SubID fields combined

Ok - after reading more I'm still stuck. This is what I was trying to emulate:

http://www.sqlservercentral.com/articles/Test+Data/61572/

Mytable:

ID (identity/key field)

PID (non unique number field)

FILE_NO (6 character field that I...

Florian Reischl (9/1/2009)

---

Sorry, I miss read your post at first time... Try this

UPDATE m SET

m.Date = t.Date

,m.Description =...

Hmm.....that link isn't helping me - it's looking like a foreign language to me. I guess I could figure out how to set a column to "1" based on...

Sorry - I should have noted there are a couple extra fields in the MYDATA table that I don't care about - so it isn't a one to one push...

The datatype is nvarchar(20) for the partnumber and nvarchar(100) for the description - so this works perfectly: SELECT PartNumber + ',' + Description EXCEPT that it has a...

sorry - I should have said I'm doing this sql statement from an external tool. Is there any way to pass something in the sql statement to do this?

It's returning: Line 3:Incorrect syntax near '('.

when I copy what you wrote.

Update: got rid of the parens around the one and it worked - thanks!!!

Almost there!!!! Thank you gsquared!

I have:

select ver AS TOPVER from mytable

where partnumber = 'P7029'

order by len(ver) desc, substring(ver, 1, 1) desc, substring(ver, 2, 1) desc

which works and puts...

nope - that doesn't work.

Let's say I have a version "BT" (and everything below ....from A to Z, AA to AZ, and BA to BT)

I need to find...

hmmm....not working. I feel so clueless.

I'm trying to call this SQL from an external source (Visual Build) and here is the message I get:

Msg 156, Level 15, State 1,...

The value I'm expecting with the cast statement should be '5636' (converting 1604 from hex to dec)

But it keeps inserting '1604' into the table. I can't get it to...