Hi and welcome to the forum. Here are two possible solutions, the first uses conventional aggregation and the second one uses the window function aggregation, the former seems to perform...

mmsheehan (12/29/2016)

---

We are seeing the following error on a few of our systems ... I've searched the internet, but cannot find the "exact" error. Any suggestions?

A fatal error occurred while...

SQLserver_learner (12/29/2016)

---

Thank you John.

Both the queries are working. but it is giving 2 rows instead 1 row for NULL values for column [MDDS01_PORTFO_D]. one row is having latest timestamp...

Simple row_number solution (didn't see John's fine solution before posting)

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.MMDDS01_PORTFO_LIST') IS NOT NULL DROP TABLE dbo.MMDDS01_PORTFO_LIST;

CREATE TABLE [dbo].[MMDDS01_PORTFO_LIST]

(

[MDDS01_UUI_D] ...

Snargables (12/28/2016)

---

i can remove them from the avail group then change to simple then shrink then add back to avail group however i'd rather not have to do that unless...

Are all databases in simple recovery or are any in full recovery? If any in full recovery, are all of those with regular log backups?

😎

Strongly suggest that you use...

Quick thought, it is a good practice to use HOLDLOCK with the MERGE statement to avoid race conditions, whether that's in an explicit transaction or not is not really relevant.

😎

Simply copy and paste from the document and then use the IFCodes...

Hi and welcome to the forum....

Quick question, are the rows identical or are you comparing individual columns/column combinations?

😎

Strongly suggest that you use...

SQLUSERMAN (12/25/2016)

---

Hi all,

Would using UserID column (GUID) or BankAccount column (9 digit integer) as the primary key column be less efficient than using an ID column of type integer...

Bill Talada (12/23/2016)

---

Strange! I've never seen anyone set a date datatype variable to an empty string. But if you do that, it immediately gets set to Jan 1,...

Here is a better way of testing for the missing date value

😎

ALTER PROCEDURE [dbo].[MyStoredProcedure]

(

@MyDate date = NULL

)

AS

BEGIN

If @MyDate IS NULL

BEGIN

SET @MyDate...

ptownbro (12/23/2016)

---

This seems like it should be simple to solve, but for some reason I can't find the answer.

We have a simple stored procedure that has one date parameter that...