eseosaoregie (1/19/2012)

---

In the example I gave there are only 3 different packages. However what if there were 2000 packages. I like to have a generic query that will select all...

Evil Kraig F (1/19/2012)

---

eseosaoregie (1/19/2012)

---

This output is correct because package 120000 has only code associated with it. The other packages have 2 or more different codes. The output is required...

First... Use aliases so your select statement is shorter:

SELECT alias.column1, alias.column2

FROM server.database.schema.table alias

Second... Text should be enclosed in single quotes and...

EDIT... I counted wrong... Removed statement.

rpt_tblOracleCustomers.[Account Number]

Is incorrect. It is either:

databaseName.rpt_tblOracleCustomers.[Account Number]

OR

rpt_tblOracleCustomers.schemaName.[Account Number]

Based on the information you gave and the question you asked...

SELECT PACKAGE,CODE,[DESCRIPTION]

FROM #TEST

WHERE PACKAGE = 12000 AND CODE = 'BOXC' AND [DESCRIPTION] = 'BOXING'

So, if there is more to this,...

I think some here are operating under the assumption that no previous due dates are in that table. That's why they are selecting TOP 1.

My guess is that...

Are you getting this? HINT: SELECT @filename...

Ok, look at this:

Select @Filename, @Databasename

from #TempTable

where ID_Num = @I

@filename and @databasename have not been set to anything. So they are NULL.

Right off the bat I can see that you are using 2 ## instead of 1 for your temp table...

Adam Machanic (1/19/2012)

---

Oooohhh, Reading! Yeah, I *totally* agree. You should start reading...

I thought a Borg reference was acceptable since we are all a...

Adam Machanic (1/19/2012)

---

Realistic Imitation Firearm ? 😀

Room Inventory Form? 😀

Ruhe in Frieden? 😀

Routing Information Field? 😀

Rain-Induced Fade? 😀

Rapid Innovation Fund? 😀

😀 😀 😀 😀 😀 😀 😀 :-D...

ohack (1/19/2012)

---

Hi,

Posted this in the SS2K5 Replication forum a couple of days ago but it seems very quiet there. This issue comes about under SQL 2008 as well so...

We've changed...

guerillaunit (1/19/2012)

---

I have a date column that displays as "12/1/2011" in Access. I noticed that if I write a Select statement in Management Studio, I get no results when...