This is one of the few cases where dynamic SQL should be considered.

Take a look at this [/url]article on the subject, particularly the 'dynamic SQL' bit.

metroman17 (7/1/2015)

---

DECLARE @ServiceStatus TABLE

(ServerName varchar(128)

,ServiceName varchar(128)

,StatusOfService varchar(128)

,StatusAsOn datetime)

INSERT INTO @ServiceStatus (StatusOfService)

EXEC master..xp_servicecontrol 'QueryState', 'msdtc'

UPDATE @ServiceStatus

SET ServerName=cast(@@SERVERNAME as varchar(128))

,ServiceName='Microsoft Distributed Transaction Coordinator'

...

When I have had this problem in the past, it has usually been because there...

What is the datatype of the PK?

Are you certain that only one instance of the job can be running at any one time?

For someone with so many SSC points, I'm surprised that you don't know how to insert links.

The first link was the same as mine, and

here[/url] is...

There is a Stairway devoted to it here[/url].

I'm not saying that it will be easy, by the way. But you may find something useful in there in terms of being...

The only thing that comes to mind that might allow that is BIML.

SQL Search[/url] from Redgate will do most of this for you. No code needed and it's free.

Brandie Tarvin (6/25/2015)

---

I know that already.

What I want is to be able to upload a picture of an error BEFORE I start a post. Then I can just call it...

arooj300 (6/25/2015)

---

Hi Expert,

I am trying to upload Excel file through SSIS package , there is no job . we are calling from front-end and manually uploading. For that one we...

SQL Guy 1 (6/24/2015)

---

Thanks for 1st tip, Phil. Rollup works for me, however with some changes to order by clause.

But about the 2nd tip, this is not exactly BOL...

Check here[/url] for some ideas.

You don't need BOL installed to use it. Look here.

roblew 15918 (6/24/2015)

---

Hi,

Previously Microsoft had a nice easy to view break down of what features where in what products.

Does anyone have a link for the 2014...

You may find this [/url]related article interesting.

You're certainly going to have to do some indexing, but the optimal set of indexes will depend on the search patterns. Get some users...

gchappell (6/23/2015)

---

I have a job I want to run everyday but before this job starts and I want to check and see if another job has completed before I start...