Viewing 15 posts - 61 through 75 (of 110 total)
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...
He who knows others is learned but the wise one is one who knows himself.
August 22, 2003 at 3:00 am
quote:
SELECT @changeday = dtechngDateStamp, @thisday = dteDateStamp from tblapptrans
I think you are selecting all...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 11:27 pm
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...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 11:06 pm
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.
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 10:54 pm
quote:
but be aware that a group by on a date field will work well if your field is populated just to the...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 10:28 pm
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...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 10:26 pm
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...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 6:00 am
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...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 5:11 am
quote:
Hi,I have written a query below to do it but it is not calculating the amount properly, it is producing a massive...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 4:54 am
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...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 4:36 am
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...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 4:20 am
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...
He who knows others is learned but the wise one is one who knows himself.
August 21, 2003 at 12:00 am
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...
He who knows others is learned but the wise one is one who knows himself.
August 20, 2003 at 10:55 pm
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...
He who knows others is learned but the wise one is one who knows himself.
August 19, 2003 at 6:25 am
Viewing 15 posts - 61 through 75 (of 110 total)