Search results for query: *

No the worksheets will be protected so that only entry in specific cells is possible. So I hope this is not an issue. I am going to try to write changed cell references in memory instead of a hidden sheet. I just dont want to end up with something slower than what I have now. Thx, M

Thanks for the feedback guys. We are going to try the worksheet_change event to see how that pans out. Thx again, Mike

Thanks for the feedback. I was hoping to use the "Dirty" method within Excel to determine which cells need to be stored back to the DB. Excel uses this method to determine which cells require calculation so I am trying to find a way to use this to my advantage. This is a rather advanced COM...

Greetings all, Not sure if I have the best forum here as this is an Office development question. I have created a shared add-in for Excel which uses the MS ACE driver to read data from Excel and store back to SQL Server. I am using the ACE driver because it seems it is the fastest method of...

Thanks, the columns are dimensions related to the fact data and are required to be separate fields. Dimensions, such as time, Account, Entity, Department, currency, etc, all related to ERP's (Accounting Systems). In addition to ETL from many data sources, there will also be input coming from...

Greetings, I have a fact table in a ROLAP style db which references several other tables (Dimensions). I have 17 columns in this fact table that I need to create a UNIQUE NONCLUSTERED Constraint on, but the maximum index size is 16 columns. My first thought it to create a concatenated...

Greetings, I am designing a database which requires some of the fields in the transaction table to be defined by the “customer.” I have four UDF (User Defined Field) [UDF1 – UDF4]. There will be a user interface to specify the labels of these UDF fields. I could control these labels in the...

Not sure if I have the right forum for this question but thought I would give it a go. I am working on documenting a new Excel 2007/2010 add-in which connects to a SQL db. The end users will be non-technical. The requirements are that user authentication will occur via Windows Active...

Pure genius George! Thank you for the detailed response, this is far and above what I was hoping for! Regards, Mike

I need assistance with writing SQL for a view in SQL Server 2005/2008. For this task, I have two tables “table1” and “table2.” I am trying to come up with a procedure to dynamically create a view. There are two challenges. 1. I don’t want to include the key and 2. There is a User Interface...

Thanks Bluejay, that is exactly what I was looking for, it did the trick. Thx Mike

Hi all, my skills are novice at best when it comes to VB, so hope someone can lead me in the right direction. Within a simple app, I have a process which returns results for a few select statements on a SQL DB and then runs a procedure. For each step I am attempting to update a listview...

I am taking a different approach to the query just to show what i am trying to accomplish. I included two sample tables, the query will show the correct YTD sum for the first dataset. However, the query does not work for the second data set. The second set is a more realistic example. The...

Thanks drlex, my apologies for not detailing my challange. The result would be a single column amount. The way it currently works is that the ETL which contains this query loads another table. The period that is displayed is the current months period. So in my previous example if you have 2...

Thanks for your response PDreyer, not quite what I need. With your example data, I would expect that for each period, the total for all previous periods is returned. Example: If each month had 2 transactions, i would expect to see 2 transactions for Jan, 4 transactions for Feb, 6 transactions...

Hi, I am stuck on a query. Perhaps someone here can shed some light on a possible solution. I have a financial table which contains monthly transactions. I need to create YTD balances from this table. I am doing this by joining the table on itself to that for each month, all transactions are...