Worked perfect, just had to adjust the -4. Thanks Kraig!

Can you explain to me how this is working? I assume the 3 is where it will start in the...

The problem I am trying to code out, is that the length of the string will grow over time. However, as it grows I want strip off the first two...

Wow! I was that close huh. Thanks for the help.

Can you help me with the syntax?

I got it! Had a parentheses in the wrong spot. Thank you for all your help. It is greatly appreciated!

Ok, here is what I have:

SELECT p.ID

,p.NAME

,SUM(AQTY+BQTY)/COUNT (P.LINES) AS AVERAGE_QTY

,USED.USED

,(SUM(AQTY+BQTY)/COUNT (P.LINES)) * USED.USED AS TOTAL

FROM PART p

LEFT JOIN (--USED----------

SELECT ph.ID

,ph.NAME

...

I was looking at a stock table with the columns Part Number and Part Description. I just found out that we have over 95 tables that contain these two columns,...

Not yet, but I am working on it. It didn't like the P.USED.

It has a few unions and a group by. It was close to quiting time, so I got lazy in my example. 🙂

I do not think I can accomplish this without having both columns. I will just persist my computed column, set it as the primary key, and roll on.

Thanks for taking...

I want the unique id to include an "R" at the beginning of each record created:

R00001

R00002

R00003

Etc..

The following works, when creating the table, however I would like to consolidate the two...

Yes. I am trying to create column REPAIR_ID as an identity with a leading "R". My current syntax works, but I would like to do this without creating the additional...

Thanks for the replies.

That's perfect! Thanks

Thanks guys. I simply want to add the letter "R" to the indentity value.

R0001

R0002

R0003

etc...