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

DROP TABLE #tmp;

CREATE TABLE #tmp

(

FormulaId CHAR(2)

, IngredientId CHAR(2)

);

INSERT #tmp

...

Sorry, I'm out of ideas.

Jim-S (12/22/2016)

---

Unfortunately it is causing us some issues, we are using Microsofts ALM (kanban model) to deploy our stuff to test and live servers. We attach our dtsx files/ code...

nadersam (12/22/2016)

---

Hi Guys,

I am trying to execute an array of comma delimited SQLs in a stored procedure.

I call it as below

declare @Parameter as nvarchar(max)

set @Parameter ='insert into Orderlog (trans_no)...

patelxx (12/21/2016)

---

Please can you help me in turning the following script into a Stored Procedure, I have just tried doing this but I keep getting errors like I have not...

And here's that link again, in clickable...

A detailed explanation of the problem you are having and details of the error you are receiving.

sarwar.ali490 (12/20/2016)

---

i wanted to stop the file from loading into DW if the status of file is "rejected" and set up error message and notification ,given the criteria above...

Sean Lange (12/20/2016)

---

Can you provide some sample data for us to use and what the desired output would be for that sample data? Just showing us the results of your...

Is there a question in there somewhere?

OK, fair point. I think that you will find this information...

It's completely possible, but you'll need to write some sort of framework (or buy one) to do it. It's tough to describe in just a few sentences, as it required...

Welsh Corgi (12/20/2016)

---

I'm trying to remember how I would check for the existence of a file and Delete it in a VB.NET Script Task.

If it exist I want to Delete...

Here is the code, formatted so that others have at least a chance of parsing it. Please use IFCode tags in future.

SELECT

[Batch Number] ...

Sreejith! (12/20/2016)

---

Hello,

Found Powershell script in below blog to list the last install date and time for windows updates on servers.

https://gallery.technet.microsoft.com/scriptcenter/4d70947e-21b1-4a45-9d78-a7198ed55cca

Is there any way we can get SQL server service pack,hotfix...