I have never come across this either.

The first thing I would do is run Brent Ozar's sp_blitz. As well as the health check, there are parameters which allow you...

The simple approach would be to put your query in a CTE with

,ROW_NUMBER() OVER (PARTITION BY Model ORDER BY Cal DESC) AS rn

and then SELECT FROM the CTE WHERE rn...

Do you have any DDL and test data to demonstate this?

1. If RT.coloumnC etc are strings, you could try something like:

RT.coloumnC='something' COLLATE <RT.coloumnC collation>

2. If #lt is not too big, you could try creating a remote SP and passing the...

¿Qué?

Just send an html email with the table in the body text.

• This reply was modified 1 years, 1 months ago by Ken McKelvey.

https://stackoverflow.com/questions/7086393/create-html-table-with-sql-for-xml/39487565#39487565

https://learn.microsoft.com/en-us/sql/xquery/flwor-statement-and-iteration-xquery?view=sql-server-ver15&redirectedfrom=MSDN

Why are you trying to install SQL Server 2005 when the lowest supported version is SQL Server 2016?

What version of Windows are you trying to install SQL 2005 on? I...

It is the SQL Server VSS Writer service which writes details of VSS backups to MSDB so that is where to start trouble shooting. Check the service account, check the...

• This reply was modified 1 years, 1 months ago by Ken McKelvey.

The SQL Server VSS Writer service is probably disabled. It might have been disabled if it was interfering with SQL Server backups.

Before relying on someting like Veem, make sure you...

You could generate the code as dynamic SQL to cope with different numbers but you would need to check carefully how efficient a value of 100 was.

Whatever you are trying...

• This reply was modified 1 years, 2 months ago by Ken McKelvey.

1. I hope you are not using floats for prices!

2. Do you really use reserved names for columns?

3. Are you really writing new code with the depreciated order by column...

This smells like a permissions issue for the SP. I am not anywhere I can test this but I suspect you will need to sign the SP and then have...

Or combine with the unique ordering column:

SELECT UNIT, PURCHASE_DATE, METRIC1
,CAST( SUBSTRING( MAX (
CONVERT(char(8),  PURCHASE_DATE, 112) + CAST(Metric1 AS varchar(20))
)
OVER (
PARTITION BY Unit
ORDER BY PURCHASE_DATE
ROWS BETWEEN UNBOUNDED...

My limited experience with AI at the moment, with regards to code, is that it is not very good. It can, however, provide a good starting point if you have...

For large volumes of data, I find BCP to binary files works well enough for me

You could try:

1. BCP out to binary files using the partition conditions.

2. BCP in again...