In that scenario an update would work yes, but you need to consider the data volumes involved and the impact on overhead.

In the example of Student and Classes, yes you...

hisakimatama (4/8/2014)

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the" way to do it....

Have to go with Perry on this, create a secondary file group then migrate the data, if you have a clustered index its even easier just drop and recreate the...

I have witnessed a similar issue when developing SSIS packages, where the connection retains the lock when developing packages in BIDS even though the packages are in development mode.

Which is...

You can still use part of what Ive posted, as we don't have access to your data etc its difficult to be specific.

WHERE dbo.RECORDED_SERVICE.STARTTIME Between CONVERT(DATE, DATEADD(day,-80, GetDATE()))

AND CONVERT(DATE, DATEADD(day,-79,...

change this

WHERE (dbo.RECORDED_SERVICE.STARTTIME < { fn NOW() } - 80)

to

WHERE (dbo.RECORDED_SERVICE.STARTTIME < DATEADD(day,-80, GetDATE())

Be aware this will not affect the time.

This may be what you are looking for

/*

SAMPLE DATA POPULATION

*/

CREATE TABLE #Sample

(

Id INT

)

Insert into #Sample

VALUES

(1),(12),(13),(23),(22),(22),(9)

/*

Get the ranges

*/

SELECT

(10*(Id/10))+1 AS RangeStart

,(10*(Id/10))+10 AS RangeEnd

,COUNT(*)AS Recs

FROM

#Sample

Group By

(Id/10)

This really only...

I've traweled through numerous articles, blogs and other sources, and it appears that you cannot programmatically add a Project level Connection Manager to a package, except through BI studio.

However,...

Andreas,

Thanks for the feedback, it will be interesting to see how this goes, I noticd in your blog that some of the restrictionin regards to updated data have also been...

Andreas Wolter-332291 (7/16/2013)

---

Even though SQL 2014 is by far not complete in CTP1 and more is to come, you should be ready for a new way of developing Datawarehouses -...

Thanks OPC, I tend to use the OBJECT_SCHEMA_NAME as a short cut, I might start using the OBJECT_ID going forward.

opc.three (7/8/2013)

---

Here is the script-form I use:

IF EXISTS ( SELECT *

FROM sys.objects

...

Rather than using a Pivot you could use a CROSS TAB method

SELECT

MAX(CASE ColumnId

WHEN 1 then Value

ELSE NULL

END) Col1

MAX(CASE ColumnId

WHEN 2 then Value

ELSE NULL

END) Col2

MAX(CASE ColumnId

WHEN 3 then Value

ELSE NULL

END)...

You might want to consider removing your email address from your signature to prevent spam being directed your way.

I miss read the requirement but seeing Lowells solution I saw the requirement, this works by making the results into a cross tab

CREATE TABLE [#Employee](

[EmpID] [int] NOT NULL,

...