Stefan Krzywicki (8/6/2014)

---

Well, it finally happened. I've been threatened with it my entire career. You hear about it in meetings all the time, but you figure it is just hyperbole....

I took a guess that the author was looking for the column list in the tooltip. However I very rarely use select * and surprisingly when I am typing a...

Right...as I said look at SQL Search. It will do this.

powerofsound (8/5/2014)

---

Thanks for the heads up Sean, I do know the issues with using Nolock, but unfortunately it’s my company’s policy to use it on all queries. Also the...

SQL_Kills (8/5/2014)

---

Hi,

I'm not sure how my Question is Vague? Ideally the user will enter the table name as a parameter to the stored Procedure findMyTable('TableA') and this will then run...

powerofsound (8/5/2014)

---

Thanks for the article, I did some reading and some more and its semi clear, but not 100% I also didn't paste the full query I am using. ...

thejordans21 (8/5/2014)

---

I was able to get the info into the second temp table OPENPO1

here is a my raw data (partial)

PLANTPLANT_DESCVENDOR

7010Coquitlam DCPR1

NOPENULLNOPE

NOPENULLNOPE

NOPENULLNOPE

NOPENULLNOPE

NOPENULL1014435

NOPENULL1014435

NOPENULL1014435

7012Chilliwack DCPR1 ...

One thing you didn't mention is an external application. What if you have an external application that performs CRUD operations via pass through sql?

SQL_Kills (8/5/2014)

---

Hi,

Has any one got some useful scripts that I could you that would tell me how a table is populated within a database? So i'm thinking of a stored...

Awesome. I...

Here is another one...unfortunately I did not record who provided this. If anybody recognizes this please let me know so I can give proper credit.

ALTER function [dbo].[NewInitCap]

(

@word varchar(2000)

) returns table

return

select...

Here is a scalar function I wrote years ago. This works pretty well but the performance is not great.

ALTER function [dbo].[InitCap]

(

@inString varchar(max)

)

returns varchar(max)

as

begin

declare @currIndex int,

@nextIndex int,

@result varchar(max),

@StrLength int

set...

This topic comes up around here from time to time. I have 3 different version stashed in my snippets. The first one here is from ColdCoffee.

--From Cold Coffee

DECLARE @Table TABLE...

sivarao.n (8/5/2014)

---

Hi All,

We are also getting same error message in production server intermittently.

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><s:Fault><faultcode xmlns:a="http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher">a:InternalServiceFault</faultcode><faultstring xml:lang="en-US">A network-related or instance-specific error occurred while establishing a connection to SQL Server. The...

Is there even a question here? This just looks like a stack trace from .net.