Lab Sql

At the start of ETL package the following SQL query runs against a SQL Server 2012 database: IF OBJ… Read more Why Does A Global Temp Table Created By An Ssis Package Disappear After Completion?

I just want a quick way (and preferably not using a while loop)of createing a table of every date b… Read more How To Get A Table Of Dates Between X And Y In Sql Server 2005

Compare the following stored procedures: CREATE PROCEDURE testProc1 AS SELECT * INTO #temp FROM… Read more What's The Scoping Rule For Temporary Tables Within Exec Within Stored Procedures?

I'm running into a problem similar to this question here (Display DataType and Size of Column f… Read more Sqldataadapter.fillschema With Stored Procedure That Has Temporary Table

I am trying to create a temporary table and insert data into the temp table within an Execute SQL T… Read more Parameter Mapping Using An Execute Sql Task

I am trying to reconcile the IDs in a temp table (top) from another DB table (bottom). Since I only… Read more How To Update Multiple Rows In A Temp Table With Multiple Values From Another Table Using Only One Id Common Between Them?

I'm trying to write a stored procedure that will read an Excel file into a temp table, then mas… Read more Using Openrowset To Read An Excel File Into A Temp Table; How Do I Reference That Table?

I have a stored procedure inside which I create a temporary table that typically contains between 1… Read more Sql Server, Temporary Tables With Truncate Vs Table Variable With Delete