SQLTestUser (9/11/2013)

---

I have a table as follows

ID Type XID Note

21 Note 1 This is a note

21 Note 2 This is not for 2...

What do you mean the TRY...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1493862-392-1.aspx

Think you just need to specify the sort order.

ORDER BY s2.MonthNo DESC

Sure that is pretty simple with a correlated subquery.

Btw, it would be really helpful if you would post ddl and sample data.

create table #SomeTable

(

MyYear int,

MonthNo int,

Volume int,

Cost numeric(9,2)

)

insert #SomeTable

select 2013,...

And when those values differ they are no longer duplicates. That is what distinct means.

I have to say that a trigger that is creating a txt file throws up a big red flag to me. That sounds like the wrong tool for the job...

You are welcome. Glad that worked for you.

Maybe if you can explain what you are trying resolve we can offer some suggestions.

timscronin (9/11/2013)

---

Developers are having an issue with BizTalk and SQL Server . They asked me if we could SET FMTONLY ON at the database level. Their are several...

DISTINCT means to get rows that are unique across the entire row, not just one column. You have "duplicates" but if you look close you will find that at least...

Sure you can do this pretty easily with a tally table.

;with MyData as

(

select '12th Main St' as StreetName, 1 as FromPremise , 5 as ToPremise

union

select '10th Main St' as StreetName,...

Do you really need this in another table? This sounds like a great place for a computed column in your original table. That way you don't have to duplicate all...

rray 44280 (9/10/2013)

---

I was given this query this morning. It's not a pattern of syntax I can ever recall seeing before. I guess it works, but I can't figure out...

I wish I could make the KC event...