I am curious what happens to the report once the user enters the information and the calculated column renders? Does this just come back into your database system somehow? It...

Not sure if you missed it but the sort expression is applied to the table (not the individual columns in case you were thinking that). You set here the column(s)...

I have to agree it is helpful to post the DDL create statements for the tables and include sample data in a consumable format

This is...

+1

But still as you mentioned "SSIS Help with flat text file issues" suggests that you...

Have a look at this:

http://msdn.microsoft.com/en-us/library/ms187569(v=sql.105).aspx

Have you tried running a full processing on the cube. That might work in the short term but take a long time if you have billions of rows. I think...

In

select @DT = start

from openxml ( @idoc, '/root', 1 )

with ( start datetime2 'start' )

Try changing the DATETIME2 portion to DATETIME2(0) to see if keeping the data type consistent...

How did you only pick those items with a count of 1 or 2 in the batch? Did you use a CTE /inner view ?

Thanks

Would the data only be for one specific date? To span it across multiple days it is a...

One interesting illustration you can do against SQL Server and Oracle is compare the results of a cursor to a triangular join, on each system. I think we all agree...

That would be worth one - two hours per month 🙂

The XML data type is not intended to be comma delimited, it is a different way of structuring data. So you are not able to pass the whole xml data...

Just for any one else interested, with an ETL issue like this you can add a Data Viewer to the data flow and see the rows thrown at the destination...

I think you mean to say that you want one variable to hold three values... and pass this to one method on the web service.

You can pass the values...

Where do you see the identity property for a column? I did not see it under sp_columns.