John Mitchell-245523 (11/17/2016)

---

1. No, it's not a correlated subquery, so it only needs to run once.

2. Same as 1.

3. This is a correlated subquery. I'm not sure what your...

I agree with most of what Jeff said, but I would TRUNCATE the tables rather than scripting, dropping, and recreating them.

Drew

I agree with the others that...

These types of functions are best left to the presentation layer.

Drew

sqlfriends (11/15/2016)

---

I would like to find out in every past 30 days(a month) the students has 2 days absent, or 3 days absent.

These are any sliding 30 days not...

I realize that this question...

None of the...

Isn't this essentially the same question that you had in Recursive CTE performance improvement. You received an answer to this question there.

Drew

The most obvious explanation is that the NULL value is coming from some other part of the UNION. Does the first column value match the value in this part...

Reported as s-p-a-m.

There are three main ways.

1) The key is included in the source data.

2) Use the OUTPUT clause when you INSERT/MERGE the data into the user record to get the ID...

BowlOfCereal (11/8/2016)

---

drew.allen (11/7/2016)

---

Since you want the final result as a numeric value, it doesn't make sense to manipulate the string. Try the following:

SELECT m.origval, n.comp_val

FROM #mytab m

CROSS APPLY (

SELECT...

The files are processed in alphabetical order. If you follow the naming convention of having a fixed filename prefix with a timestamp suffix in YYYYMMDDHHMMSS order they will be...

Just tell them it means Read the FABULOUS Manual. 😀

Drew

Since you want the final result as a numeric value, it doesn't make sense to manipulate the string. Try the following:

SELECT m.origval, n.comp_val

FROM #mytab m

CROSS APPLY (

SELECT TOP (1)...