Sean Lange (5/11/2012)

---

Sometime in the somewhat recent past somebody shared a story about a company that went belly up due to their triggers not supporting multiple rows. I brought this...

If you need to fill in all the gaps created by your resolution, you may be able to use the following:

DECLARE @w TABLE (pkg_id INT, location INT, weight DECIMAL(9,2))

DECLARE @res...

This may provide you the results set you seek:

;WITH CTE AS (

SELECT DTime, id, ticketid, actionlog

,(SELECT TOP 1 DTime

FROM #tmpmatt b

WHERE a.actionlog <> b.actionlog and a.DTime < b.DTime...

This looks like a question I previously posted a solution to here:

http://www.sqlservercentral.com/Forums/Topic1290424-392-1.aspx

Even the field names are the same. Is this a homework problem or something?

Do you mean something like this?

DECLARE @t TABLE (ID INT IDENTITY, FirstName VARCHAR(20), LastName VARCHAR(20))

INSERT INTO @t

SELECT 'Peter', 'Frampton'

UNION ALL SELECT 'Cold', 'Coffee'

UNION ALL SELECT 'Dwain', 'C'

SELECT ID

,(SELECT FirstName, LastName...

Hey, wait a minute! That's part of my mantra! :w00t:

Not actually as I'm using ROW_NUMBER() and not RANK().

vinu512 (5/11/2012)

You've nailed it Dwain. All this time I was thinking that I have done this before but wasn't able to remember how I did it. I tried everything except...

If I'm understanding, I think this will handle all 3 of your requirements. At least, the results match the 3 pictures you originally posted (with the possible exception of...

Vinus - I think there's a simpler solution with no need for dynamic SQL in the trigger.

--drop table temptable

Create Table temptable (id int not null primary key, val1 varchar(50),...

I think Kingston has nailed your question. You say these are your UPDATEs (formatted for readability):

Update dbo.DailyBchDataInitialInbound

Set BchCode = Substring (Name,5,3)

WHERE Name Like '%bch%' Or Name Like...

Sean Lange (5/10/2012)

There was a story in another thread a few months ago by one of the regulars about a company that went belly up because their triggers couldn't handle...

Glad you got it so quickly.

The issue about datatype of Days Since is a good demonstration of the need to provide DDL and sample data in a readily consumable format....

stephen.sarre (5/10/2012)

---

-- Along the same lines, this is a very simple way of listing invalid data (allowing -_,;@' in the email column)

DECLARE @match VARCHAR(30)

SET @match = '%[^a-zA-Z0-9@.,;!-!_!'''']%'

SELECT email...

Please do and tell us what you find.

I must confess though I ran a timing test on the 3 and found that mine was quite slow so take care with...