No, not even from sql server analyzer, it just refuse any connection from any where. But if I get into enterprise manager, -->tool, -->sql ananlyer, the query can be run...

I got it. thank you.

Betty

yes, you are right. Actually I didn't do anything yet.

If I did, I would brought more problems since some of auto data or system assigned data are created based on...

do I have to list all table column name like this:

Insert into table1_name_temp (value1, value2...)

Select * from table1_name where ....

Because there are many column/

Betty

RGR'us,

Just some of the tables, only new data within specific period of time.

Data must be inserted into production database, no data need to be deleted or updated

Thanks.

Betty

I don't really know what happened after they applied sp4 to my sql server 2000.

I told my myself, I need to take a look at...

I don't really know what happened after they applied sp4 to my sql server 2000.

I told my myself, I need to take a look at my testing database, I suddenly...

You are really brilliant. Acutally I fixed yesterday and the case is exactly what you think.

I don't really know what happened after they applied sp4 to my sql server 2000.

I...

I checked  property in enterprise manager, on the security tab.

SQL server and windows mode is selected?

Oh, God what should I do?

Betty

Gopi,

got you. I didn't read the sp_executesql  definition.

I am very appreciated your help.

Betty

GRG'us,

for example, does that make any difference if @sql declare as varchar(4000) instead of nvarchar(4000), when you use 

exec sp_executesql @sql

will this dynamic sql statement works...

Thank you both. No wonder I saw some database setup script with a lot of N.

But I never figured out when we do need it and when we don't need...

Gopi,

Thank you so much for your post. I learned from you.

By the way, what is N for at the very beginning of your @sql variable.

I have been seen this N...

Hi Andrew,

Thanks for the posting, that code looks good to me.

But for '66666', it should include the sales from agent '12345' too.

What I like to have is

total sales for agent...

Hi,

I got it. I just forgot union.

(select count(product) numPol, product, sum(Cast((order_total/100.00) As Decimal(12,2))) txnSale, agent='66666'  from vs

where year(txndatetime)='2004'

group by productUNION

select count(product) numPol, product, sum(Cast((order_total/100.00) As Decimal(12,2))) txnSale, agentCode...