sql database

Hi all, I wanted to reach out to SQL gurus and ask a question. We had a vendor build a SQL database. They are now saying because of the way they built it they can not have the SQL database pull information from a Sharepoint list. The purpose would be to link comments from a SharePoint list to...

Hi, I have Data table which has data as shown below In this I need to get the "Component" data which are structured under "Item" and after that each component will be considered as "Item" and recursive CTE comes here. Please help me to sort this out. Sample Input: Sample Output in...

Hi, If anyone is familiar with SQL or Query (from Google) then one may be able to help me. I have this Query (which works)= QUERY(E12:G9620,"select count(G) where E = 'Engineering' and G like '%/%' or G <>''") Yet when I add date conditions as below, it does not work and shows (#Values!)...

Hi, I have data as: <tbody> id name value 1 A1 1 2 A2 22 3 A3 33 ... .... ... </tbody> How to export the data (Range:A1:C&i) to MS SQL server, to table called "test"? I know how to get/select the data from MS SQL: TAB DATA/Connections/Workbook Connections/Add... then just add...

I am relatively experienced in VBA coding, but I am totally new in MS SQL server 2008. I am trying to export an Excel table like below to a SQL server: A B C D E 1 Name Year ID 2 Jill 2015 17 3 Jack 2012 13 4 Mike 1999 25 5...

I am using SQL statements in VBA and I am having trouble joining 4 tables located in separate worksheets named "Stn", "Db", "Param" and "Ol" I have 4 tables: "Stn" with headers: Station_Name, Station_Abbreviation, Station_Order "Db" with headers: Station_Name, Sample_Date, Parameter_Name...

I've been searching the web high and low to help me explain, compare, and differentiate between data manipulation using various Microsoft Office tools. I've found many links and articles pre-PowerPivot and PowerView days, but cannot find anything more current. Please help me understand the...