Search results for query: *

I have a date that I am wanting to convert to a Julian date to match up with another field that is stored in another table. I am having some problems seeing how this function from Novick Software works. CREATE FUNCTION dbo.udf_DT_ToJulian ( @Date datetime -- Date to convert to Julian...

I have a function that I am calling in a subfomr. I am getting the error: Insufficient number of arguments were supplied for procedure or function. When I run this in SQL it returns exactly what I want with the exact same parameters that I am entering in Access. Please help. Thanks

Problem, I am prompted twice for the same parameters. It makes sense because both sprocs are using the same parameter information but it would be nice to find a way to pass that parameter so the end user does not have to enter it twice. History: I have a form that is populated with a stored...

This may be a crazy question, but I have been beating it around in my head for days as to how I would possibly do this. Is there anyway to convert this into a view with a given date range that will change on execution of form? Maybe there is a way that we can get this into a view, but I am not...

I have this query which sums the hours and gross earnings. I want to add TtlHours and TtlGrossEarnings to this same view but I am not sure how to do it. Seems like I should be able to do something like SUM(SUM(phptc.hours)) AS TtlHours being that is what I want as a result. Here is the query...

Hi, Does anyone out there know of a way to search a database for tables for a specific field. Right now I am looking through these one by one and it is getting painful. I know there are tools out there for doing this in sprocs like sp_search and sp_search_code but these are just for stored...

This is probably out there somewhere but with the search functionality not working it makes it a little difficult. :-) I have a form in MS Access that is being populated by a stored procedure which is passing two parameters to the database. One is smalldatetime (@EnterCheckDate), the other is...

This may already be out there but the search is down right now and I am anxious to find out what I am missing. I am sure that it is something small. I have a sproc that I am wanting to create an input parameter for but I can not get it to accept a LIKE where clause when executing. Currently...

I have a balance sheet that I am trying to recreate and am having way more trouble than I should with trying to get the data to return correctly. This is the only piece that I am missing. This balance sheet is made up of several subreports that are not linked to one another. It looks a little...

I am not sure why I am getting this error. Everything ran fine until I added the DECLARE and the SET statements for @GD. Please advise Thanks. DECLARE @InvDate datetime DECLARE @DVar int DECLARE @GD money SET DATEFIRST 1 SET @DVar = CASE WHEN DATEPART(dw, GETDATE())= 1 THEN -1 ELSE -1...

I have a field (CustomerName) that also contains a store number. So it would look something like this: CustomerName#StoreNumber I need to display these items as separate fields. I have been using a combination of string functions in SQL but am not having a lot of luck. I want to display...