Gazareth (1/23/2013)

---

dwain.c (1/22/2013)

---

Upon reflection, I realized that capturing the UserID that deleted the record is not possible in the TRIGGER itself.

So I went back and modified the code to show...

vinu512 (1/23/2013)

---

Umm guyz.....This is my try at the requirement......Is this close enough??.....I used the tally CTE to create dynamic sql for the nested replace statements :

Declare @string Varchar(max), @sql...

Don't get me started! :w00t:

I do however wish to hear the further discussion. 😛

m.rajesh.uk (1/22/2013)

---

In my test enviroment i found that out of 269 tables 99 tables does not have primary keys and 4 tables having 2 primary keys . can u...

Upon reflection, I realized that capturing the UserID that deleted the record is not possible in the TRIGGER itself.

So I went back and modified the code to show you how...

MDJ - That wasn't exactly what I had in mind. More like this (ignoring the error handling in yours which I recommend anyway to be safe):

CREATE TABLE Main

...

Yeah! CDC is it.

Maybe there's a middlin' easy alternative:

DECLARE @xmlData XML ='<MatchKeys>

<fuzzyKeys>

<key key1="MatchKey_PostOut" key2="MatchKey_Name1" />

<key key1="MatchKey_Name1" key2="MatchKey_PhoneticStreet"...

Hi Wendy!

I'll give you a general answer and if you'd like a more specific one post DDL for the main table and I (or someone else) will see what we...

DataAnalyst011 (1/17/2013)

---

The output should be something like below with values filled in for x:

Year Median Max Min LowerQ UpperQ

2010 ...

Ooops, sorry. Almost forgot. I did have to make a couple of minor changes to my original NestedReplace FUNCTION so here's that code also:

CREATE FUNCTION [dbo].[NestedReplace]

(

-- Add...

Gentlemen,

Allow me to enter a new dog in this race! Perhaps you'll find the new approach amusing. I call it the Nested Replace by Quirky Update (NRxQU for...

Last night while tossing and turning and getting virtually no sleep I thought of a new approach to this problem, which I will try to code up and post soonest.

It...

Uh, just asking here but wouldn't it make sense to vary the strings and the replacements?

Or did I miss something?

I might actually have a chance to get on this horse and ride it in the next few days.

Thanks for the heads up on this thing Steve!

I'll let y'all know...