OK. I don't fully understand what your data looks like.

Please provide the following:

1) The results of running

select MemberNumber, EndDate, UpdateDate

from dbo.DimMember

where MemberNumber = 1041

before any update and then

2) Please show...

sqlmaverick (10/5/2015)

---

Actually , for historical record I have to update End date as Updated Date where end date is Default date '2099-12-31'and for new record with same id ,...

Eric M Russell (10/5/2015)

---

Perhaps we could have a spam reporting policy that works something like this:

If a trusted user (meaning perhaps a user with a certain level of points...

Lowell (10/5/2015)

---

agreed. they added code that insta-deletes anything Celko posts(thank you for that!), so they can reuse that same code, and just add something that detects the new user spamming...

There are other potential benefits. Here are some that spring to mind:

1) Having a local copy of all database files means that you can search your database without hitting the...

erb2000 (10/4/2015)

---

Our application has serious problems after upgrading to Sql Server 2014. We tracked it down to the huge IN clauses running very slowly. It's not easy to...

What do you mean by 'start a new database', please?

Which client are you using? SSDT?

Please state your question. Put a question mark at the end. Because I have no idea what your problem is.

I cannot see a question there.

solus (9/30/2015)

---

ok, there are some setup scripts as part of the project which I cant change since there are several developers working on this and they all expect the same...

SQL006 (9/30/2015)

---

Hi SSIS Experts

How to use table variable in SSIS 2012, is it possible to use table variable in SSIS.

I want to insert some results from EXECUTE SQL TASK to...

Brandie Tarvin (9/30/2015)

---

Grrr. The way he phrased his thank you. Yes, I piled on. But believe me, what I posted was far more polite...

sqlinterset (9/29/2015)

---

Currently i am using SQL Server 2012 Import/Export Wizard to upload data to sql tables manually. However i was trying to write a procedure to update that table. and...

D1rtyD0g (9/29/2015)

---

We do not have to get any data to & from this server. It's an isolated environment. It's an ETL package which will transport data from a transaction to...

D1rtyD0g (9/29/2015)

---

Hi,

I need to deploy a SSIS project to a remote server to which I have very limited access. Don't have remote access to this SQL server. In fact, the...