Thanks a lot. It worked perfect.:-P

Thank you so so so much. That's exactly what I want.:-P

I really appreciate your help.

Thank you so so much, that's exact what I want.

In fact the inner loop is calling a dynamic block of code to do the calculations for 28 measures, and I...

Thanks a lot, that's exactly what I want.

'Try this:

'Here's your recordset:

set rsp=objConnhc.Execute(sql)

'Then write the recordset to your CSV file, here's example MyFile.CSV

Open "MyFile.CSV" For Output as #1

For Each F In rsp.Fields

Head = Head &...

I like use datetime functions, For example:

SELECT *

FROM MyTable

WHERE  day(SubDate) between 1 and 31

      and month(SubDate)=3

      and year(SubDate)=2005

Hope it helpful.

S.

I always use .asp program to export data to .xml or .csv file. Works fine for me.

Thanks. They are really useful.

How about this one:

create table #tblA(ownerid int, status char(7),nocnt int)

insert #tblA(ownerid, status,nocnt) values (1,'yes',3)

insert #tblA(ownerid, status,nocnt) values (1,'no',2)

insert #tblA(ownerid, status,nocnt) values (2,'missing',2)

insert #tblA(ownerid, status,nocnt) values (2,'yes',1)

insert #tblA(ownerid, status,nocnt) values (1,'missing',2)

insert #tblA(ownerid,...

I think you can use this query do the same thing:

create table #mytbl(id int identity, mygroup char(1),mydata int)

select *

from #mytbl

where mygroup+cast(mydata as char(2)) in

(select mygroup+max(cast(mydata as char(2))) from #mytbl...

Go to ODBC settings, windows 2000 it's under control panel, administrator tools, ODBC, Click Trace, Click Start trace now, But the most important thing is remember to stop tracing, Tracing ...

Make sure NDW2 is your linked server. And you forget keyword from, try this:

select * From OPENQUERY(NDW2,'SELECT * FROM NORSNAPADM.SALE_CHNL_ITM_LINK') AS T1

Question Detail:

Kenneth Wilhelmsson's explaining is correct and more cleaar. The A column's value doesn't matter, if there's a value, leave it, if...

Thank you very much, I appreciate your help. And another thing is how can I back up all the stored procedures, I can't find any refers to put SPs in...