Lamprey13 (7/29/2010)

---

The default should be ON, but that can be changed at the database level.

From BOL:

Specifies ISO compliant behavior of the Equals (=) and Not Equal To (<>) comparison operators...

Sorry if I am being dense. I read the article on Forum Etiquette and I don't see why my post was incorrect? Any...

P Jones (6/15/2010)

---

Make your dataset return the required order data in each detail line (if there isn't too much) by using a table join in the select query between the...

Sridevi-836539 (6/15/2010)

---

Up to my knowledge, stored procedure has to return single dataset for SSRS Reports generation. If the SP returns more than one dataset, the Report will take the first...

Sridevi-836539 (6/14/2010)

---

Hi,

1) You should create multiple stored procedures since each SP can be used as a dataset. Then you can add the datasets in Data Tab -> Dataset dropdown ->...

John Mitchell-245523 (6/8/2010)

---

Pooja

Thanks for the explanation. Bear in mind that we're not paid to answer these questions and most of us also have day jobs, so it isn't always...

Steve Jones - Editor (6/8/2010)

---

think widely. I have had cases where we do store data in a table that is relevent to that entity, but is rarely queried. Keeping it...

Stefan Krzywicki (6/8/2010)

---

meichner (6/7/2010)[hr

Before I go about changing anything I just want to re state something so I can be sure of my design going forward. We are saying...

PaulB-TheOneAndOnly (6/7/2010)

---

meichner (6/7/2010)We are saying that its is better to combine these 1:1 relationships into one table even though in the vast majority of rows, these extra fields will be...

Thanks Jeff. I am not sure where to draw the line between creating one or...

PaulB-TheOneAndOnly (6/5/2010)

---

meichner (6/5/2010)

---

I had been told that all tables should use an identity key. I feel that when someone tells you that you should always do something, that they are...

PaulB-TheOneAndOnly (6/4/2010)

---

meichner (6/3/2010)

---

I was wondering whether or not I should use an identity column or not in the following senerio:

I have two tables, Sales Order and SalesOrderDisposition. The Sales...

Steve Jones - Editor (6/3/2010)

---

I have done separation like this, vertical partitioning for some data. I don't see an issue with it, and like Jeffrey, I wouldn't add an identity...

I wanted to say thanks for posting those links. They were very intersting.

John Rowan (5/18/2010)

---

We had some folks that were pushing pretty hard for this type of design at a company that I used to work for. I had the final...