Search results for query: *

Chance and Crowley thanks for your response, both suggestions are more than acceptable. However I just thought that there might have been a way to bypass SQL script errors.

This is my first real project in SQL, so I could do with some advice in the best way forward for future reference. I have created two SQL database's one live, one development. All the design work has been done on the Development Db, I now want to create the tbl's, views etc in the Live Db...

My aim is to open from a command, several SQL views exporting each individual view into it's own worksheet within one excel file. I then hope to create a report involving charts pointing to the data from the worksheets. My problem so far is that I can only insert the first View into the...

Yeah thanks for all the advice, I worked it out for myself (so I win a cookie!!). In the end all it required was for the dates to be surrounded by a single quote '01/10/2007' Easy when you know how. Thanks again Top Forum!!

After your latest suggestion Query now looks like this select vw.intVisitID,vw.FullName,Vw.dtmDateOfVisit From view_AllSchoolVisits As Vw Where (vw.intSchoolId =4) And (vw.DtmDateOfVisit Between #10/02/07# And #10/28/07#) Unfortunately when opening the recordset it says there is a syntax...

Again thanks for the advice. I added the format function to my Sub, so the Select Query to open the recordset now looks like this. select vw.intVisitID,vw.FullName,Vw.dtmDateOfVisit From view_AllSchoolVisits As Vw Where (vw.intSchoolId =4) And (vw.DtmDateOfVisit Between 10/01/07 And 10/31/07)...

Thanks for getting back to me. It's not as simple as that unfortunatly. I'm using an ActiveX Calendar Object to select the Dates to Query. When you click on the Date the value returned is in the dd/mm/yyyy format. It's curious that if my where statement is either =< 12/10/2007 or =>12/10/2007...

Hoping for some advice regarding an Access Form I'm designing. When I do a select query from Query Analyser the date field comes back for example 2007-10-12 00:00:00. Now when I run a select query from the front end using vb code, the select query is written with a where statement as...

Much appreciated for the help you have given me. The new script works as you suggested. I am however unsure as to why my old one didn't since the only difference I can see is that I declared variables.

As requested ALTER TRIGGER tr_InsertCR ON view_InsertCR Instead Of Insert As DECLARE @ReportID int; DECLARE @SchoolID int; DECLARE @OfficerID int; DECLARE @DateOfVisit smallDateTime; DECLARE @Hours int; DECLARE @Minutes int; DECLARE @Activity int; DECLARE @Funding int; DECLARE @Reason...

I was hoping someone could help me with a problem I am having. I'm pretty new to SQL programming, so apologies if this appears simple. Using Access forms as my front end, based on a sql view I create a record. I have an Instead of Insert trigger which then sends the form values to the table...

WUS is certainly alot more reliable than SUS. However I was wondering, in the Automatic Approval Options, when approving for installation, am I right in thinking that you are unable to tell workstations to install Updates, Service Packs and drivers, and servers only install Updates. Therefore...