Try Codeplex - it may have what you want

http://www.codeplex.com/

Have you attempted to use the MERGE statement? An example of its features, capabiliies, and use can be found at:

http://www.codeproject.com/KB/database/SQL-2008-Merge-Statement.aspx

Steve Jones - SSC Editor (8/12/2011)

---

Roy Ernest (8/12/2011)

---

Planning to write...

You might find this helpful

http://www.sqlservercentral.com/Forums/Topic267061-176-2.aspx#bm1135582

-- Author: Martin Grape

Be sure to read the comments posted by:

--Comment by Jeff Moden

----The only problem is that the code doesn't recognize missing "SysID"...

Evil Kraig F

On the QOD:

http://www.sqlservercentral.com/Forums/Topic1157383-1222-5.aspx#bm1158891

Many thanks for your comments on the above. Hopefully even without SanDroid's endless rant, some people learned something about why not to Shrink a DB.

Again...

Lynn Pettis (8/11/2011)

---

Forever it won't dominate your destiny. Life there is after the dark side.

I was going to wait until tomorrow night, but it is close enough.

I am resigning...

Hope this gives you a start:

CREATE TABLE #T(pjt_no VARCHAR(30),Street VARCHAR(100))

INSERT INTO #T

SELECT 'abcde','1 Main Street' UNION ALL

SELECT 'xyz','1 S.View Ave'

SELECT SUBSTRING(pjt_no + REPLICATE(' ',50)...

C.K.Shaiju (8/11/2011)

---

Ninja, Correct. But for me in the actual script almost 62 batches are there. So I tried Ron's solution. If I get the result in a single exec, it...

Brandie Tarvin (8/10/2011)

---

Help me bug Microsoft about a minor issue that is driving me sane.

https://connect.microsoft.com/SQLServer/feedback/details/683683/ssms-open-empty-environment-option-does-not-work-correctly

This one is giving me heartburn. I almost ran something in Production that was supposed to...

In order to help those who can help you with a tested T-SQL statement, please, please post the table definition(s), provide some sample data and the desired results from the...

You might modify your code to include:

IF OBJECT_ID('tempdb.dbo.#Ts','U') IS NOT NULL

BEGIN

...

This will return the time indexes were last updated:

...

sqlfriends (8/8/2011)

---

Another question related, if our production is going to be using standard version, can I install first the standard version on my testing box, and then after this, I...

Posted to incorrect forum .. sorry about that.

Jeff Moden (8/7/2011)

---

bitbucket-25253 (8/7/2011)

---

Jeff Moden (8/7/2011)

---

sqlfriends (8/5/2011)

---

I would like to do some testing on a testing box for installation.

Our production server will be enterprise version

For the license issue, can I...