chris 81958 (11/17/2011)

---

I am new here and am VERY new to any type of programming.

My database has a timepoint that incorporates data and time; e.g., 2010-12-01 17:00:00. I would...

bubs (11/17/2011)

---

What I need it to return is:

Name | FilteredHours | NonFiltered

Steve | 20 ...

AGH, my eyes! ... and formatting is eaten.

Can you edit your posts and wrap your code with the 'ifCode' shortcuts you see on the left? The one you...

My guess would be heuristics and the tipping point.

Is 'my_column' in the actual clustered index? If not, try using it as an include in the index definition. You'll...

This is in a transformation script component?

You need to include the equivalent to this VB in your Catch.

dts.TaskResult = dts.Results.Failure

That should cause a hard stop on the row that's caught,...

Review the spid doing the initial call after reboot, and review its wait stats. Find out WHY that first one is taking so long, you'll have a better idea.

My...

As mentioned, the cause of this is duplicate key data in multiple tables.

from

d_m m

left join

[ref].[dbo].[D_HDS] rg on

rg.HDCode = m.G_DID

left join

[ref].[dbo].[D_HDS] ri on

ri.HDCode = m.I_DID

left join l_Qcat c...

Is it safe to assume that this:

RIGHT JOIN dim_date

...

Brandie Tarvin (11/17/2011)

---

Jeff,

I'm not sure of the intention of ragged right, but I know for a fact in SSIS 2005 it was just about the only version of Flat File...

Brian Ki (11/16/2011)

---

I have had to pass this off to someone else who is finishing it, but they have tested your code and tell me it appears to work well...

Yeah, just hoping the OP comes back to...

Ninja's_RGR'us (11/15/2011)

---

I just can't tell you what's happening without seeing both actual plans.

Ever tried to get your car fixed without taking it to a mechanic? Pretty much same thing...

This is horribly painful to do via SQL. This is best off done in the front end.

The short form: You need to pivot, do a running total, and...

Contract to Hire is pretty much the new version of the wait for 3 months before any of your benefits thing. The word is escaping me at the moment....

Comments are in the code.

DataBuild:

IF OBJECT_ID('tempdb..#tester') IS NOT NULL

DROP TABLE #tester

CREATE TABLE #tester

( TimeOfEntry...