Hi Ron,

quote:

---

We create the NT Groups, assign the groups to SQL Server with the permissions needed by the groups. The users...

Hi Mani,

quote:

---

Here are three statements

1.SELECT A.RetailPrice * F.salesQuantity FROM StockDept A .....

Result 29.989999999999998

2. select round(29.989999999999998,2)

Result 29.990000000000000

3.SELECT round(A.RetailPrice * F.salesQuantity,2) ...

Hi Nelson,

quote:

---

What I'm doing is.

other server creates a TXT file from all records and save it as ex: file name 07300300.15S, so...

quote:

---

Ex: suppose the number found is 15

so I need it understand 15.S

---

so, you have...

Hi Nelson,

quote:

---

I have this command line and I need said that '@@' can be any number between 01 and 99

how I do...

quote:

---

Sorry Frank, is that better.

---

Hi David,

that's an inherent error in the forum software, it...

quote:

---

Yes, I have full permissions on SQL 7 server.

---

ok, I guess someone else will come...

quote:

---

Yes, the value is <> 0

this is the hardware situation.

Server A: windows 2000, SQL 2000

Server B: windows NT, SQL 7

---

quote:

---

about 74000 rows, but I get timeout when I execute the query.

---

not that much, did...

quote:

---

The query is just a simple "Select * from [SQLserver7].database.dbo.table".

---

How many rows are to be...

Hi qwerty,

quote:

---

I have performance problem when I create a select from sql 2000 into sql 7

How can I solve this problem

---