I considered this approach, but...

I expect that to stop working at some future...

Here is a solution that will handle any length of extension. I added a *.ssmsproj entry to test a longer extension.

SELECT *, LEFT(RIGHT(td.breach_content, r.filename_index-1), r.filename_index - r.extension_index - 1), RIGHT(td.breach_content,...

Converting dates/times to character and back is horribly inefficient, but if your table is small enough, it may still be fast enough to not significantly affect performance. Another option...

I think this is what you are looking for.

SELECT

p.country_code,

p.local_client_code,

wwc.local_client_name,

sum(case when pr.fiscal_year = 2015 then pr.local_consulting_fees*er.rate + pr.local_product_fees * er.rate + pr.local_admin_fees * er.rate + pr.local_misc_fees * er.rate else 0...

Another reason is that you might be storing information from an OUTPUT clause to use later, especially if you want to use information from both the INSERTED and DELETED temporary...

First, the correct syntax for CAST is CAST(<expression> AS <datatype>).

Second, saying it didn't work doesn't give us much information to go on. Exactly how didn't it work? Did...

As far as SQL is concerned, ON clauses and WHERE clauses are equivalent...

Did you check out my post? My results are exactly like yours except that I also have a row for ParentID = 0, and it's not clear why you...

It sounds like you want to use the DENSE_RANK() function.

;

WITH table_ranked AS (

SELECT iINDEX, PARENTID, DOCUMENTID, QTY, REVNR, XREFID

,DENSE_RANK() OVER(PARTITION BY PARENTID ORDER BY REVNR DESC) AS dr

FROM #TableA0

)

SELECT tr.iINDEX,...

I would add that you are mixing join conditions with criteria. When joining tables, you almost always want to use only (implicit) foreign keys, because the joins should reflect...

As far as I can tell, this yields exactly the same plan, but I find it simpler to follow.

SELECT CompanyName, Year, Month, Cost

,AVG(Cost) OVER(PARTITION BY CompanyName) AS AverageCost

,SUM(Cost) OVER(PARTITION BY...

The vast majority of the time, people...

The short answer is NO!

The long answer is that the easiest way to get the appropriate structure in your XML documents using T-SQL is by using nested queries. Using this...

laudena (7/14/2015)

---

What about something like this?

SELECT month(DateField) as DteFld_Month, DAY(DateField) AS DteFld_Day, { fn HOUR(DateField) } AS DteFld_Hour, COUNT(MeasMyID) AS DupCount

FROM ...