Sergiy (11/20/2015)

---

That is just absurd. There is no standard that says...

I assume you are responding to the person who injected their question into the middle of this thread. That person...

You are welcome. I don't know if it will work for you but it seems a lot simpler than trying to keep...

ricardo_chicas (11/20/2015)

---

Thanks

I know that I can use parameter sniffing in here, but the overall problem if that for sure we have hundreds, if not thousands of queries that are doing...

Charlottecb (11/19/2015)

---

That's a good idea Sean, I hadn't though of that. I will investigate it.

What is the best way to find the ID of date record I need if I...

Sergiy (11/20/2015)

---

Sean Lange (11/19/2015)

I would hope that for lookup tables like states and currencies you don't use a guid as the primary key. The ANSI abbreviation is an excellent choice...

Or you could simplify this a bit and drop the end date from your data. The EndDate could just effectively be any value that is before the next start date....

souLTower (11/19/2015)

---

... but I didn't know who else to turn to. 🙂

We have a web application that recently started throwing "Connection Timeout... connection pool" errors daily. The traffic...

Jacob Wilkins (11/19/2015)

---

jasona.work (11/19/2015)

---

Luis Cazares (11/19/2015)

---

jasona.work (11/19/2015)

---

I was going to post this over in Steve's call for Good Basic T-SQL Exercises but decided not to pollute the topic with fluff...

So...

Jeff Moden (11/16/2015)

---

hoseam (11/13/2015)

---

Hi

I want to return two character from a column. But now the column itself returns 0 -9, then double digits. before I concatenated "0", then the problem...

j-1064772 (11/19/2015)

---

I was more thinking of the "main" tables like Customer, Contact, Invoice. No duplication issues there.

And yes, I agree that there is still work to be done for "reference"...

RonKyle (11/19/2015)

---

Is there no need or use for a table with the two fields as the primary key? On the face of it, it's more than an odd situation....

Nicegirl13 (11/19/2015)

---

Hello everyone.

I am in a situation where i could use some help. I am creating a view that has to left join 3-4 tabels: a little screenshot to get...

Jack Corbett (11/18/2015)

---

Phil Parkin (11/18/2015)

---

Jack Corbett (11/18/2015)

---

Remember, it is not about winning or losing because everyone is a winner if they try their best :rolleyes:. ...

Ed Wagner (11/18/2015)

---

Lynn Pettis (11/18/2015)

---

rodjkidd (11/18/2015)

---

Lynn Pettis (11/18/2015)

---

robert.sterbal 56890 (11/18/2015)

---

Luis Cazares (11/18/2015)

---

Why should we consider using hashtags? Is there any benefit on that? The forum software won't recognize them, I'm...