Yes, the data is the same.

It is indeed strange. The query returns different results each time the parameters are changed. For eg, if we do select top 8 or change...

Integration is the TEST SQL Environment.

Both Production and Test contain the same data.

The same Query returns different results on Production and Test as shown in the original post.

While all data...

Okay. So how come it works when we change the field length.

Thanks

Thanks for your reply..

The table has a clustered index. Will dropping it speed up the DELETE?

No FK constraints on the table.

I tried copying the packages from source but when I try to make any changes and save at the destination I get the following error :

GUID should contain 32 characters...

The user is not aliased and It is the only SQL login

Thanks for your reply.

The user X is not mapped to dbo. I even removed dbo role from this user. I am making the connx to SQL QA using X. X...

Okay Thanks. That helps.

Thanks Remi. That makes sense.

Remi, I think your suggestions and flag system takes care of all possibilities and we will certainly look at implementing something along those lines.

But I was just curious about...

Thank you all for your useful suggestion

Currently we have only 3 possibilities, but may change in the future :

1) Full DOB (mm/dd/yyyy)

2) Only year (yyyy)

3) No DOB / NULLS

So, I am...

Thank you, But I don't think there is a way to know what is the default and what was provided. For eg, we have several people with full and valid...

Can the SQL_variant data type be used to store bothe DOB and Partial DOB in the same column ?

Thanks all for your suggestions.

Yes, we do need to store partial dates such as YOB if we have only that and not the full DOB, as we have match...

Using SQL Enterprise Manager and sorry we are on Win 2003