sqlserver

  1. A

    SQL Server Parameter transfer

    I am trying to update a record at SQL Server by using parameters. The VBA-code does not initiate an error, but the files at SQL Server Table are not updatet with worksheet data. Can anybody see what I am doing wrong? Description = Range("E42").Value Mitigation = Range("E51").Value...
  2. E

    Problem connecting SQL to PowerPivot

    Hi all, I am a frequent Excel user and want to learn about Power Pivot, as I will have to handle very large datasets. So I began to read tutorials and saw that SQL is very often a source of data. I installed SQL server 2012 on my laptop and wanted to begin working with...
  3. L

    Measurement in the Table

    Goal: Have a measurement for each PK_test row based on sum of all its quantity from productNumber. PK_test qty productNumber ----------------------------------------------- 1 5 asdf 2 4 asdf 3...
  4. L

    SP and Views in Tabular

    Is it possible to create some stored procedure and Views with DAX code in SQL server 2012 SSAS tabular?
  5. L

    Customized Table inside of VS project

    If you have a fact table that you have uloaded från SQL server to VS2010 SSAS tabular with this table and its data: Table A PK_test qty productNumber ----------------------------------------------- 1 5 asdf 2 4 asdf 3...
  6. H

    Inserting data from sqlserver to Excel and vice versa automatically ?

    The below code brings me data from sqlserver, however when im loading back I can only make changes to the first 3 rows on the spreadsheet. When I edit the 4th row I get he error "You can only edit items inside the table". Anybody knows a solution for this? :eeek: ' General variables we'll...
  7. K

    Want to use Excel2010 cell as primary key parameter for SQLSERVER 2008 query

    I want to use the Connection functionality in Excel 2010 to connect to a SQLSERVER 2008 database and populate column X based upon using a value in Excel column A as the primary key (loop thru the column), but unable to find out how. I have tried (typing in the command text window) select...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    • Replies: 49
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    • Replies: 37
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    • Replies: 35
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    • Replies: 35
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    • Replies: 30
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    • Replies: 25
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top