RBarryYoung (3/7/2009)

---

GilaMonster (3/7/2009)

---

Just one question. How would you determine who's...

Tomm Carr (3/6/2009)

---

Matt Miller (3/6/2009)

---

With all due respect - what we choose to value above everything else is a cultural thing. Irish does have a point that in our...

The bigger question would be - why is it so important to have it "in the middle?" The display order, or column seq# has nothing to do with how...

Tomm Carr (3/6/2009)

---

It's not a question of necessity. It just is....

A few more points (in addition to the already excellent info already out here).

- you can't issue a BACKUP LOG against a DB in simple recovery mode...

unless you're using Access 2000 or earlier - you really should be using OLEDB and not ODBC. In addition, you should probably look at your OLE DB connection string...

unless you're using Access 2000 or earlier - you really should be using OLEDB and not ODBC. In addition, you should probably look at your OLE DB connection string...

If you want to reuse them - then dump them into a temp table. Just create the temp table in the calling stored proc, fill it using the dynamic...

Essentially - no. Not in a function.

In order to do that you would need to run the statement as "dynamic SQL" which is not possible through T-SQL functions (since EXEC...

What you CAN do is use what is called a CTE (Common Table Expression), which allows you to create reusable expressions.

So - you'd have to build a CTE that holds...

sqlcentral (3/3/2009)

---

Yes, the results are returned in such an order that the first result is the one that I want to keep, any subsequent results with the same values across...

Try this as your query.

SELECT Type, mrPRIORITY, COUNT(*) AS TypeCount

FROM MASTER6

WHERE (mrPRIORITY <= '4')...

That's what I'm talking about. In the SSRS Report Parameters area - set it to be dateTime parameters. The Endate+1 is trying to be evaluated before being passed...

Have you set the parameters to be DateTime? It sounds like SSRS is treating them as something other than dates.

Appyling the FormatPercent turns that back into a varchar. Which is fine for display purposes, but as you've already discovered - no good for sorting. So - you...