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.

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...

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...

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'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...

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...

Hello, I am using a case statement to determine if a date is null or not. Here is my code: SELECT *, length_of_service = case rehire_date when rehire_date is null THEN round(convert(decimal, datediff(dd, hire_date, getDate()))/365.2422,2) ELSE round(convert(decimal, datediff(dd...

I am trying to run a VB program but it gives me a Run-Time Error'-2147217871(80040e31)': [Microsoft][ODBC SQL Server Driver]Timeout expired error message. What can I do to fix this problem. Thank you.

Hello, I'm testing a VB program but when it runs I get a Run-Time Error '3265', Item cannot be found in the collection corresponding to the requested name or ordinal.' I'm very new to VB and I'm not sure what that error message means. Please help! Thank you.

What does the syntax *= mean in SQL? For example: WHERE phbasic.emp_id *= phfrng.emp_id AND phbasic.check_no *= phfrng.check_no AND phbasic.emp_id = empaddr.emp_id

Hello, I have a SQL statement that gets information from the previous month. It is scheduled to run every first of the month. However, if necessary, the SQL will need to be re-run after the first of the month but still get the same information. Currently, I have a dateadd(month, -1...

Hello, Yesterday, I posted a question concerning UPDATE. The solution presented to me was helpful, however, a new error has occurred. This is my query: update table set emp_id='???', empno='???', soc_sec_no='???' where (soc_sec_no='???' and emp_id='???' and empno='???') When I run this...

Hello, I need to update 3 columns on a table with new data. However, when I try to update the table with this query: update phbasic set emp_id='???', empno='???', soc_sec_no='????' where emp_id='???', empno='???', soc_sec_no='???' It gives me an error. I haven't done much SQL work dealing...

Hello, I have a batch job that runs an SQL query and puts the results into a txt file. However, at the very end of the txt file, it reads: (16 rows affected). Is there a way to get rid of that message as the SQL results are translated into a txt file? Thank you.

Hello, I am trying to get the absolute value of a float in my SQL query. When I run ISQL to run the query and place the results in a text file, the number still remains as a number with decimals. I'm trying everything to get rid of the decimals. Please help! Thank you.

Hello, I am running a test batch file that runs a sql query and puts the SQL results into a text file. In my query, I tell it to RTrim on all of the string columns. When I view the text file, there are still spaces that appear between the different columns of information. What is it that...

Hello, I am running a SQL query that grabs information from the previous month. For example, on August 1, I plan to run this query to get information I need for the month of July. "WHERE (((act_task.billable_time) Is Not Null Or (act_task.billable_time)>0) AND ((act_task.status_dt)...

Hello, I am currently using a Cisco 1760 router. I wish to access the Cisco Call Manager GUI that is built into the router. I followed the instructions on how to access the GUI, but when I try to access the GUI on the internet, it gives me a blank webpage. What is the best way to gain...