@ salokbi,

You are NOT going back 7 minutes, you are going back anywhere between 7m0s and 7m59.999s

If you script initiates at 12:07:45 you will get all records from 12:00:00 -...

my mental arithmetic was always suspect - that's why i use a computer!

that is a cool way to concatenate strings, much easier than FORXML and STUFF()

be careful using datediff(), it only registers the number of 'ticks' between two dates

select DATEDIFF(YEAR,'2013-12-31','2014-01-01') -- one day

select DATEDIFF(YEAR,'2013-01-01','2014-12-31') -- almost 2 years

The first is one day, the second is...

I am sure this is easier, and it works for sub-groupings like dept (or team, or office, or region)

declare @data table (ID int, FirstName varchar(20), Surname varchar(20), phone varchar(10), Dept...

Better still, Chuck the conditions into and @Table and join it in the query; it makes future maintenance MUCH easier.

OK, SSRS is a different board.

One way would be to add a modulus column to the results set so that each line gets a 0, 1 or 2 in the...

No, not unless there are significant changes to the package; however the BUILD number autoincrements with every build in SSIS so you...

You can' do an index seek on Need because Active is not in the index.

The query optimizer has determined that the most effective plan is to do an index scan...

@Koen,

Yes, you can check the dtsx packages and their project into source control but the cool things that SCC gives you are negated by the way that BIML builds it's...

My understanding is the the Clustered index defines how the data is physically stored on the drive and changes to values in the indexed columns could force the data to...

There is no in-built functionality to dynamically remap inputs and outputs in SSIS. the validation of the meta-data is an integral part of the package validation so source and...

I would load the file into a staging table with indexing fields for filename and row#

You know that a record starts with NAME and the underscore, so find each row#...

Don't you just feel for junior team members who are dropped in it from a great height with little or no training in the relevant subject matter, have no senior...

I would create a peakhours table

Date,

Hour,

IsPeak

and then join to that to determine peak status. Populating this table is then the hardest part. You may also want to include some...