Query With no ID - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Query With no ID

Author

Topic

soonerX
Starting Member

16 Posts

Posted - 2007-05-16 : 02:11:05

Heres what I posted and no response so I will see if anyone has better solution.
I have table that has inventory and table that has ticket history
So data may look like this

ITEM# STATUS AVAIL DATESOLD
A1 S -1 5/2
B2 S -1 5/2
A1 R 0 5/4
B2 R 0 5/7
C3 S -1 5/7
A1 S -1 5/7
B2 S -1 5/8
D4 S -1 5/8
D4 R 0 5/8

If status is S and is -1 and older than 7 days I want to display that information only item number and status. As of 5/16/2007 C3 and A1 Would be that status. This DBTable does not have ID or PK to speak of.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-05-16 : 02:42:47

what is the datatype of DATESOLD?
Why didnt you use datetime datatype?

Madhivanan

Failing to plan is Planning to fail

soonerX
Starting Member

16 Posts

Posted - 2007-05-16 : 02:53:49

DATEsold is datetime. which there is actaully 2 other fields that I could reference or join to.. A TIK_DATE and TIK_TIME date.. is 5/7/2007 12:00am format.. and time is the 1899 3:30pm time

soonerX
Starting Member

16 Posts

Posted - 2007-05-16 : 12:57:18

pleaase close topic..
answer in
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83622

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources