Recent content by cfrench

Thanks, I was hoping there was a way in the application but this is a good idea. Thanks again.

Sorry... Impromptu 7.3

I would like to format my crosstab report that has qty product sales per customers per month. The issue is if there not any sales or a month, then it is omitted. This makes perfect sense but I would still like to display the months 1, 2, 3, 4, etc. instead of 1, 3, 6. Does anybody know how I...

The problem is, there are not any true null values in the image fields. Select null does not pull any fields. It seems that even if an actual image isn't present, there is still binary data in the field.

I have a table that stores images (bmp files) in a field (item.image) as an image type. In enterprise manager, all fields show up as binary. I have another table that has a field for the picture name (item_ext.picname). The pic name has some bad data in it where a pic name exists for an image...

to increase efficiency, would i be better to break my table up into components? Currently it is a sales reporting table that has customer name, order info, price/cost info, etc. I could probably break it into 2 tables but i don't think it will save that much space...

i have a sql server table that gets updated every morning from a csv file outputted by our legacy program (our consultants do this - not very well). Occassionally their program malfunctions and picks up wrong dates causing my database to import duplicates from the csv. What would be the best...

Good point, thank you. I'm a novice programmer and will have to do some homework on union queries but I think i have an idea on how to get started.

How could "connect" those tables?

Please let me know if this is possible and a reasonable procedure. Thank you in advance. I have a SQL Server table that we use strictly for reporting that is updated daily through a dts package and our legacy system. This table has gotten very large and slow to report on now that it has...

Never Mind - got it

Doe anybody know how to make an OLAP control panel open before the initial report runs? I would like to use the date selection option in the control panel before the report actaully runs otherwise i have to put in a date prompt that enables a parameter before the report runs but once in, you...

This happens when a user does not log off from dashboard. When they sign back in they need to hit the Cancel Session link and login again. Is there a way to bypass this step - maybe have sessions timeout or have the session automatically cancel when the username logs in again? Thanks in advacne.

I am using a DTS script by Darren Green (http://www.databasejournal.com/features/mssql/article.php/1461661) (thanks Darren!) to import multiple csv files into SQL 2000 database. In the first step, creating the table, I set the fields up with the format they should be and made my two date fields...

Got it. I re-imported the data into the database,, transforming the data in the process to represent datetime. Focus then recognized it as a date. Thanks everyone for your responses.