First off, why is this an SSIS job? Seems to me like a simple SP run by SQL Server agent could locate employees based on their hire date, then...

My crystal ball tells me:

1. You're calling this function in a loop.

2. In that loop, you're creating each of the target column values in a separate @ local variable

3. At...

Homework problem or not, that's one quirky update:

DECLARE @seq TABLE (

pkid int not null primary key,

seqId int null,

amount decimal (10,2) not null,

dt datetime not null)

DECLARE @MaxSeqID INT, @total INT

INSERT INTO...

Polkadot - Hello again!

This is a minor adaptation of a solution I posted in another thread just a couple of days ago:

http://www.sqlservercentral.com/Forums/Topic1288432-392-1.aspx#bm1288618

Try this:

DECLARE @t TABLE (words VARCHAR(max))

INSERT INTO @t

SELECT...

Cadavre,

Funny you should mention performance of SUM() OVER. I just happen to use this for the first time today (where's the blushing smiley when you need him?) and got...

I think you've gotten the idea.

Don't wait for us to desk check it. Run the SELECT (maybe with a TOP 100 or something) and look at the output results....

Jared + John,

I can see where you're headed and I'm almost there. The idea of doing away entirely with derived columns in SQL is revolutionary, not to mention imaginitive!...

Not being one to leave anything to chance, especially when I don't understand, I created a test harness on original input data expanding it to 7000 rows. Try it...

Ah wait! The culprit was the sort caused by using the PARTITION, which I missed on initial scrutiny of the query plan. Apparently it is much less efficient...

ColdCoffee - When first I looked at your query, my instincts told me there has to be an easier way.

So I came up with this:

DECLARE @sampledata TABLE (OrderNumber INT,OrderDetail INT,ItemCategory...

Like I said, self joins aren't particularly efficient. This solution produces a lower query plan cost so is likely to run faster than the self join or the first...

This solution is a little more general in that it can remove any first word if it repeats within the string, instead of the one word (@word) set up in...

I wouldn't say calculating the 'of x' part of the ranking is messy at all. Notice how I removed the rank column from your sample table. You can...

I am in 100% agreement with Sean that a CURSOR is not required in this case and add that I'm 100% certain that converting to a single SQL INSERT will...

Can't mess with your original query without lots of DDL, but I can show you how to take it from where you are now to where you want to be...