That is normally the...

Slightly different syntax but same results (and identical execution plan)

😎

SELECT

E.id

,X.STATE

,X.VAL

FROM #Example E

CROSS APPLY

(

SELECT...

SQL-DBA-01 (9/13/2016)

---

Hi All,

If I need to find out an user account present anywehere in the SQL instances (say, login, jobs, repl agents, db owners, AlwaysOn groups), how to find and...

Further on Jeff's fine answer, here is an alternative which should work if you cannot store the numbers generated, I have used this method to generate 10^10 rows without any...

You are very welcome.

😎

If you have any problems just post it on...

Whether you use a 3rd party tool or not the challenge is the same, the columns must be manually mapped to elements within the XML as the element names differ...

Quick thought, alias the table in the select

😎

BEGIN

--INSERT row OF CURRENT emp

INSERT INTO [dbo].[EMP]

([empid] ,[fname] ,[lname] ,[dept] ,[active] ,[ext] ,[date_effective])

SELECT

EE.empid

...

Quick thought, if you execute a script like you posted then it will run sequentially. To execute in parallel then simply have one task for each statement on the same...

Quick question, any scalar or multi statement table valued functions in the 3rd party code?

😎

Here is a quick suggestion for a query to create the desired XML output

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.SSIS_TblImageViewerXML') IS NOT NULL DROP TABLE dbo.SSIS_TblImageViewerXML;

CREATE TABLE [dbo].[SSIS_TblImageViewerXML]

(

[StackNumber]...

Here is my ailing old work station

😎

OS Name Microsoft Windows 10 Enterprise

Version ...

J Livingston SQL (9/10/2016)

---

6th Generation Intel(R) Core(TM) i7-6700 / 16GB DDR4 /2TB 7200 rpm Hard Drive + 32GB M.2 SSD Cache

Microsoft SQL Server 2016 Developer Edition (64-bit) on Windows...

WayneS (9/9/2016)

---

J Livingston SQL (9/9/2016)

---

feeling pleased (for the minute!)

off the shelf tower.....

6th Generation Intel(R) Core(TM) i7-6700 Processor (8M Cache, up to 4.0 GHz)

16GB (2x8GB) 2133MHz DDR4 Non-ECC 1 SR

2TB...

Alan.B (9/9/2016)

---

I just spent 5 minutes trying to figure out whey this INSERT statement was failing:

CREATE TABLE dbo.MyTable

(

SocialAdvertisingDimAdKey int IDENTITY(1,1) NOT NULL,

...

Thanks for this, now the only thing missing is the exact format of the XML, can you please post an example?

😎