Excel LET Formula for creating small values tables from a table or range
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
2022-04-06 (first published: 2022-03-29)
479 reads
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
2022-04-06 (first published: 2022-03-29)
479 reads
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
2020-12-07
Learn how to format your SQL Server results in Excel using conditional formatting to quickly identify patterns and issues.
2020-03-10
Transform your query result into an Excel file using this technique.
2018-03-05
6,574 reads
This time we will show how to access to Azure SQL Data Warehouse using Excel.
2017-12-19
504 reads
Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.
2017-09-22
6,233 reads
What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.
2017-06-30
5,930 reads
In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that it should be easy to get the data into PowerBI so it can be made more generally available for sharing and further analysis. As well as the data, we'd probably need the other analysis components such as the Power Pivot tables, Power View visualizations, Power Query queries. It is all possible, and Robert Sheldon demonstrates how.
2016-12-28
2,896 reads
Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.
2016-02-05
4,291 reads
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers