Search results for query: *

Thanks mutley1, after further research I cannot find a tie to -Y. I did find a couple of articles where folks had encountered the same issue and could not find a workaround. I did see something about BCP, but I would like to keep this as simple as possible. If anyone has any other ideas pls...

Greetings, When exporting qry resuts to CSV one column is so wide it wraps to the next row and the columns after it. Is there a way to 'force' all columns on one line? or a format besides csv that I could export to? Here is my batch code... C: cd Program Files\Microsoft SQL...

Greetings, I have been given a report that contains 2 report tabs and a 3rd tab containing several graphs. The first 2 tabs of the file are generated weekly out of a Business Objects (BO) scheduled export to Excel. The 3rd tab is something upper managament slammed into the Excel file and they...

Thanks for all the help, will take a look see. Thanks, cgh

Thanks guys, Here is the basic code snipped prior to exclusion... IF DATEDIFF ( d, calldatetime , getdate()) <= 2 Biz Days then delete from temp table If a Sunday falls between the startdate and enddate I need to not count the Sunday. Thanks again, cgh

Greetings, I have a situation where I need to check if a call occurs between 2 dates. This is easy, the problem I am having is it needs to consider business days only which in my situation would exclude Sundays. So if it was Monday morning and a call had occurred Saturday morning at the same...

Thanks Markros, any ideas on how to get the columns to autofit in the CSV? :) I won't press my luck. Thanks again for your help! cgh

Greetings, I have a SQL 2000 (I also have 2005) qry file that runs through several steps. The qry file initially creates a table with a key column and several empty columns and then runs through a series of inserts. At the very end I execute a qry that rolls it all up into the view I need. I...

Greetings, Thanks in advance for your time and help. I have a sheet containing data in tabular format in Excel (2003) that I am using as a data source for another worksheet in the same workbook where I have calculations (product formulas mostly). At the top of the latter described sheet I...

Greetings. My sincerest apologies if this is not the correct forum. I am trying to get my Website up and running. We are hosting using .MAC, but our domain name is through another company. We have 2 domains www.abc.com and www.def.com that should point to the same Website. The site...

Groovy Skip, thanks a lot! Will use code tags from now on. Thanks again

Greetings, Many thanks in advance for your help. I have a report template in Excel and I added a button with macro that copies and pastes the desired portion of the template to a new Excel file. My question is how could I automatically save the file per a value in the template and the file...

Greetings, I keep getting a no lock error and it is very frustrating. The same code runs fine, normally. It seems like this issue occurs during peak times likes beginning of the month when reports are due across the company. Here is the error. Server: Msg 601, Level 12, State 3, Line 146...

Thanks to everyone for the great response!

Greetings, What is the best way to check to see if a temp table exists in SQL 2000? I have a step that creates the table and would like to programatically handle the drop/create. Thanks for your help, Cary

Thanks SQL Sister, Sorry my initial post was a bit cryptic. I am not getting an error. No records are being returned. If I need to start a new post I will. Since SQL Sister replied I am continuuing this thread. Please let me know. Thanks again for your help.

Well I'll be if I didn't use like and it worked fine. Is there a way to use the '=' and not use like?

I am having a similar issue. The where clause will not accept the variable I am feeding it. If I hard code the value in the where clause everything is ok. declare @employer nvarchar set @employer = 'ACME' select * from #BOP_Member where employer = @employer Thanks much for your time and help!

Thanks Charlie, Yes, the owners are different. I have recently become the administrator of the db and the tables that are working ok were created by someone else. There is one record in the test table I created. Thanks for your help.

If you could store the Excel doc on the network or centralized location you could link to the Excel document from the Access tables section (in table view, right click - link tables...) In your form set the Record Source to the linked table and display objects/fields as needed. Hope this helps.