dwilliscp (7/25/2014)

---

INSERT INTO [dbo].[Resource_Mat] ([Plant], [Material_number], [Production_Version], [Resource_Code], [Std_Batch_Size], [UOM], [Std_Run_Time], [Time_UOM], [Batch_Min], [Batch_Max], [Stocking_Strategy], [Trans_Type], [Recipe_Status], [Short_Description], [Rounding_Value], [Distribution_Key]) VALUES (N'CHANC', N'11C-8260', N'0001', N'SIL', N'15.000', N'KG', N'0.100', N'H', N'0.000',...

Okay, I still have to ask. Are you sure there is data in all three tables?

crmitchell (7/25/2014)

---

Lynn Pettis (7/25/2014)

---

crmitchell (7/25/2014)

---

Coderx7 (7/24/2014)

---

Difference between SQL Server and Oracle.

If you want to treat the loop inserting 1000 rows of data as a single transaction in SQL Server you...

There is always the...

crmitchell (7/25/2014)

---

Coderx7 (7/24/2014)

---

Evil Kraig F (7/24/2014)

---

Coderx7 (7/24/2014)

---

I really cant get the part to insert 1000 rows at once! How is that even possible? is it mot dangerous ? since it...

edit: Never mind, reread the post and saw that if the TOP 100 was removed the query ran.

The first year of the league it was 16 teams. Starting with the second year Dan dropped it to 12 teams. He would be the one to explain...

One thing to remember about Oracle and SQL Server, they are not the same. The internals are different, and there for how the operate is different.

For example, the following...

Well, you changed the entire meaning of the...

First, you aren't using actual temporary tables but permanent tables as temporary tables.

Try this:

Begin

SELECT

A.[Entry No_],

A.[G_L Account No_],

A.[Gen_ Prod_...

shah_khan_1289 (7/23/2014)

---

this is my first sp

create proc createSp1(@acc varchar(20),@columnname varchar(25))

as

declare @value flaot;

set @query='select top 1 @value='+@columnname+' distict where DISTRICT='+@District;

-- select @query;

EXEC sp_executesql @query,N'@value nvarchar OUTPUT',@value OUTPUT;

select @value...

Thought I'd try and see if there was an alternative:

create table #phoneNums (phone varchar(50));

insert into #phoneNums values ('800-555-1212');

insert into #phoneNums values ('888-555-1212');

insert into #phoneNums values ('336-555-1212');

insert into #phoneNums values ('804-555-1212');

insert...

This:

create table #phoneNums (phone varchar(50));

insert into #phoneNums values ('800-555-1212');

insert into #phoneNums values ('888-555-1212');

insert into #phoneNums values ('336-555-1212');

insert into #phoneNums values ('804-555-1212');

insert into #phoneNums values ('652-555-1212');

insert into #phoneNums values ('704-555-1212');

insert into...

pmscorca (7/23/2014)

---

I don't use the Retail channel to buy SQL Server.

I repeat that I know that SQL Server 2014 has rights to downgrade.

Simply, I want to know how technically I...

Eirikur Eiriksson (7/23/2014)

---

First suggestion would be to install the SQL 2012 alongside...