Makes you wonder what the purpose is and English certainly not being OP's...

ChrisM@Work (9/14/2016)

---

It's the Right Stuff:-D

😎

Quick suggestion

😎

BTW DON'T USE the FORMAT function!

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @LINE_TEMPLATE VARCHAR(50) = '000000000 ...

Jeff Moden (9/14/2016)

---

Although that's great use of the CROSS APPLY trick to unpivot, the output isn't the same as the requested output, which appears to be a sum for each...

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 ...