Hi Jeff,

Is there anything else required from my side please let me know.

tran_date is the column name for datetime.

All the columns present in table ara

snoint,

row_noint,

company_codevarchar(255),

tran_datedatetime,

acct_idvarchar(255),

acct_namevarchar(255),

tran_descvarchar(4000),

namevarchar(255),

tran_idvarchar(255),

srv_doc_idvarchar(255),

srv_typevarchar(255),

debitnumeric(28,2),

creditnumeric(28,2),

balancenumeric(28,2)

Row_no will be unique if u do group by acct_id otherwise it will not be unique. I have a sno column which will be unique overall. Yes there are few...

Hi,

Currently i do not have Primary key defined for table. But i created an index for row_no and account_id column.

I am unable to find in google hence posted here. Can you please suggest how it can be done.

Zipping using basic command available in windows.

DOT net cannot be used as company tools use sql server technologies. Henc it has to be done using xp_cmdshell command in sqlserver.

ok thank you will use the same......

Was trying the same with dynamic query and wanted to check it if is possible by doing the same. Those values are needed in variables for some other purposes.

Exact code used is this

Create proceduretest1

As

Begin

Declare@col1totalint

Declare@col2totalint

Declare@col3totalint

Declare @dynqrynvarchar(max)

Declare @counterint

Select@counter=1

While@counter<=3

Begin

Select@dynqry='Declare @col'+convert(varchar(5),@counter)+'total int'

Select@col'+CONVERT(varchar(5),@counter)+'total=SUM(col'+CONVERT(varchar(5),@counter)+') FROM Table1'

exec sp_executesql @dynqry

Select @counter=@counter+ 1

End

Select @col1total,@col2total,@col3total

End

But even if i declare and assign value after executing the query the...

I have following table structure

table1

(col1 int, col2 int, col3 int)

and i have procedure as which returns sum as follows

Create procedure test

as

begin

Declare @col1total

Declare @col2total

Declare @col3total

Select @col1total =...