dwain.c (9/11/2013)

---

PiMané (9/4/2013)

---

ChrisM@Work (9/4/2013)

---

Or CROSS APPLY VALUES:

-- sample data

;WITH gennum (tollnum, n1, n2, n3) AS (

SELECT 800123, 1234, 1235, 1236 UNION ALL

SELECT 999123, 9876, 9875, 9874

)

-- solution

SELECT g.tollnum, d.code

FROM...

Hany Helmy (9/11/2013)

---

Raghavendra Mudugal (9/11/2013)

---

If I didn't then I would never had got the answer correct.. but I did, and this is...

Better still, using your example:

SELECT CONVERT(CHAR(2),DATEADD(m,-11,'2013-08-01'),10)

Yes, but if...

DATEPART() or MONTH(). Both return INT so you may need to CAST.

Hany Helmy (9/11/2013)

---

I am really amazed of the 16 people (as of now) who got it right! :w00t:

Hope one of them will post a reply explaining how he got the...

Dwain - possibly. The OP is using the rounded result of an earlier calculation to perform...

Sorting is a blocking operator.

Can you post the actual execution plan for the...

The code too please James - or at least enough of it to be sure that it contains the insert (AMAC.dbo.ap_AuditLog_i line=44)

Where in the linked site can I find out how...

paul.s.lach (9/10/2013)

---

Here is another variation on the math method that my testing says is a little faster:

DECLARE @Billion INT;

SET @Billion = 1000000000;

SET STATISTICS TIME ON;

SELECT @BitBucket =...

Run this to generate your scripts:

DECLARE @MySearchCriteria VARCHAR(500)

SET @MySearchCriteria = '''RO04381'',''RO04052'',''RO04210'''

SELECT 'SELECT ' + c.columnlist + ' FROM ' + t.name + ' WHERE ' + w.whereclause

FROM sys.tables t

CROSS...

Post the query.

Are you asking this because you are curious, or because you want to use the output of a stored procedure as an input for a query? There are ways...

Please explain in a little more detail what you mean, this is far too vague to answer.