This is something that came to my mind. It won't work if you have two continuous Ins or Outs.

WITH rowCTE AS(

SELECT *,

ROW_NUMBER() OVER(PARTITION BY Name, Reader ORDER BY [TimeStamp])rn...

Maybe you're trying to compare two chapters of a book :hehe:

I just tried to include all possibilities.

And now it's...

It depends 😀

If your varchar columns' length could be over 4000, then cast as varchar.

If not, I would consider casting them as nvarchar (this would be the implicit conversion).

I would...

Chris M already gave a solution, but with no DDL and sample data, I'm not giving an example.

What's wrong with using CAST?

SELECT 'CAT', CAST( 'CAT' AS varbinary)

You could run your package and use a loop in it to check for the existance of the files.

You need the following namespace

Imports System.IO

Public Sub Main()

...

What's your source?

If it's a table, you could do a select (SQL Task), if it's a file you could check for the file size (Script task).

This is very simple, but you need to help us. Please post table definitions, sample data and expected results. For information on how to do it, read the article on...

That explains everything 😀

Foreign keys are tools to mantain and ensure data integrity. Not evil but all the other way...

Why do you have LOOP hints in your JOINS?

A better option is to normalize the data 🙂

I'm not sure what can you do better. An EAV design won't be great...

I'm not sure what you need. I couldn't understand. It would help a lot if you posted table definitions (DDL statements), sample data (Insert statements) and expected output based on...

Sean Lange (2/24/2014)

---

patrickmcginnis59 10839 (2/24/2014)

---

Sean Lange (2/24/2014)

---

patrickmcginnis59 10839 (2/24/2014)

---

GilaMonster (2/23/2014)

---

Jim Arko (2/23/2014)

---

When using dynamic T-SQL you need to concatenate the variables.

SET @sqlstring = 'UPDATE table SET column = ' +...

I updated my post to include some comments on it. I hope it's easier to understand that way. Try running it one part at a time to understand what it's...

I can't see the code for that SP, I have no idea on what you could improve.