rudyhinojosa2007 (12/11/2009)

---

Paul Neilsen originally created the 1.04 package, but it only supported a table with one primary key. I revised the scripts to handle up to 3 primary keys...

Thank you for the feedback. We'll try to answer any questions you may have.

Since this is SQL Server 2005, you can save the Actual Execution plan as .sqlplan file and upload that.

Actually, without seeing the actual package, it depends on the scope of the variable. If you declare a variable in a FOREACH container named MyForEach1, you won't see that...

Albatross

I have to ask the same question, why? Usually, SQL Server works better the more memory it has...

I'll give you a hint since you haven't shown us what you have tried so far, in BOL (Books Online, the SQL Server Help System that you can access by...

Isn't amazing what happens when you finally provide what you have been asked for several times? 🙂

That is why I kept asking you to read the article and provide the...

axe

ray 78019 (12/10/2009)

---

<< Why do you have questions that could be answered by yourself on a test system within an hour? >>

Bru, if you look at the left side of...

I wrote the article Deleting Large Number of Records[/url]. Take a look at the code for SQL Server 2005, you should be able to use that as a starting...

clive-421796 (12/10/2009)

---

Hi Lynn,

the procs we have use the following variations:

@StartDate = '2009-11-01'

@StartDate = '2009-11-01 12:00:00'

@EndDate = '2009-12-01'

@EndDate = '2009-12-01 23:59:59'

2 months ago I had to use your method below:

WHERE

...

The following meets your requirements:

CREATE TABLE #INBOUND_PLM_CHCM (PER_NR INT, [STATUS] INT, SOC_MAPPING VARCHAR(10))

INSERT INTO #INBOUND_PLM_CHCM (PER_NR, [STATUS], SOC_MAPPING)

SELECT 12345, 0, 'PLM-5000' UNION ALL

SELECT 12346, 3, 'PLM-5001' UNION ALL

SELECT 12347,...

clive-421796 (12/10/2009)

---

Hi Lynn, instead of using:

WHERE

tbl.YourDateColumn >= @StartDate

AND tbl.YourDateColumn < @EndDate

I prefer to use:

WHERE

tbl.YourDateColumn between @StartDate AND @EndDate.

-------------------------

Have...

Jeff Moden (12/10/2009)

---

Lynn Pettis (12/10/2009)

---

Jeff Moden (12/10/2009)

---

clive-421796 (12/10/2009)

---

Cant open a .rar (winrar) file ? Ah come on Jeff, never heard of anyone working in IT for years that...