The final results will be below for table PolicyReviewLocks. PolicyNumber 10 and 14 doesn't exist so they are inserted. PolicyNumber 11 exists, so I need to be able...

anyone?

Thank you everyone! I was able to use the Rank function to modify my script to account for all of the other records where the jobcode changes occurred not...

Alan.B (8/10/2016)

---

is250sp (8/10/2016)

---

I have a table with the following records.....

emplid effdt effseqjobcode

00001068 3/27/200500241

00001068 ...

anthony.green (10/30/2015)

---

Your ReplyTo is @To, that needs to be @From

Also not a fan of sp_OA calls, they use memory outside of the SQL allocation, have you looked at converting this...

Nevermind got it to work. Found the following script for multiple attachments. All I needed was to create a table-valued function called fn_split() based on this link

Thanks Luis!

Using this example, how do I UNION it to another similar script? If not is there a way to write the output to a temp table?

DECLARE @SQL varchar(max)

SELECT @SQL...

Luis Cazares (8/22/2014)

---

Something as simple as this:

create table test

(flsa_status varchar(30),

bu_dept varchar(30),

reg_temp varchar(5),

ftpt char(2),

value int)

insert into test values ('Exempt Salaried','Corp','Reg','FT',43);

insert into test values ('Exempt Salaried','Corp','Reg','PT',10);

insert into test values ('Exempt Salaried','Corp','Temp','FT',12);

insert into...

Correct me if I am wrong but that example is doing a pivot on a single field. I am looking to pivot 3 fields.

That would work if my dataset was only those 4 records. In reality it's alot more and scripting a CASE for each one is not ideal. Also, if...

This is only my 2nd package so any help would be much appreciated. It's a very simple package consisting of a single Data Flow Task. Within the task...

anyone?

There is nothing between the source and target amd I am on 2005

I already have CONVERT( VARCHAR(10), column, 101) in my SQL command in my OLE DB Source. Also in my Flat File Connection Manager, the Properties for that column has...