Depending on your business requirements you may instead want to apply the above logic using a time stamp column, which you would need to add.

Do you mean the folder in SSMS when you connect to Integration Services on your server, or some windows folder ?

Many joins would indicate to me proper 3rd form normalisation. You may want to transform the data using dimensional architecture to avoid these. But with proper indexing, many joins are...

Something may have changed on the network in that you may be required to use the full qualified domain name.

Example like// from : myWarehouseServer to: mywarehouseServer.domain.company.com/instance.

It doesn't hurt to...

Profiler will help you. Look at the Objects and Performance event classes.

Hi, The way I read it you are looking for not only duplicates but the original row the duplicates duplicated?

If so try this ( I adjusted your code a tad):

create...

I've had to correct views I've inherited that used select * and returned many unneeded columns. A quick and dirty way to correct them is to right click a view,...

The micro-managers I've had are not technical people and have MBA's. They are looking for a way to justify their degrees and think the walls will fall down without them....

It may not be a bad idea to have the server and other workstations check apply updates automatically to Windows and applications.

Log shipping is mainly used to have a backup server in case of hardware failure on the production server. This should already be in place on production system. If your...

I dont know this to be common place. In fact I know not to expect it. With that being said it may be possible (just to prevent this scenario...

If I understood correctly >

create table #t1 (productNo tinyint, productname varchar(10),

Des varchar(50), quantity tinyint)

Insert into #t1

select 1, 'borin', '4x-mal', 2 union all

select 1, 'borin', '5x-cal', 3 union all

select 2, 'hypoid',...

Very strange indeed.

Try..

dbcc opentran

To see if you have any open transactions that you may not even be aware of.

A more basic approach, in case you are not familiar with the CTE function ... would look something like

select market_project, max(dashboard_status_level) max_level

into #mytempTable

from mainTable

group by market_project

/* this creates a temporary...

Thanks for the reply Craig. I'll play around with that and report back.