I can't imagine why in the world you want this "format". Of course formatting really belongs in the front end and not in sql but you can do it. You...

Do you mean can you open an Access table from sql server?

The difference is huge. Dynamic sql is simply building a executing against your database. This is open to sql injection. Parameterized query is using variable to hold the values for...

Are you familiar with tally tables? If so you can tape this together fairly easily. You can read Jeff Moden's article about them here. http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/url%5D

I am think you could...

Wow reading through that it looks like it could a total rewrite. There are just dozens and dozens of calls to the same scalar function. It inserts detail rows then...

Aha!!! So what you really want is to modify this proc to show the last x years?

What is that total row? It is kind of total line but not at the same time. There seems to be a lot of information you are not providing.

Duplicate post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1241027-392-1.aspx

To truly get your five years of data you will need to use a calendar or a tally table. If at all possible you might consider changing your datatypes for...

It is pretty hard to tell what your desired output should look like. Can you provide that in the format you want it in instead of an insert? If we...

Reading your post again I think you are asking how to retrieve data from 2 databases at once? You can query across databases quite easily. If they are on the...

You can't. That requires multithreading which a single query window in SSMS does not do. Why do they have to run at the same time? Unless you do something like...

Just use datediff for that. http://msdn.microsoft.com/en-us/library/ms189794.aspx

What about something like this:

TranSeqTranTypeTranAmtTranPeriod

12-100

21100

32-100

Here is what I mean by a tie. Now which one would be the correct match?...

Wow that is nasty.

I get what you mean about the transaction period thing but "inside out". That is pretty ambiguous. Do you look first for an earlier one and...