My initial impression was to use the master package too.

Can you clarify this statement? I'm not exactly clear on the issue you encountered.

I thought maybe I could use a...

Imagine that instead of selecting one column from each table you...

I can think of hundreds of objections to that kind of structure, some based on things that would be a poor fit (distributed authority being potentially problematic for fiduciary...

Here it is using lag and lead to find the islands:

WITH getlaglead AS (

SELECT

seq,

section,

cat,

seconds,

LAG(cat,1,'N/A') OVER (PARTITION BY SECTION ORDER BY seq) AS prevcat,

LEAD(cat,1,'N/A') OVER (PARTITION BY SECTION ORDER BY...

perhaps:

;

WITH IslandMin AS (

SELECT row_number() OVER (ORDER BY section,seq) AS rn,seq,section

FROM testdata t1

WHERE NOT EXISTS (SELECT 1 FROM testdata t2 WHERE t1.seq-1 = t2.seq AND t1.section = t2.section AND t1.cat...

Technet article on sp_rename says:

If the object to be renamed is a constraint, object_name must be in the form schema.constraint.

No table name

But thats why its so good. ...

If you've already got a time dimension it should be be too hard from there.

First, a question, do you include an hour if the start is during that hour (same...

Seems risky at a company full of tech nerds. If they see you doing data mining to figure out who is likely to leave, and scratching their itches,...

Best Sql memories of the year:

-Getting a job where I actually get to apply some of the things I've learned here

-Going to my first SQL saturday (#209)

-Seeing Cory Stephenson's SSIS...

However, despite the many people that were awarded MCMs before the termination of that program, I still find large numbers of SQL Server professionals learn the bare minimum they need...

petr.caslavka (12/30/2013)

---

This is definitely a better way of doing it. However, I am not sure about the TRUNCATE TABLE ps_micros_e7_time_clock_details statement. I don't want/need to truncate the table altogether as...

Yes, you should be able to do == .

It doesn't work without the subquery because you have nothing to give the min

It doesn't work with the subquery because you take the min exec order over cust_id regardless of...

Hi nomvula.

You need to set up an expression on your data flow task. it will let you dynamically set the SQL Command for your OLE DB source. ...