sandeep4testing (3/23/2012)

---

Hi guys,

I want to crate primary key for 2 columns in the table, as well as i need to create more that 2 columns. I'm trying to create...

We can't see from here what you see from your desk. If you knew nothing of the problem, could you help someone given the information you just gave us?

Sean Lange (3/23/2012)

---

Yummy...I likes me some chocolate mousse. 😀

It is actually...

Link is broken, try this one http://www.sqlservercentral.com/Forums/Topic1268991-391-1.aspx

Lexa (3/23/2012)

---

Chris Harshman (3/23/2012)

---

you may want to check if there's a different execution plan used when the proc is called from management studio vs. the application. One of the...

opc.three (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

opc.three (3/23/2012)

---

What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in...

opc.three (3/23/2012)

---

What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in full recovery mode....

And still don't have...

Probably a trace flag to allow SQL Server to use a network share. I know I have seen that somewhere on ssc, just can't remember where. With that,...

Can't really say if it is good or bad, just different. When we started a data warehouse project at a previous employer we set up the Staging and ODS...

And? What about the other things I asked?

Charmer,

Let me guess, this code will generate a random string of characters from 1 to 6 characters in length, correct?

Have I got something for you if that is what it...

Found a problem with your code already, as far as trying to work with it. You use a variable @MaxLength, but it is not defined anywhere in the...

Not enough information. First, what it the value of birth_dt being provided in the isnull(), is it null? Also, you have a call to another function in this...

Your procedure will delete and reinsert existing records (basically an update to the existing record). If the DELETE fails, no record currently exists, INSERT a new one.

The following code...