Lab Sql

Long story short, I'm taking a bunch of excel documents one by one, and importing them using th… Read more Truncation Errors Importing To Sql Server 2005 From Excel

I am trying to import a column of dates from a spreadsheet in Excel 2003 into SQL Server 2005 using… Read more Date Format Problem Using Ssis For Excel Into Sql Server

i'm trying to use the code below to copy data from a sql (2008 r2) table to multiple sheets in … Read more Excel Vba Copyfromrecordset Slows When Copying Over 100 Columns

I have requirement to create the DrillThrough Action in SSAS Cube. Along with we will give DrillThr… Read more How To Disable The Double Click Option For Drillthrough Action In Ssas Cube

I am trying to create a very dynamic macro that will update different tables in a Database, dependi… Read more Operation Must Use An Updateable Query / Sql - Vba

Is it possible to set foreign key between two excel sheets and query records from the two sheets? … Read more Is It Possible To Set Foreign Key Between Two Excel Sheets?

I have a series of three tables which I would like to join together using ADODB in an Excel VBA app… Read more Nested Join In Excel Vba (adodb) Results In "join Expression Not Supported"

I am trying to run node-mssql query, if I run simple quires it is getting executed. But when I use … Read more Error While Running Node-mssql Query