For example, i have been thinking in 2 solutions about it: (1)- Loop while @i<=@n begin insert table1(field1,field2) values(value1,value2) select...
Thank's guys! shashikant, i will make some test about your code concept. adriaan, i know what is all about when you make a loop this way, but maybe...
I just wanna fired my trigger 'n' times using a set-based operations like INSERT / SELECT. I think a solution like 2 can work faster, but in other...
Ok, i think i can understand your point, but i'm working only with Sql query analizer, i have not front end like an Access program. I have to do all...
Please dear friend, read the problem from the first post. Here it's: ------------------------------------------------------------------------- Dear...
Alzdba, you right, a beer is a good idea sometimes after work! <br />Ok guys, we can continue our conversation in english, but i'm still with this...
Exactly, FrankKalis. So, what can i do to fired 'n' times a trigger in a set-based operations ? Thank you.
Hola a todos, tengo el siguiente problema: Cuando hago: while @i<=@n begin insert tabla1(campo1,campo2) values(valor1,valor2) select @i=@i+1...
Dear friends, i need to know how i have to do to execute a trigger 'n' times when a execute a command line like this: insert table1 select *...
Error: Forgets pk_1 and pk_3 indexes and keep pk_2 index. Thank you.
ok, Satya. I think you need to see if those indexes can help you: create index pk_1 on tblpayment(transno) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING...
Satya, can you show PK field on tblpayment, tblpaymentworkrepost and tblworkreport table ? Thank you
Satya, can you show PK field on tblpayment, tblpaymentworkrepost and tblworkreport table ? Thank you.
Satya, can you tell me if your tables tblpayment and tblpaymentworkreport have PK on transno field? And, what about tblworkreport and...
Yes Satya, the order in which the colums are placed while creating an index have an affect on performance. I think you have to add or re-define your...
Satya: Why you use this index structure ? Can you change it ? Try with a index structure where field TransNo in index TBLPAYMENT and field...
ADRIAAN suggest something good to do, do you had good result with this tips?. Tell me about your experience. If you obtain good result the problem...
Hi Satya! I'm searching about the query analizer cost behavior. Can you show me the code pls. Thank's
Thank you, satya! I will read this and then i'll send you my opinion about it. See you around!
Hi friends! Anybody can tell me if knows what is the the formula or calculous that use the SQL Query Anayzer to calculate the Execution Plan Cost ?...
Separate names with a comma.
