If you just want to copy the structure you can generate sql script using the enterprise manager.

Pay Respect to People on your way up. For you will meet the...

quote:

---

SELECT @changeday = dtechngDateStamp, @thisday = dteDateStamp from tblapptrans

---

I think you are selecting all...

It seems that other users can access your records from the transaction table when they are in the process of being saved. This can only happen if the transaction isolation...

Please follow this link and check if this helps you out.

http://www.developer.com/tech/article.php/724711

Pay Respect to People on your way up. For you will meet the same People on your way down.

quote:

---

but be aware that a group by on a date field will work well if your field is populated just to the...

It seems a to be the correct way, since you need to validate at the row level.

The trigger will take care of the updations that are done from the frontend...

Thanx mark. I tried Your solution and it worked out.

Pay Respect to People on your way up. For you will meet the same People on your way down.

If you want to return min, max and avg for each date then use a group by function

i.e. group by date_time.

Pay Respect to People on your way up. For you...

Just by curiosity, In what cases would I need to move tempdb files. Isn't the TEMDB recreated once sql server is restarted.

Pay Respect to People on your way up. For...

quote:

---

Hi,

I have written a query below to do it but it is not calculating the amount properly, it is producing a massive...

Just execute statement on the query analyzer and copy and paste the output.

Pay Respect to People on your way up. For you will meet the same People on your way...

At one look the Query Seems ok.

Can U paste some sample data for the tables.

That would be helpful.

Pay Respect to People on your way up. For you will meet the...

Have you tried keeping Sets implicit transaction mode to on for the connection.

Command is SET IMPLICIT_TRANSACTIONS ON

This way you will need to manually rollback or commit a transaction

else...

You can do so by running the queries from the front end e.g. vb 6.0.

How I did was :

1)Connected to the database of my choice.

2)Executed the statement set showplan_on on...

Try this

sample data from northwind

select a.customerid,count(orderid)

from customers a,orders b

where a.customerid=b.customerid

group by a.customerid

Did it help?

Pay Respect to People on your way up. For you will meet the same People on...