Geoff you have been here quite long enuf to know how to post the questions ! Please follow the etiquettes mentioned in this article and provide us data in consumable...

Divide by 100.00 ??

Lynn Pettis (3/21/2012)

---

We only think we know the position. Just because the sample data has the hyphens in the same position in each record. This is something that...

Lynn, as we know the exact positions of the hyphen, i dont really think we would need Delimited...

Explicitly, before loading the data into the the destination column, u can use CAST/CONVERT to convert them.

But, AFAIK, SQL Server will implicitly convert the source columns to NVARCHAR(20) before inserting..

Very similar to yours!

SELECT LEFT ( CrsApp.CtStr , CHARINDEX('-',CrsApp.CtStr) -1 )

FROM #Test T1

CROSS APPLY (SELECT STUFF ( T1.TestColumn , 1 , CHARINDEX('-',T1.TestColumn),'') ) CrsApp (CtStr)

where do you want to convert?

Similar to yours, but with one CHARINDEX and all LEN removed

CRAP CODE 😀

Another question to you, the start and end of the report times (the 2 vairables u have declared), what will the range be? is it a day or a week...

Im still working on.. in the meantime, im in the process of learning C#.. it would be great if...

CELKO (3/20/2012)

---

This guy is trying to get us to do his job interview. Let's hunt him down and keep him from hurting his employer by letting them know what a...

LOVE the way you put down the requirement... As Barney Stinson(from How I Met Your Mother serial) says, Legennnnn.... wait for it... daryy..

Sure others might have also started working...

How about this?

; WITH Tens (N) AS

(

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL

SELECT 1 UNION ALL SELECT 1 UNION ALL...

i cant see the contents of ##mytable2 as you are joining table1 and table2 which i dont have.. i need to see your data (mock-up data, of course) to work...

now out of the result set, how do u want to order it?

can u show your desired output?