Viewing 15 posts - 1 through 15 (of 140 total)
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...
September 7, 2016 at 3:33 pm
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...
August 10, 2016 at 3:33 pm
Alan.B (8/10/2016)
is250sp (8/10/2016)
emplid effdt effseqjobcode
00001068 3/27/200500241
00001068 ...
August 10, 2016 at 1:22 pm
anthony.green (10/30/2015)
Also not a fan of sp_OA calls, they use memory outside of the SQL allocation, have you looked at converting this...
October 30, 2015 at 8:38 am
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
October 15, 2015 at 9:49 am
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...
September 5, 2014 at 12:58 pm
Luis Cazares (8/22/2014)
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...
August 22, 2014 at 11:58 am
Correct me if I am wrong but that example is doing a pivot on a single field. I am looking to pivot 3 fields.
August 22, 2014 at 10:15 am
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...
August 21, 2014 at 4:37 pm
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...
July 15, 2014 at 12:24 pm
There is nothing between the source and target amd I am on 2005
July 11, 2014 at 8:57 am
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...
July 10, 2014 at 6:21 pm
Viewing 15 posts - 1 through 15 (of 140 total)