It is worth noting that the THROW "message" is fixed...

Best option would be to use T-SQL, it is simple and straight forward, here is a quick example.

This sample uses XML AUTO, by changing to XML PATH, almost any...

Here is a simpler and better performing version of the XQuery, where the XQuery does the leg-work instead of using a union in the TSQL part. The result set contains...

Quick questions:

A. how are you importing the XML files?

B. Do the files have as XML declaration tag (<?xml version="1.0" encoding="UTF-8" standalone="no" ?>)?

C. Can you post a more complete sample...

Quick thought, you can do some string splitting and concatenation, not too pretty but works

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

DECLARE @DATETIMESTRING VARCHAR(12) = '200508310926';

SELECT CONVERT(DATETIME,SUBSTRING(@DATETIMESTRING,1,4) + CHAR(45) +

...

In this case, my first suggestion is to use a staging table at the destination for the aggregation. Is that an option?

😎

Quick question, what is the data source and destination (file,table etc.)?

😎

hakan.winther (10/2/2014)

I agree with you. I Think it's hard to...

An alternative solution, not as efficient as QU but should be easier to understand

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @tbl table

(LineNum int,

Code varchar(2),

Amt money,

MaxAmt money

)

insert into @tbl (LineNum, Code, Amt, MaxAmt)

values

(1,'AA',10.00,50.00),

(2,'AA',20.00,50.00),

(3,'AA',10.00,50.00),

(4,'AA',40.00,50.00),

(5,'AA',10.00,50.00);

SELECT

...

Thank you for the question Steve.

Slightly off topic, prefer using RAISERROR to PRINT for progress reporting on long running scripts as it is almost instant and the printf functionality is...

Ed Wagner (10/1/2014)

Eirikur Eiriksson (10/1/2014)

Nothing much, QoDs been controversial, SQL Server will become...

Nothing much, QoDs been controversial, SQL Server will become Hadoop only, aliens are...

Quick thought, on 2012 this will work

😎

SELECT * FROM sys.all_sql_modules WHERE object_id = OBJECT_ID('dbo.MYVIEW')

SELECT * from sys.dm_exec_describe_first_result_set(N'select * from dbo.MYVIEW',NULL,NULL) as x

Congratulations Jack!

😎

Brilliant and well deserved!!! Congratulations Jason!!!

😎