This should do the trick.

WITH cteMP AS(

SELECT MachineFk,

IsValid,

PartType,

...

Note that this is a 3 years old thread.

The information might be useful if someone arrives here with the same problem.

UPDATES will always generate locks (and any other DDL and DML statement). You might have been concerned about blocking instead of locking.

I'm not an expert on this subject, but I...

dwain.c (1/6/2015)

---

I'm going to miss...

Polymorphist (1/6/2015)

---

Oh my god, could SSIS be any more of a PITA? Amazing anyone even uses this POS tool.

I need quotes in my expression. Everything i'm reading out...

You need to create validations for your data.

CREATE TABLE cDatesTest(

Record_Created varchar(30));

INSERT cDatesTest VALUES

('21 Dec 2014 00:16:15'),

('25 Oct 2014 00:16:18'),

('30 Dec 2014 00:16:53'),

('90000'),

('23 Oct 2013 00:16:27')

SELECT Datediff(dd,Clean.Record_Created,getdate())...

If you want to prevent that people read certain rows from a table, you can remove access from that table, create a view with the correct filters and give permissions...

And the answers for the first 2 questions?

What's the problem? Could you post sample data? Could you change the column to be a date/time data type?

Phil Parkin (1/3/2015)

---

Eirikur Eiriksson (1/3/2015)

---

Be careful with the implicit conversion as the results will be depending on the system settings, no guarantee that it...

Yes and no.

Memory for transformations comes from the SSIS server, but you'll use some resources from the other servers to read and write. If you have complex queries, that would...

v4vaas 19815 (1/5/2015)

---

Hi, I need some help in refreshing process some of the tables in a database from a sql server (running 2008) to another database in a destination sql...

I'm not sure which data type you're using. Here's an example with 3 possible types.

Please, store your dates as dates and avoid using strings or numbers to store dates.

DECLARE @date...

No, you can't use two result sets from a single procedure to insert data into a table.

Thanks to all of you.

I just re-read all of the posts and Jack's comment puzzles me. I'll try to find out and if I do, I'll come back.

This table is...