I appears that your table [dbo].[PICK_RELEASED_ORDERS] contain one row per line item, rather than one row per order -- is that correct? Also, it appears then that the code that...

elutin (5/22/2010)

---

Hey man, you are trying to dictate artist how to draw? That what government did and does in some contries (USSR, China, North Korea etc.). There is a democracy...

elutin (5/21/2010)

---

The best use of SELECT without FROM

IS DRAWING PICTURES

(switch to text output before execution):

select '0000^===========\0000' as [picture]

union select '000/^\__________\\000'

union select '00//0\\__________\\00'

union select...

SELECT also serves as a synonym for SET.

declare @a int

select @a = 5

print @a

Nice tweak, Jeff. Not perfect -- won't allow for years prior to 2000 (and I, for one, have a birthday before 2000 :hehe:) -- but a definite improvement.

I do not think ISDATE() is a good way to solve the problem OP has. Also, given the anomalies, I was wondering when would you use ISDATE() and be sure...

You'll have to be a little more specific in your question. It is not clear what you are asking for.

It sounds like you want to call a SQL function...

sql.kishore1 (5/17/2010)

---

create table TestTable

(id int,

date Varchar(20)

)

insert into TestTable values(2,'08/31/1984')

insert into TestTable values(1,'07/12/2005')

insert into TestTable values(3,'08/31/0002')-- in this row i inserted 0002 intentionally my data had some errors like that.

declare...

You're using 3 temporary tables in your query -- what is populating those tables when you run this in each of the two scenarios you mention?

Maybe you should log in to the machine at about 10:45pm and see what file has gotten larger, or if there is some file other than a .MDF file that...

Beautiful. I like this. Would probably be a little cleaner with...

I'm not up on Access 2003, so it may be that it is not ANSI-92 compliant. Go back to using the FROM clause you initially supplied (without the JOIN...ON syntax)...

reg 18234 (5/3/2010)

---

Rob Schripsema (5/3/2010)

---

reg 18234 (5/3/2010)

---

The SQL statement below returns what I want for the first few columns of the row (for Comp1), but I don't know how to...

reg 18234 (5/3/2010)

---

The SQL statement below returns what I want for the first few columns of the row (for Comp1), but I don't know how to pick up and list...

On second thought, maybe we don't want the full text of your view.:w00t:

Select GetDate() will always return the current system date and time.

The concept of "when the record was...