poornima.s_pdi (11/1/2016)

---

Hi,

Thanks for your reply.

But I am getting the below error while executing the stored procedure.

Msg 487, Level 16, State 1, Procedure GetTop20MessageByRoomIdOrderByTimeStamp, Line 6

An invalid option was specified for...

This procedure returns the top 20 rows, filtered on the RoomID in the descending order of the TimeStamp

😎

CREATE PROCEDURE [dbo].[GetTop20MessageByRoomIdOrderByTimeStamp]

(

@ROOMID INT

)

AS

SET NOCOUNT ON;

SELECT

TOP...

poornima.s_pdi (10/31/2016)

---

Hi ,

I want to take the data from database based on Id order by timestamp desc and then select first 20 records from the database.

How to achieve this?In...

Jeff Moden (10/31/2016)

---

Eirikur Eiriksson (10/31/2016)

---

Jeff Moden (10/31/2016)

---

Eirikur Eiriksson (10/31/2016)

---

Quick suggestion, reading the data to be deleted into a "bucket" variables can drastically speed up the delete, here is an example...

Jeff Moden (10/31/2016)

---

Eirikur Eiriksson (10/31/2016)

---

Quick suggestion, reading the data to be deleted into a "bucket" variables can drastically speed up the delete, here is an example based on the DDL...

Quick suggestion, reading the data to be deleted into a "bucket" variables can drastically speed up the delete, here is an example based on the DDL previously posted.

😎

DECLARE @id ...

Quick question, does the "user" have access to the share on the file server?

😎

DesNorton (10/31/2016)

---

Eirikur's solution groups by PaymentComfirmDate.

In order to group by Year/Month, you will need to use something like this, which groups by the 1st of every month.

-- ...

MonthYear = DATEADD(mm,...

Here is a quick example that should get you passed this hurdle

😎

USE TEEST;

GO

SET NOCOUNT ON;

/* Sample data set */

;WITH SAMPLE_DATA(Amount,PaymentComfirmDate,PaymentType) AS

(

SELECT

...

Have a look at this article "AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.[/url]" from the SQL Server Customer Advisory Team.

😎

Not a complete solution but should help you get over this hurdle

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#Payment') IS NOT NULL DROP TABLE #Payment;

CREATE TABLE #Payment (

PaymentId int,

PersonId int,

PaymentYear int,...

Quick suggestion, do the union in a CTE and apply the row_number outside the CTE

😎

Looks FUBAR, questions, how big is the database? what is the latest good backup? what other recovery options are there (manual data entry etc.)? do you have the failed hard...

Jeff Moden (10/24/2016)

---

I came up with similar but...

You are very welcome.

😎