SQL_NuB (7/23/2013)

---

I literrally just took over a project from a contract that when he left he changed the sa password and the auth process for the SQL server. No one...

The only change I still would made is change the data type of the first column from datetime to date.

Pragmatic Works has quite a good reputation.

GilaMonster (7/23/2013)

---

Koen Verbeeck (7/23/2013)

---

An possible alternative could be (keep in mind that I'm not a restore expert) is to put the tables you do not want to restore on a...

ChrisM@Work (7/23/2013)

---

Why? It will be inelegant and unwieldy, and confusing for whoever...

An possible alternative could be (keep in mind that I'm not a restore expert) is to put the tables you do not want to restore on a different filegroup. Then...

You can add a condition to the WHERE clause that checks if start_execution_date is today or not.

sahoong (7/23/2013)

---

We use SQL Server authentication and I checked saved password in the configuration manager but yet, the package run successfully in bids then but not in SQL Server. Are...

How is this not...

What if you look at the actual execution plans? Any differences?

That's not enough. You can't just tell the PDF that it is now an image. You can't tell an apple that it is now an orange and expect to behave...

The first one installs SQL Server 2005, the other one installs SQL Server 2008. 😉

Google is your friend. Try it out!

For example: Difference between sql server 2005 and 2008

How about something like this:

IF EXISTS (select 1 from Table B)

BEGIN

query with join to table B

END

ELSE

BEGIN

query with join to table C

END

sushilkumar217 (7/23/2013)

---

Thanks for the replies.

I want to run this query as a report(rdl) and make available to other team member as well.:-) so that my seniors should not come to...

What went wrong? Did you...