You're welcome.

I hope that you've learned something from this. The main lesson would be that you don't need to count yourself because SQL Server will do it for you....

Local temp tables and table variables will loose scope when executing xp_cmdshell. Have you tried with a global temp table? Or simply creating a permanent table.

Here's my version of the code. I just added a column to your select. Be sure to understand how does it work and ask any questions that you have.

The startdate...

I haven't read all of Megha's code. I stopped at the function because that will be extremely unefficient. Check this alternative that uses an inline table valued function that will...

Why are you converting to datetime and then back to varchar? Why varchar instead of char?

SQL Server won't recognize the MMDDYYYY format as a valid date, you need to supply...

This could be accomplished without a loop using the modulo operator.

To get a coded answer, please provide DDL and sample data in a consumable format.

Equivalent in Oracle?

SELECT SYSDATE AS Datetype,

...

The RIGHT function is one option, you could also use STUFF function. Additionally, you could cast your result as a numeric data type.

However, the most important thing to remember is...

No, each instance must have its own port.

Are you using Sharepoint Services with Access? is that possible? or is that a different MOSS?

You can use cross tabs to get the results as desired. You can read about them in here: http://www.sqlservercentral.com/articles/T-SQL/63681/

I changed your query to make it easier to read (for me)...

This is one of the reasons to normalize our tables. To help you with this, I'm using a delimited string splitter (or I should say THE delimited string splitter). You...

It's a little confuse, but the problem is that you're returning the value of a function and not a row or group of rows. Would that make sense to you?

Yo need to remove the GO between both inserts. That's a batch separator and causes the variables to get out of scope.

Beware on the use of @@IDENTITY as it can...

You're welcome.

My recommendation would be to test both approaches. If both return the same results...