Datetime2 handles the 'z', Datetime does not

I have been trying the derived table route, but have hit a very strange problem - I have 50 records in my table with a Type of D and a...

It still fails with the same error

Looks like a solution - I'll give it a try

Then I would have dynamic sql generating dynamic sql! I'm afraid it will disappear up it's own rear end! 😀

Easiest way is to use the mailmerge facilities within Word, connecting to your Access database

There is a known problem with Access linked to a SQL back end that can exhibit this behaviour.

If you have a bit column in the table that does not have...

I tried it the other day with a very long delimited list of several thousand items - a tally based function took about 3 seconds, the xml one took 0...

I was in a bar in Leuven in Belgium (Cafe Amadee) and they had Trappist beer on draught...

In Russia, instead of beer bread, they have Bread Beer! http://en.wikipedia.org/wiki/Kvass

Try this - it works faster for me than using a tally table - it converts the string to xml, then selects from the XML

CREATE FUNCTION [dbo].[Split]

(

@delimited nvarchar(max),

...

Lowell

I don't want too many repeats, so I'm using the full census tables.

Using the two seperate functions, it updated 2500 rows in 12 minutes - for 500,000 records I will...

Lowell - thanks for your response

With the exception of a small typo (a comma in MyRandomNamePairs,Surname instead of a period), it does appear to work, but the performance is not...

This can be fixed by changing WHERE EXISTS to WHERE NOT EXISTS

How about this? Use Acces's Split function using "ZB5|" as the delimiter, then add the "ZB5|" back to the start of each array member

Public Sub SplitLine()

Dim textline() As...