wweraw25 (12/27/2016)

---

I'm comparing on combination of keys.

I know lookup is not a good option for millions of rows.

Is there any other way to grab the difference and insert into table...

wweraw25 (12/27/2016)

---

Hello,

I have two tables

-- Table A in Server A of Database A

-- Table B in Server B of Database B

My Source is Table A and Destination is Table...

SQL Prompt to the rescue!

For the benefit of others, here's that query again, with line-breaks :w00t:

SELECT

Account02_ACCOUNT_ID6 ...

meiry242 (12/24/2016)

---

Thank you very much for you replay , i found info about this tool ,

but i haven't found any info about my situation where i need to fill data...

meiry242 (12/24/2016)

---

I have generated 200 mega data script from local SQL Server, which I generated via Tasks -> Generate Script in SQL Server Management Studio.

When I try to execute it...

If the statements to be executed come directly from a table whose contents cannot be manipulated, except by suitably authorised...

Welsh Corgi (12/23/2016)

---

Lowell (12/21/2016)

---

Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer I posted for...

hamzajosh (12/22/2016)

---

Phil, Like Drew pointed out, your solution returns formulas that have even ONE ingredient in common, while I am looking for a exact match on ALL ingredients. I appreciate...

I'd also be interested to hear why my solution...

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...