VCDQuality Forums (http://www.vcdhq.com/forum/index.php)
- Computer and Audio/Video help (http://www.vcdhq.com/forum/forumdisplay.php?forumid=56)
-- SQL (http://www.vcdhq.com/forum/showthread.php?threadid=79510)

SQL

anyone know sql? i need help figuring out where certain boundaries are set. i didn't write the source, but when we commit certain information to the database, i can't "reset" it due to these restrictions.
let's say i have a field of numbers, namely 10000-30000. if we commit information to the db using a number outside that range, i can't recreate the process of deleting all information from all tables, reinsert it, then run all applicable rules. without seeing all the source, this one might be tricky, so let me know if you wanna take a crack at it and i'll pm you the source.

thanks.


edit:: i also have another unrelated sql issue: i'm trying to write a process that will return only values for the day i happen to query the db. my source so far is

SELECT "HPD:HelpDesk"."Assignee Login Name", "HPD:HelpDesk"."Case ID+", "HPD:HelpDesk"."Create Time"
FROM "HPD:HelpDesk" "HPD:HelpDesk"
WHERE (day("HPD:HelpDesk"."Create Time")>day(getdate()-1))
ORDER BY "HPD:HelpDesk"."Create Time"

the syntax check shows near the "WHERE" statement as being the issue.
error i get is "Expected lexical element not found". maybe some genius out there can get this one going for me 2.

__________________
just pretend i said something smart and funny...

I have only just started learning SQL but a bit of googling suggests your second problem lies with the getdate doo-dad

Thus http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=63511

ok so i made the changes they specify, but then i got the same error nukeawhale got. appreciate it though.

__________________
just pretend i said something smart and funny...