Search results for query: *

Is there a convert function in Microsoft Access? I'm trying to convert a datetime of "mm/dd/yyyy" to "yyyy-mm-dd". Please help. Thank you.

I tried your suggestion and it worked but I do have another question. There have been times that I have setup recurring schedules for the same report using the current date and at one point the report only gets sent once instead of twice. Could there be something in my ePortfolio profile or...

I had the current day on my start date even though I told ePortfolio to run the report weekly on a different day. When the day comes to send the report, it gets sent twice. I will try your suggestion. Thank you for your feedback!

Hello, I have a question concerning recurring schedules in Crystal ePortfolio. Letely, I've been setting up recurring schedules for crystal reports in ePortfolio to be sent to email addresses. However, the email gets the report twice instead of once. So far in my experience, I would have...

What other condition aside from HAVING can I use to get the manager name?

I am writing a SQL statement to return any information based on one criteria. Here's my sample code: Select Resource_Name, Resource_Manager_Name, sum(weekly_hours) as Weekly_Hours from #Hours group by resource_name, Resource_Manager_Name having sum(weekly_hours) = 0 I am using the temp table...

Never mind. It works. I forgot to add the second table columns in the very first select statement.

The last left outer join did not go through. I got results from the first join only.

I ran the query and it gave me a: "The column prefix 'a' does not match with a table name or alias name used in the query." It directs to the first line of the query. I tried y.eid, y.tid, y.tc, y.ts and it produced results but it didn't left join with the other table.

I do not understand your last post.

I have another question. The results I got from the query from earlier were correct but now I want to left outer join those results to another table. Here's my query: ( select a.eid, a.tid, a.tc, a.ts from et a join (select eid, count(distinct tc) tcc from et where ts='?' and tid='STATE' and...

I have another question. The results I got from the query were correct but now I want to left outer join those results to another table. Here's my query: ( select a.eid, a.tid, a.tc, a.ts from et a join (select eid, count(distinct tc) tcc from et where ts='?' and tid='STATE' and (ytw > 0 and...

Yes, it worked. Thank you very much.

I'm sorry. I didn't provide enough information. In my original post I forgot to display another column that will be of interest: Employee ID Tax ID Tax Code 00027 STATE KS 00027 STATE MO I need to get those records where there are more than one tax code for the...

I'm trying to write a SQL query that will give me the records of those who have two different tax codes. Here is my query: select eid, tax_code from tax_table where tax_status='?' group by eid, tax_code order by eid For simplicity purposes, this is an example of a record that this query...

It worked! Thank you.

Hello, I just got back from Thanksgiving break so I was unable to use this code until now. When I implemented this code it gave me: "The column 'emp_id' was specified multiple times for 'a'." Could it because I did a left outer join in the second select statement?

This is what I have so far: SELECT *, length_of_service = case When rehire_date Is NULL Then round(convert(decimal, datediff(dd, hire_date, getDate()))/365.2422,1) ELSE round(convert(decimal, datediff(dd, rehire_date, getDate()))/365.2422,1) END...

Hello, I am trying to join a table with a result set but I'm having difficulty doing it. In my SQL, I left outer join two tables and get results. I want to left outer join these results to another table. Is there a way for me to do that or should I put the results into a temp table and...

It worked! Thank you very much.