Try an inline table-valued function instead.

Please explain the...

GilaMonster (10/6/2016)

---

ChrisM@Work (10/6/2016)

---

We must...

Have you tried EXECUTE(querystring) AT linkedservername?

wendy elizabeth (10/6/2016)

---

I have this school years data and I am making a copy of it for the previous school year. Basically the schoolid for this current school year changed...

SQL Server will read all qualifying rows (in this case, ALL of them) then eliminate the nonqualifying rows in either a residual predicate i.e. as rows are read (common and...

http://www.sqlservercentral.com/articles/T-SQL/97545/

The left-outer-joined derived table (the bottom half of the query) isn't referenced in the outer SELECT, WHERE clause or ORDER BY. You can safely remove it.

Your conditional is faulty. Which row of dbo.emp do you want to check? You need a SELECT in there. Possibly something like

IF NOT EXISTS (SELECT 1 FROM dbo.Emp WHERE...

mw112009 (8/25/2016)

---

Thx but that is not really the challenge...

What I need is an expression that will give me the 3 letters that follow the nth occurrence of the key word...

Using a tally table, SUBSTRING(bigstring, 'fox', n) or whatever.

Work it out from there. You'll need to...

You're confusing the purpose and capabilities of SQL Server with those of Excel.

Use Excel for this.

On the bus on the way home. Now people I don't even know think I'm...

drew.allen (8/18/2016)

---

ChrisM@Work (8/18/2016)

---

-- set up some data to code against

DROP TABLE #MyTable

SELECT *

INTO #MyTable

FROM (

SELECT 123, 1 UNION ALL

SELECT 456, 2 UNION ALL

SELECT 789, 1 UNION ALL

SELECT 789, 2 UNION...

CELKO (8/17/2016)

---

I apologize for this half answer, but in some of my books I have an update statement that uses a case expression (not a case statement, please?) To move...