LOKNATH: Please read my previous post!

/* following code is called grouped data (which will produce only one row for each different status)

Select will return  STATUS, CNT, PERC as columns */

select S.Status 'STATUS', count(*) 'CNT',

(count(*)/(select count(*)...

Good question:

I would bet the column is an identity field, which is maintained (incremented at insert) by the database, but you can supply this value also if you set identity...

Use temporary tables for setting up your data muniplulation needs and the final selection should be directed to your Excel Object File for output.

You really don't have a technically hard problem, but just a very time consuming one!

I can give you some pointers I used in creating a multi-functional "DataLoad",

importing process I wrote...

Syntax

bcp {[[database_name.][owner].]{table_name | view_name} | "query"}

    {in | out | queryout | format} data_file

    [-m max_errors] [-f format_file] [-e err_file]

    [-F first_row] [-L last_row] [-b batch_size]

    [-n] [-c] [-w] [-N]...

This may also be a remedial point of view (if already known?).

I. Using ODBC connection (login, password, etc.) matching credentials.

II. Many methods exist for running stored procedures:

  1. ICommand:Execute using DBPARAMBINDINFO structures. ICK! ...

FTP can be tricky based on it's execution method, parent, permissions, security, and tasking.

One alternative method in providing standards and better security is to use a third party install like...

Steve:

Sorry for lecturing, and Kitkat is fortunate that you share your knowledge and expertise with this site!

I'm old school and avoid wizards like the plague. I encourage all programmers to understand the actual code...

Nice procedure to pass on to someone else, hopefully this person will be working under you, so he/she will not have to explain the reason for such an archaic and...

http://www.sql-server-performance.com/datatypes.asp

EXAMPLE:

Using front-end application to update and maintain journal free formated text...

Are suggesting that varchar be used with some kind of parser to retain returns and tabs?

Or could it not be...

SELECT top 1 F.FY, F.PERIOD, F.STARTDATE, F.ENDDATE

FROM FINANCIALPERIODS F(NOLOCK)

WHERE (SELECT MIN(E.STARTDATE)

  FROM EVENT E(NOLOCK)

  WHERE E.ARRANGEMENTNUMBER = @PARM)

BETWEEN F.STARTDATE AND F.ENDDATE

NOTE: @PARM is supplied variable

And if you want the...

Job security is doing a job which no one else can interpet or support; So most companies must throw out the work and start again...

A Better method is to keep...

RECAP: You have designed a report using RD and you can open this report in RM, and you have published it as well. But it does not export correctly to excel?

You may need to change methods and...