In order to retrieve the output of a select in a stored proc you have to first insert it somewhere. A temp table is the most logical place from what...

Make sure your command prompt is "running as an administrator". You can right click a command prompt shortcut and select "Run as Administrator". I ran into this issue when first...

jbalbo (6/4/2012)

---

HI ,

I have the following which picks up data up to 6 times , but if there are only 4 entries I want the last two to be blank...

Here is the sql with some formatting:

SELECT (

SELECT COUNT(*)

FROM account A

WHERE STAT = 'O'

AND dormant = 'N'

AND code = '200'

GROUP BY code

) active

,(

SELECT COUNT(*)

FROM account

WHERE OPEN_DATE BETWEEN '7-MAY-2012'

AND '31-MAY-2012'

AND code...

flashykez (6/4/2012)

---

hello everyone, please hoe do i use this script to generate multiple rows, this just works if only a row of information is desired. hope to get a reply...

weisen678 (6/4/2012)

now, I come back to this project, I tested on the code you created, then I get this error message

Msg 213, Level 16, State 1, Procedure InventoryLow, Line 4

Column...

Jeff Moden (6/2/2012)

---

Heh... I've heard that. 😀 However, while that is the general mantra of database...

Stefan Krzywicki (6/1/2012)

---

Sean Lange (6/1/2012)

---

Stefan Krzywicki (6/1/2012)

---

SQLRNNR (6/1/2012)

---

Stefan Krzywicki (6/1/2012)

---

Revenant (6/1/2012)

---

Stefan Krzywicki (6/1/2012)

---

Cath Trimble (6/1/2012)

---

By the way, the houses near the tech center sure are expensive - about $250,000...

Stefan Krzywicki (6/1/2012)

---

SQLRNNR (6/1/2012)

---

Stefan Krzywicki (6/1/2012)

---

Revenant (6/1/2012)

---

Stefan Krzywicki (6/1/2012)

---

Cath Trimble (6/1/2012)

---

By the way, the houses near the tech center sure are expensive - about $250,000 and up I think?...

This would be non-sargable so performance could very easily become a big issue.

or you could create a...

Yes what will work as a solid performance enhancement for sql server may not be the same in Oracle. For example in Oracle it might be better to use a...

michaelh-731356 (5/31/2012)

---

I have a query that executed OK in SQL 2008.

INSERT INTO @Authors (AuthorName)

SELECT AuthorName

from tblAuthors

ORDER BY AuthorName

However in SQL 2012, the Authors are not inserted by the Order...

Your issues could be slightly different than mine.

Seriously you know better by now. Maybe somebody else has a new one...

Well you didn't mention that this was an attempt to learn a concept until quite late. Regardless the same need for ddl and such still exists. Just because it is...

ROFL!!! Now that is an urban myth over there. There are two major...