er.mayankshukla (10/8/2014)

---

Hi All,

I have a log database where I have all the stored procedure for logging to log tables.

There are two databases - Dev and Test , which has stored...

That is so true, just as beauty, ROI is only in the eye of the beholder

😎

This is even more straight forward to do using the row_number function and set the order to select Current first if it exists, here is a quick sample

😎

USE tempdb;

GO

SET NOCOUNT...

Further on the subject, first an example of a user, title and status tables with mandatory constraints and keys.

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

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

Ed Wagner (10/7/2014)

---

Sean Lange (10/7/2014)

---

That has been going on...

Elementary:blush:, add the aliases and a from clause

😎

UPDATE ER

SET ER.LeaveDate = DATEADD(wk,2, FC.enrollDate)

FROM Fatals_CTE FC

INNER JOIN DBO.Enroll ER

ON ER.enrollmentID = FC.t_enrollmentID;

Quick question, why use cross apply when this can be achieved more efficiently with an inner join?

😎

SELECT

AX.id

,AX.name

,MAX(BX.sal) AS sal

FROM...

Quick thought, the filter is only applied in the scope of the sub-query, effectively a cross apply without a filter which will return all rows. Consider this query instead

😎

USE tempdb;

GO

SET...

You are more or less there, here is a run-able self explanetory example

😎

USE tempdb;

GO

CREATE TABLE dbo.TBL_TO_UPDATE

(

TTU_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED...

Quick suggestion which doesn't use a cursor and also avoids touching the default trace which cannot be altered via the procedure. The @status = 0 turns them off, 1 turns...

Luis Cazares (10/6/2014)

---

Not sure if I can call it luck. The one in charge of this process decided to remove the MERGE and use a combination of update and insert...

GilaMonster (10/6/2014)

---

It's the same...

Quick suggestion

😎

DECLARE @DB TABLE(DBNAME NVARCHAR(128));

INSERT INTO @DB(DBNAME)

VALUES (N'DB_1'),(N'DB_2'),(N'DB3');

DECLARE...

Here is a quick solution, more for prototyping but it works

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

DECLARE @TXML XML = '<EventOne Date="09/22/2014" ID="12196996" InternalEventOneID="96436969" xmlns:reslib="urn:reslib">

<EventOneDate>09/22/2014</EventOneDate>

<TimestampCreate>09/22/2014 11:37:06:413</TimestampCreate>

<Comment>Comment One!!</Comment>

<EventZ EventID="834033" EventHistoryID="375381" InternalEventID="4843699" InternalHistoryID="17082526">

<EventType Word="PLAD">One</EventType>

</EventZ>

<EventOne...

Quick first notes (there will be more):

😎

"Users"

1. What attribute or collection of attributes uniquely identifies each user?

2. Users cannot have middle or additional names?

3. Full name should be a...