1. Home
  2. Point-Of-Sale Software
  3. Automating HQ Worksheets

Automating HQ Worksheets

As far as I can tell, HQ makes no provision for scheduling worksheets other than the 401.

I searched the Google archive for this group and found part of a thread containing this little tidbit:

You must insert data into [Worksheet], [WorksheetStore], > [WorksheetHistory] and WorksheetItem for 250/260, and > Worksheet_ItemPrice, ItemCost... ItemTax for sales information..

I think I'd like to schedule a daily 250 worksheet and possibly a 350 as well.

Just to be perfectly clear, I'm closer to being an SQL newbie than an SQL expert.

I understand the query part. INSERT INTO Worksheet (Style, EffectiveDate, Status, Notes, Title, FromDate) VALUES (250,Today 6:30PM,2,'Auto 250','Automated Daily Item Update',NOW)

What I don't know how to do: Generate the date fields "Today 6:30PM" and "NOW" Schedule the query.

I've got SQL 2000 (as part of SBS Premium), and I am certain that I have the capability to do this. I just don't have the knowledge.

Thanks, Tom

Reply to
Terrible Tom
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.