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...

Will not work if the earlier wan is higher than the later wan as noted in the previous posts.

😎

The assumption made in the code was that the WAN values would be in an increasing order, as that's correct according to the last sample, one has to add a...

Quick thought, if the table/object is not in either the user's default schema or in the dbo schema, the reference to the table must be fully schema qualified

😎

(Changes in bold)

DECLARE...

Quick thought, the output parameter must be declared with the output keyword

😎

ALTER PROCEDURE [dbo].[spTelling]

(

@scannummer Nvarchar(13)-- input only

@myOutputParam INT OUTPUT -- output parameter

)

AS

BEGIN

Then the keyword is used...

TomThomson (9/30/2014)

---

Eirikur Eiriksson (9/30/2014)

---

Sounds like a contradiction, an event which in it self cannot be considered random just because we do not comprehend the causes, resulting in another event (for...

What is the output of

SELECT @@VERSION

on your system?

😎

This...

Duplicate post, respond here

😎