Alvin Ramard (9/16/2010)

---

jcrawf02 (9/16/2010)

---

Alvin Ramard (9/16/2010)

---

The Dixie Flatline (9/16/2010)

---

If I can get away in time to drive up...

DROP TABLE #Sample

CREATE TABLE #Sample (Machine INT, Goal INT)

INSERT INTO #Sample (Machine, Goal)

SELECT 111, 0 UNION ALL

SELECT 112, 0 UNION ALL

SELECT 113, 800 UNION ALL

SELECT 114, 810

SELECT AVG(d.Goal)

FROM (

SELECT Machine...

It's probably how you are calling the sp. Try this in a query window:

alter Procedure InsertInstMain(@JobKey Int, @Rows Int Output, @Errors Int Output)

As

SET NOCOUNT ON

--I am trying to populate the...

crookj (9/16/2010)

---

Chris Morris-439714 (9/16/2010)

---

crookj (9/16/2010)

---

😀

I have been called the works. In fact - I use this quote sometimes when questioned:

Hedley Lamarr: "I want...

crookj (9/16/2010)

---

😀

I have been called the works. In fact - I use this quote sometimes when questioned:

Hedley Lamarr: "I want rustlers, cut throats,...

Joe, is your middle name "The"?

Brandie Tarvin (9/16/2010)

---

Paul White NZ (9/16/2010)

---

Brandie Tarvin (9/16/2010)

---

I don't know. I read his apology like a passive-aggressive slap upside the head. "Yes, I'm apologizing, but only because I got called...

Joe Contreras-290946 (9/16/2010)

---

Hi,

I can't remember the exact syntax on creating a table that doesn't exists using SQL. Can someone help out.

SELECT firstname,lastname [NEWTABLENAME] FROM Employees

Not sure if that's the...

Jeff Moden (9/16/2010)

---

FelixG (9/16/2010)

---

Thanks a lot Jeff, I'm coming from SQL Server 2000 and did not have knowledge about rownumber().

I said "performance is vital" to avoid the use of...

Typically, how many rows are returned by...

The only time I ever encountered a requirement for both was a hypothetical question in an interview a few years ago. If I see RIGHT JOIN in a query I've...

s.chandrahasan (9/16/2010)

---

Hi ,

first many thanks for ur reply !!!

I tried but i can't do ,

can u please post again your code for my updated code...

Sure.

This set of statements performs the same action as...

Alvin Ramard (9/15/2010)

---

CirquedeSQLeil (9/15/2010)

---

jcrawf02 (9/15/2010)

---

Couldn't have anything to do with the fact that you...