TecheeGirl (7/6/2011)

---

That's what I was afraid of. And, not knowing that, I have already migrated the packages and made 3 days work of coding changes. I supposed there...

Triality (7/6/2011)

---

Its a data warehouse environment and I want to lay the Client name into the Client field of the table using the crosswalk.

I want to match the table1.Carrier...

ashkan siroos (7/5/2011)

---

My manager wants to change all datetime fields to nvarchar because it is easier to code string against datetime... I told him it is not good because of...

You know, it IS kind of wierd. Indexing is so central to optimal database performance yet you're right, Gail... there's nothing published as an end to end discussion of...

I have learned a very simple lesson along the way...

... anytime I dread going to a specific job (not work in general, that's an unavoidable annoyance) consistently, I look to...

There's a way using Cross Apply by taking...

Jeff Moden (7/5/2011)

---

SwayneBell (7/4/2011)

---

Jeff Moden (7/2/2011)

---

Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected...

That'd be me. I pulled a brainfart and thought from your response she was commenting on your stuff, not answering the question long...

Quick and dirty? Use a NULLIF function around each column...

Narm?

http://msdn.microsoft.com/en-us/library/aa260621(v=SQL.80).aspx

The counter used by an identity for new rows is reset to the seed for the column.

And,...

GilaMonster (7/5/2011)

---

And half the QotD discussions...

In 99% of cases, an Access query becomes a SQL Server view when upgraded. I can't remember if the exception still exists, been a long while.

sqlquest2575 (7/5/2011)

---

I changed the...

What Todd recommended is about the best I could offer blindly as well. If you'd like more particular help, we're going to need some sample DDL/data to understand the...

Tom Van Harpen (7/5/2011)

---

Well here is my option 4:

Unless you have a 3rd party job scheduler, I suggest you install the SQL Engine as well on your SSIS server and...

Intel, one of my contracts along the way, apparently had an amazing sabbatical program for their researchers and technicians. You couldn't get it until you'd been there a long...