jbalbo (10/15/2013)

---

Hi

I'm trying to setup a job to run weekly that would add/update each PROVIDER_TO_TRUSTED_PROVIDER_COLLECTION.OID_LINK

to 3 specific oids

The end goal because I have a hard time explaining...

Paul's 2 part series explains it perfectly.

http://www.sqlservercentral.com/articles/APPLY/69953/%5B/url%5D

http://www.sqlservercentral.com/articles/APPLY/69954/%5B/url%5D

Here is another way to do this. I added an identity column as a primary key.

This should work for any combination of spaces and X's.

See the link in my signature...

Larry Johnson-473989 (10/15/2013)

---

I overheard our DBA today (2013-10-17) telling a junior developer to NEVER use a TRY-CATCH block in stored procedures. He told her that it is a very...

balasach82 (10/15/2013)

---

I have few columns like SSN, Creditcard details in the table which i dont want every one who has access to the table to see. Even if they see...

You could encrypt your data before it hits sql.

yogi123 (10/11/2013)

---

Sean Lange (10/11/2013)

---

You are very welcome. Make sure you read that article and understand what the splitter...

I will quote myself here.

Sean Lange (10/11/2013)

---

Somewhat difficult to figure out what you are trying to do here. I think maybe you are trying to generate a comma separated list...

Off to tailgate before the last of US home game of world cup qualifying.

Welsh Corgi (10/11/2013)

---

I'm sorry but Proprietary information would be disclosed if I posted the execution plan.

So consider this post closed.

btw, it is slow for EVERYONE except the developer that created...

Snargables (10/11/2013)

---

i have a table that has 600 mill recs. i have an update to it that modifies 79 k records a day. Up to last saturday at 8am this...

M Jones (10/11/2013)

---

I need to simply dump an SQL table into an XML file. Simple enough. I used the SQLCMD utility to do this. ...

Welsh Corgi (10/11/2013)

---

I was approached by a Developer who created a view.

It takes 3 seconds to run from the developers PC.

It tasked 1:10 seconds when a BA or I execute...

You are very welcome. Make sure you read that article and understand what the splitter function is doing.

PiyaKaGhar (10/11/2013)

---

Hi can I insert image to show,

UPDATE [dbo].[pro]

SET [Test] = <Test, nchar(10),>

,[100] = <100, nchar(10),>

...