patrickmcginnis59 10839 (8/11/2014)

---

Looks like a "create table" inside an uncommitted transaction would do it. You might shop around for a better blocking script.

edit: reran your script, I'm a bit...

Jeff Moden (8/13/2014)

---

Thanks, Lynn. I read the original post incorrectly and didn't run your code to see. Thanks for the correction.

I must admit, I'm totally confused. If...

[/quote]

Do the strings always end with a dash, space, numeric value?

If so, using the setup from Sean, look at the code for the second column.

declare @Table table (someString varchar(25))

insert @Table

select...

Thanks to SQL Sentry we have built on to our job step -- alert-- and can now check for jobs that run too long. But I do see one more...

Jeff Moden (7/30/2014)

---

500*500 is only a quarter million row Cross Join and would probably take less than a quarter second to materialize and just a second or two to insert...

Jeff Moden (7/28/2014)

---

dwilliscp (7/27/2014)

---

Jeff Moden (7/25/2014)

---

dwilliscp (7/25/2014)

---

I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every...

So we end up with...

PlantMaterial_numberProduction_VersionResource_Code

CHANC11C-82600001 APAG

CHANC11C-82600001 ...

I cut the table down to the fields needed... and fixed Plant, when I renamed the plants I exceeded the field size.

CREATE TABLE [dbo].[Resource_Mat](

[Plant] [varchar](5) NOT NULL,

[Material_number] [varchar](18) NOT NULL,

[Production_Version]...

Jeff Moden (7/25/2014)

---

dwilliscp (7/25/2014)

---

I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within "Company,...

I used APEX to create the inserts.. and then find and replace to turn it into dummy data.. will just key in some data later this afternoon when I get...

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', N'999999999.000',...

CREATE TABLE [dbo].[Resource_Mat](

[Plant] [varchar](4) NOT NULL,

[Material_number] [varchar](18) NOT NULL,

[Production_Version] [varchar](4) NOT NULL,

[Resource_Code] [varchar](8) NOT NULL,

[Std_Batch_Size] [varchar](18) NULL,

[UOM] [varchar](3) NULL,

[Std_Run_Time] [varchar](14) NULL,

[Time_UOM] [varchar](3) NULL,

[Batch_Min] [varchar](17) NULL,

[Batch_Max] [varchar](17) NULL,

[Stocking_Strategy] [varchar](2) NULL,

[Trans_Type] [varchar](2)...

I broke down and wrote it as a Cursor... Still running so I do not know if my code is correct yet... I will create a table and some dummy...

dwilliscp (7/25/2014)

---

I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within "Company, Plant, Resource"...

I am working with our AD team to see what is going on... while the MSDN site does not say any thing, I think it is permission related. There was...