That's ok if you can't (or don't...

Another option:

SELECT ItemCode, SUM([Total Sales]) as 'Total Sales'

FROM(

SELECT T0.ItemCode, SUM(T0.LineTotal) as 'Total Sales'

FROM INV1 T0

WHERE...

As Sean said, datetime data types don't have format. If you define your column type in your flat file connection, and insert the value in a datetime column, you won't...

Nice Nevyn 😉

To be honest, I'd prefer your option over mine, but I wanted to avoid dependance on the schema in case that someone can't create new tables.

Yours is simple...

Would something like this help?

I included some commented code to help you to test.

DECLARE @str varchar(100), @str1 varchar(120) = ''

SET @str = '11111111112222222222333333333344444444445555555555666666666';

WITH E1(n) AS(

SELECT 1...

I might have overcomplicated this, but it might be worth it. Unless someone else comes with a better version of this. If you want to go further, you can generate...

The problem is that OBJECT_NAME expects an int value and l.resource_associated_entity_id is a bigint.

Maybe changing the last condition would solve the proble, but I'm not sure if it will give...

These articles might help you:

Hierarchies on Steroids #1[/url]

Hierarchies on Steroids #2[/url]

What's the type of your begindate column?

For performance advice, read the following article: http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

There might not be any need to go to SSIS.

If you have some kind of primary key, you could use it to generate all the files with a cursor.

DECLARE @id...

If you have more than one level, you could use a recursive CTE.

create table #Parent

(

PKint primary key not null,

Descrvarchar(10) not null,

Reference_PKint ...

There's still nothing I can do to help because I don't understand what do you need. You said something about an update, but there's nothing there that could be modified...

There's not much we can do for you. You didn't share the stored procedure, you just copied a select statement. We don't know your environment and the requirement is unclear.

If...

I'm not sure what would you consider simple.

If you're able to store your xml in a table without the xml, you could easily update the table. The problem with this...

Thank you for the feedback. If I'm not mistaken, you could select both. 😀