Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mSolver
  • Content: Threads
  • Order by date
  1. mSolver

    Reading dirty cells from Excel using ACE driver

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

    Unique nonclustered Index (more than 16 columns)

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

    User Defined labels for UDF columns

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

    Question on friendly db connection approaches

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

    Dynamically creating a view

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

    Background worker

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

    Join table to itself to get YTD balance

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

Part and Inventory Search

Back
Top