Database

ramina sen wrote: I am using procedure as I have to collect all the parent I get from the inner query, How about putting that into a temporary table and work with that? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

VishwaKL wrote: is this style of query takes less execution time ? Less than what? You'd need to measure the performance of this query against the query you want to compare it to. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

I suspect the whole concept of defining a page length based on the number of rows is wrong. What happens if you reduce the height of the rows slightly. Page size has a defined length and each element within the page has it's own dimensions (rows, header, footer and groups) all of which affect the placement of the data relative to the page length. Never underestimate the power of human stupidity RAH

correct, but as I have mention my inner query is giving me only parent but I want to make use of the result of the inner query again as input till I did not find any child ,so I am using procedure as I have to collect all the parent I get from the inner query and then update the outer query using the inner query result.it is the requirement what I want to achive, e.g update table A set A.a as "xyz" //here I will get t where A.id in ( select A.child_id from A,B,C --I get the child by passing parent as input and again consider the child as parent and find the child where A.id= b.id b.name = x and A.prent_id = ? //few join condtion here ) e.g input 1 result 1.1 input 1.1 result 1.1.1 input 1.1.1 result 1.1.1.1 update A where A.id in ('1.1','1.1.1','1.1.1.1')--here I want to use a container and make use of it Hope you get my intention now ..Thanks for your response.

Check this[^]

actually i was just transfering the system to another server by imaging procedure without making any change..but still yet cannot make authorization access..because the system is not develop by me..the vendor itself have made it.But the maintainance period is over..so i want to know exactly the problem by myself. ;)

Caveat I have not worked with Access for a decade or more :-O I would add a calculated field to the table/view called ShiftNo - function is obvious. Calculate the shift and then group the report by the ShiftNo. Your query changes from a simple select to a grouped query. (not sure what the terminology is these days in Access) Never underestimate the power of human stupidity RAH

Thank you so much for the draft. I will work for it. i hope i could do these multiple seatmap. i need it do be done soon. Thanks a bunch.

mrkeivan wrote: How can I declare a Variable so I dont need to use it over and over again? You use a stored procedure. This is the direct answer to your question. But I don't really get what you're after, can you elaborate? Wrong is evil and must be defeated. - Jeff Ello[^]

Thanx, I will check it out

Hi there, I was able to sort this out using an function. Funtion takes the values from each row and calculates my requirement and populated as separate column.

Chris Quinn wrote: The servers are all behind the same firewall And you are positive that that statement means that the traffic in fact doesn't go through the firewall? (Versus firewall rules that 'should' allow it to behave as though the firewall wasn't impacting it.)

Hi, You can use SELECT with the same method you used to get the above results. Please find this site http://www.avatto.com/ which is good for any database related queries... :)

Change this: Member 10263519 wrote: command.Parameters.AddWithValue("@member", txtuser.Text); To this(remove the @ as it is not required from .net): Member 10263519 wrote: command.Parameters.AddWithValue("member", txtuser.Text); “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

Wow Thanks for the optimization tips! I do need to expand my knowledge here and use the tools right. I'll play around with the TSQL in SQL Manager to see the various results and read the lessons. The temp table was cool to know, but if it can be done without it, then better.

You are welcome. Please do one thing, according to CP instruction : "If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you." Thanks.

Update the original question and the title to indicate that your issue has been fixed. Also, please describe your fix.