Going to need to split the string based on a delimiter.

Take a look in my signature for the string splitter function, will just need to add that to your query...

Please can you post create table, sample data and expected outcomes?

Please see the posting code and data link in my signature for help.

**Very Crude Example**

create table #fingerprint

(

id int identity(1,1),

empid int,

scandatetime...

Jeff Moden (10/18/2015)

---

I realize this post should probably be under "Jobs" but I thought I'd give the dedicated denizens of the thread first crack at it.

Any "hybrid" DBAs that have...

Left4Dead2

All replies to this thread please

http://www.sqlservercentral.com/Forums/Topic1728702-2799-1.aspx

Please post the full query along with table definitions and sample data with an expected output.

Seems like some conversion of datatypes, but need the above to clarify.

Instance level

The splitter function doesn't exist in TempDB.

Not ideal creating the function in TempDB as after a restart of SQL the function will be missing, unless you create it in MODEL...

Use Luis's suggestion, it will work for single valued entities

samurai

Road (mmmm marshmallows)

Can you post screenshots of the maintenance plan with the settings, and also the query for your manual backup via the script button at the top of the GUI

Are you backing up to the same location for both the tests?

Toast

You will need to find the tasks which cannot be upgraded, eg ActiveX tasks etc and re-code them for 2012