Your Dev db is on the same instance as the Prod db? If yes, that's the first best practice to apply: don't do this!

yb751 (10/29/2015)

---

Ed Wagner (10/29/2015)

---

yb751 (10/29/2015)

---

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but then I...

SUBSTRING(AutoScore,1,4) == "APP1" --> APP1 output

SUBSTRING(AutoScore,1,4) == "APP2" --> APP2 output

...................

APP1 data should be directed to the APP1 output, and so on for APP2 ...

Common requirement...

You could start here and see whether you get anywhere.

Also here may help.

celine.godines (10/29/2015)

---

I thought about this but I wouldn't know how to start to be honest. I am a system tester since February only, I am getting better with SQL queries...

Try this.

celine.godines (10/29/2015)

---

Morning!!

I am doing some data gathering before 'the real deal', I am not a wiz on SQL, manage my way around but that's pretty much it, hence the use...

Excellent link and way too many Jeffs getting involved there!

Alan.B (10/28/2015)

---

Hi folks. I needed to write a stored proc that takes generates a string of random characters @minlen to @maxlen characters long for testing some functions. What I came...

And here is part 2 again, for those people who prefer their SQL formatted 🙂

declare @object_name sysname

,@object_id int

,@SQL nvarchar(max);

select @object_name = '[' + object_schema_name(o.object_id) + '].['...

No.

Now I suggest you change your...

Don Shoemaker (10/28/2015)

---

We are running SQL 2014 SP1. We are using defined Full text indexes on several tables in the database. However, on one specific set of servers,...

celine.godines (10/28/2015)

---

It will be for multiple customers (I have about over 1000000)

All customers have different products and different Names/Values... (and not always 2 products and 6 names, it will varies)

I...