Search results for query: *

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

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

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

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

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

Should be simple enough I thought... I will provide the full scenario because I'm not sure if a solution would be simpler on the database side or the Webfocus side. Data was exported out of a PIC database into .csv files which were pulled into SQL Server 7 via DTS. There is an ODBC connection...

Please assist if possible... I created a model that has a lot of dimensions. The cube ran fine and updated with scheduler daily for approximately 2 months but now it wil not refresh through scheduler and I cannot open the pyi file to view or make adjustments or refresh manually. The error is...