LEAD and LAG were introduced with SQL2012. You won't be able to use them if you are...

I would expect your fact_Sales table to have a sale date and you would use that to determine the exchange rate on the date of the sale.

Drew

Eirikur Eiriksson (4/11/2016)

---

GSquared (4/11/2016)

---

I just ran into this in a query. Can anyone come up with a good explanation for why anyone would do this?

SELECT

...

You student_quiz_session_data table represents a many-to-many relation between your students and your quiz_data and is a subset of all possible pairings of your students and your quiz_data. It is...

This is a presentation issue and is best left to the presentation layer, SSRS for example.

Drew

The replacement depends on the collation, and the default collation is case insensitive. Using the CHAR() function, does not change the...

Eirikur Eiriksson (4/4/2016)

---

drew.allen (4/4/2016)

---

No, the...

No, the OP is asking...

Eirikur Eiriksson (4/4/2016)

---

Brandie Tarvin (4/4/2016)

---

At 11:55 p.m., my boss asked me if there was anything else he could do. At that point it was a one person job which I...

Eirikur Eiriksson (4/4/2016)

---

Here is a quick suggestion towards a solution, let us know if you need more assistance.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @XQUERY_STR NVARCHAR(MAX) = N'';

DECLARE @PARAM_STR NVARCHAR(MAX) = N'@TXML1...

Codd suggested that there should be two different values for missing data: A-Values and I-Values representing missing and applicable and missing and inapplicable respectively, but SQL only represents a single...

Sergiy (3/31/2016)

---

drew.allen (3/31/2016)

---

Hard-coding the translation table is not necessarily a bad idea if the translation table is relatively small and the table rarely, if ever, changes. You need to...

Sergiy (3/31/2016)

---

drew.allen (3/31/2016)

---

I specifically said Inline Table-Valued Function, precisely because they are inlined. Scalar functions are never inlined, which is why it can make sense to create an inline...

Sergiy (3/31/2016)

---

drew.allen (3/31/2016)

---

It's actually MUCH faster to create a table using the VALUES expression, because most of the cost is writing and reading the temp table to tempdb. If...

Sergiy (3/31/2016)

---

drew.allen (3/31/2016)

---

It's actually MUCH faster to create a table using the VALUES expression, because most of the cost is writing and reading the temp table to tempdb. If...