If I needed to drop the notify from XML how would I achieve this?

Fantastic!  Does exactly as needed.

Thanks very much!

Great - I've adapted your statement, but using the case has solved the issue! Thanks

I worded my original query slightly wrong too! Shoudl have said single=25, deposit=35, monthly=value in...

Thanks for all your responses!

The ideal way as stated would be a using a calendar table.

For Info: Working hours are not taken into consideration, only weekends need to...

Thanks for the replies, I'll have a look into reformatting the file with .net

Roland Alexander STL (1/2/2013)

---

Well, it's not printing anything because @totalrecs is NULL when you concatentate it, and NULL concatenated with anything else yields NULL. You will need to assign @totalrecs...

Sorry- The first command...

I personally use a Bulk Insert statement:

BULK INSERT [tablename]

from '[Full File Path]'

WITH ( BATCHSIZE = 100000, FIELDTERMINATOR = ',' )

Fantastic! Works Great!

No they are all labelled telno

Sorry, I wasn't very clear.

The final table would have empty columns where there was less telephone numbers.

I want each telephone number in a sperate column on the record e.g. telno1,...

GSquared (1/19/2012)

---

I see what the original method is doing. The way it goes about achieving it isn't particularly sensible, but it does have a functional pattern to it.

Is the...

Who's Gus?