Either you write the 10 queries or you use Dynamic SQL. You could use a procedure called sp_MSforeachdb (which is undocumented) or Aaron Bertrand's version http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

What limitations are you concerned...

CAST is not needed. At least for what you posted.

SELECT *,

'the freight cost is ' + REPLACE(cost, '.', ' dollars and ') + ' cents'

FROM (VALUES(65.83))...

Why? :unsure:

Something like this could help.

SELECT

ISNULL( t.Amount, 0) Amount,

t1.TranDate

FROM #Test1 t1

LEFT JOIN

(

SELECT SUM(Amount) AS Amount,

CASE WHEN DATENAME(DW,...

Something like this?

SELECT omlSalesOrderID

FROM m1_dc.dbo.SalesOrderLines

WHERE omlPartID='finalmile'

UNION

SELECT ompSalesOrderID

FROM m1_dc.dbo.SalesOrders

WHERE ompShippingMethodID='JBFM'

Do you understand the solution that Eirikur provided? There's at least one question that I'd ask.

I'm not sure if this more simple option would fit you.

What happens if a row falls into the following 24 hours but it's on a different date? This option...

WayneS (4/10/2015)

---

Luis Cazares (4/10/2015)

---

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if you're in situation...

Alan.B (4/10/2015)

---

Ok, quick update... I did some research on this - it appears that sys.partitions does not guarantee an accurate row count. According to Microsoft, the rows column in sys.partitions...

Not exactly. They're more like :old and :new

As it has been noticed, on a trigger you should use inserted and deleted virtual tables.

I'd use a different approach to be sure that the value on the column changed.

CREATE...

SQLRNNR (4/10/2015)

---

Luis Cazares (4/10/2015)

---

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if you're in situation...

Basically, you need a cross tabs solution with an additional row_number to define the order of your columns.

Here's an article on cross tabs: http://www.sqlservercentral.com/articles/T-SQL/63681/

And here's an example:

WITH SampleData (PERSON, ACCOUNT,...

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if you're in situation where, if you...

Grant Fritchey (4/10/2015)

---

Brandie Tarvin (4/10/2015)

---

Not that I've ever been that high, but...