You could open the RDL in an XML editor (Notepad++ works great for that), and use search-and-replace in there.

Why depend on two asynchronous processes?

Can the process that generates the files log when it's done, and then the process that uses the file checks that log? Make it...

I've seen plenty of BS in databases, but I've never seen anyone advertise for it in a job description...

I'm a little confused on your requirements.

Is this correct:

LOT must be more recent than 90 days in past

Most recent SHIPMENT must be earlier than 90 days in past

Is that what...

Any reason to not use UNPIVOT for this?

SELECT

Batch,

Account,

Item,

Ref,

PageNo,

ItemNo

FROM

(SELECT

*

FROM

sktrans) AS S

UNPIVOT ( ItemNo FOR ItemCol IN (ItemNo1, ItemNo2, ItemNo3, ItemNo4, ItemNo5) ) AS UP;

Check with Microsoft on that. They have phone and online support for licensing questions. Answers you get from them are official. Anything you get from us is...

Goes right along with new words for old concepts. "Cloud" = "client-server", and so on.

We have words with multiple meanings ("DBA" is right up there for unlimited ambiguity), and...

Try...Catch can do what you need.

Example:

CREATE PROC dbo.Proc2 (@Input_in VARCHAR(100))

AS

SET NOCOUNT ON;

RAISERROR('Proc2 failed', 16, 1);

SELECT

@Input_in;

GO

CREATE PROC dbo.Proc1

AS

SET NOCOUNT ON;

BEGIN TRY;

EXEC dbo.Proc2 @Input_in = 'Hello world';

END TRY

BEGIN CATCH

SELECT

ERROR_MESSAGE();

END CATCH;

GO

EXEC dbo.Proc1;

David.Poole (5/27/2016)

---

If you turn up to an interview as Britain's worst presented compost heap then more fool you. You don't know who you are going to meet, whether visitors...

In the scope of your Exec statement, "exec (@qry)", @value4 is not declared. It's declared outside of that.

Take a look at sp_executesql, instead of exec, for running dynamic SQL...

The problem isn't your login. It's the service...

I don't think you can batch-modify maintenance plans.

That's one of the advantages of writing your own, using SSIS and T-SQL, instead of using the built-in tools. When you write...

Customize the sub-query Where clause to suit your needs, of course.

Recombinant (5/27/2016)

---

Completely agree but most people leave because they know that...

martin.whitton (5/27/2016)

---

Yes, "really dangerous".

I can't imagine any situation where it would be good practice to do this (although I understand how it could be tempting).

Does anyone have an example of...