Yes I could write a stored proc, but it wont answer your problem.

CREATE PROCEDURE MyProc

AS

BEGIN

SELECT * FROM [dbo].[Transaction]

END

GO

I don't know what your column types are, I don't know what your...

There are no attachments on any of your posts.

Images are no good, we need the code which is in a easily consumable format, like the code I posted earlier

Please read this link http://www.sqlservercentral.com/articles/Best+Practices/61537/

Could you then re-post the table definition, sample data and expected outcome?

OK, please give definitions of your tables, some sample data to work with and what you want the outcomes to be.

Please also give what you have got so far to...

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)