Query

Recently i optimize my Wordpress for performance with many tweaks like deleting useless tables from database. Installed WP-Super cache, etc. I was checking the error_log file in my Filemanager i was... To read more visit TheChetan.com

Hoy fue un día lleno de aprendizaje, que empezó con una query, que en su momento estaba funcionando de manera adecuada, sin ningún pero, al menos yo no tenia algún problema con ella y creo que ella tampoco conmigo. Todo iba muy bien, hasta que hace unos días nos cambiaron un servidor, sobre el que estábamos trabajado, o no se exactamente que cambio hubo, lo que si se es que el desempeño del

query mysql sostituire spazi con trattini

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. This error usually happens when you try to insert data into or update data in an Access database. It means that you don't have sufficient permissions to write to the database. If you are running the web server yourself then read the FAQ, Checking and Setting

I declared bankruptcy Jan. 05. I was discharged Nov. 05. I was told by my trustee, my student loans would not likely be `cleared`, even though I had been in and out of school from Aug. 93 through to May 05. 2 loans were held by RBC; My loans were an Ontario Student Loan and the [...]

Author: JijoSubject: Access/SQL Query Question-Find Newest RecordPosted: 22 Nov 08 at 6:05pmI think u can do this in a better way. But for that u need a primary key for this table. Or a field with a unique Id. What i would do is add a new field DWGS.Id which is an autonumber. Then i would find the Id of the record with the criteria u specified  select top 1 Id from tablename where D

Suppose that we have a list [10, 20, 4, 6, 9], and we want to write a sql query to get the data for all elements of the list, like SELECT * FROM students WHERE id IN (10, 20, 4, 6, 9) How to do that in Python? Actualy, it is very easy. Below are the list [...]

Author: msmith974Subject: Access/SQL Query Question-Find Newest RecordPosted: 19 Nov 08 at 7:00pmHello,I have an access database application with the following table & fields that I would like to query: Table Name: DWGSFields: DWGS.Discipline, DWGS.Area/Bldg, DWGS.DWGS, DWGS.DWG Number, DWGS.DWG Title, DWGS.DWG Rev Number, DWGS.Issued, DWGS.Date EnteredThe data types of all fields are Text Fie

Q : Bagaimana mengambil jumlah hari dalam suatu bulan di MySQL? Misalnya jumlah hari untuk bulan November 2008 adalah 30, Oktober 2008 adalah 31, dan seterusnya. A : Jawabnya ternyata cukup sederhana, gunakan fungsi LAST_DAY() di MySQL. Berikut ini contoh perintah SQL untuk mengambil jumlah hari dalam bulan sekarang (current date). SELECT DAY(LAST_DAY( NOW() ) ); Semoga bermanfaat

Introduction This article gives an idea as how to use Crystal report in .Net Windows Application with parametrized queries and Oracle as Database using dataset.I had searched on internet for articles related to Crystal Report with parametrized query with Oracle,but I was unable to find any good article on this topic.So I am posting my article on this topic. There are three main points in this a

Driver Query is a command-line tool (Driverquery.exe) that is designed to provide you with a detailed list of all the device drivers installed on a local system or on any system on a network. To do its job the Driver Query provides you with a series of command-line parameters. Of course, you can use the Driver Query command without any parameters, but using them allows you to get more specific det

Pemprograman C, Visual Basic, Java, Delphi dan lainnya merupakan pemprograman impetarive, yang berbentuk instruksi – instruksi inti. Sedangkan SQL merupakan bahasa pemprograman declarative, yang lebih berbentuk kalimat atau pernyataan. Dalam pengembangannya, SQL terbagi – bagi lagi dalam berbagai extension sehingga melahirkan berbagai sebutan seperti SQL/PSM (Persistent Stored Modules) yang me

What it can perform1.To speed up access to data by using multiple processes2.To maximise machine resource usage in query processing3.To reduce elapsed time by increasing resource usageOperations That Can Run1.Parallel2. Full table scans3.Fast full index scans4.Create index5.Create table as selectParallel Query Architecture1.Query coordinator parses the query and partitions work between the slaves

MIT has the most phenomenal reputation in Mexico, but the reviews are less hot with Sloan, it's bschool. Sloan is more like HBS or Stanford or it is...

When the database load increase rapidly it is even hard to log in Enterprise Manager (EM) to see what is the actual cause by seeing top activity or generating AWR report. Most of the time bad SQl is behind such problem. Here is a script which give you Top 20 (sort by elapsed time) SQL quer run on last 30 minutesSELECT x.sql_id,x.sql_text,x.users,x.executions,x.disk_reads,x.buffer_gets,x.cpu_time

LIS stands for Logistics Information System. It is the information systems used to plan, control, and monitor business events at different stages in the decision-making process. The Logistics Information System is made up of the following information systems which all have a modular structure: - Sales Information System- Purchasing Information System- Inventory Controlling- Shop Floor Information

&%NAME Name of user executing the query &%DATE Current date when executing the query &%TIME Current time when executing the query &%PAGE Current page number (output 6 characters)

Hostgator and Bluehost are our best webhosts and godaddy.com is the best domain registrar. This web hosting thread started by etogre on 15 October 2008 I need help organizing some tables an then generating the SQL to grab the data in the way I want. Discuss this at WHT or read more about bluehost and hostgator Similar Posts:Web [...]

There are a few things Janet Reid doesn't want to see in your query letter:1. ThemeI don't care what the theme of your work is. I care what the story is.2. I love to write I don't care. I only care about whether you can write well enough to tell a good compelling story.3. I think my book will make a great movie.I don't care. I only care whether it will make a good book.4. It took me x+1 years to

It is very similar to sub-queries where the parent query is executed based on the values returned by sub-quries. but when come’s to co-related subqueries for every instance of parent query subquery is executed and based on the result of sub-query the parent query will display the record as we will have refernce of parent quries in su-queries we call these as corelated subquries.so, we can define

Transforming rows to columns (PIVOT/CROSS TAB) and columns to rows (UNPIVOT) may be one of the common requirements that all of us must have seen several times in our programming life. SQL Server 2005 introduced two new operators: PIVOT and UNPIVOT that made writing cross-tab queries easier. My friend and SQL Server MVP Jacob Sebastian has [...]

Sometimes an Access database user needs to pull pieces of information from multiple table sources to display on a single form. For many users, this can seem like a daunting task. However, with a few tips and a little practice, you can learn to link database tables with little headache. The easiest way to accomplish this is to make use of the “Primary Key” option provided in MS Access. The Prim

In data pump export import we can use SQl query to filter exported/imported data.The parameter we use for this is 'QUERY'. But parameter QUERY requer proper formating (quotes)Incorrect usage of single or double quotes for the QUERY parameter can result FOLLOWING errors:ORA-39001: invalid argument valueORA-00933: SQL command not properly endedLRM-00111: no closing quote for value ''ORA-06502: PL/SQ

In data pump export import we can use SQl query to filter exported/imported data.The parameter we use for this is 'QUERY'. But parameter QUERY requer proper formating (quotes)Incorrect usage of single or double quotes for the QUERY parameter can result FOLLOWING errors:ORA-39001: invalid argument valueORA-00933: SQL command not properly endedLRM-00111: no closing quote for value ''ORA-06502: PL/SQ

SF Novelists has a post with links to various queries from SF/F authors. Not sure what more to say other than that, but if you want to know how the pros do it, then you should go there and check it out. I mean it. These are real queries. You can learn how to do it from people that are published and still being published!Anywho!(Don't click the read more, there isn't any more after this!)

In this case you could use the PACKAGE SIZE addition in the SELECT query to process in limited amount of data, thus avoiding the memory overloads. Eg: SELECT * FROM INTO TABLE itab PACKAGE SIZE . IF sy-subrc EQ 0. *" Process the n records ENDIF. ENDSELECT.

Romeo and Julian...About the Siebel Query LanguageFirst of all, it abbreviates to SQL which is kind of funny, of course it has nothing to do with SQL.Just like you can get more out of a spreadsheet application like Excel when you are familiar with its internal functions and syntax, you can get much more out of Siebel CRM if you are familiar with the Siebel Query Language.Where is it used?The answe

my son is 2 yrs and 7 months old he does not speak.> we had checked him he has no hearing problem,he makes some sounds like bubu,mama and baba and screaming all the time========== two common things that delay speech at this age in a mentally normal child are hearing deficit (he may hear .. but less), the second being .... a tongue tie. take him to a speech therapist..but his milestones are all del

I was told three days ago my son had an allergy to his amoxicillin by his pediatrician.--------- well its unusual. reactions are common that allergy. what was the reason for which amoxicillinw as given?Yesterday his hands and feet were extremely tight and swollen,he didn't want to walk.--------------- This can be common feature of allergy, but its more common as puffines of face. he may be breathl

Sarah: "So that seven minutes when Darren will be seven and I'll still be six, is that time early in the morning when it is still dark?[Heaven forbid she be awake to endure the short-lived disparity...]Twice the children = twice the classmates = twice the cupcakes.

SELECT nameFROM employeeWHERE name LIKE ‘_a%’; Which names are displayed?Names starting with “a”Names starting with “aR or “A” Names containing “aR as second character Names containing “aR as any letter except the first

I am asking you for a favor, dear readers. It’s impossible for me to accurately gage how many people are actually reading The Stinker. I use StatCounter, but that only tells me the number of people physically visiting URL’s under my site. I have no clue how many people are getting my blog posts via [...]

Book Details*Author: Danielle Larocca Signorile*Publisher: Sams*Number Of Pages: 336Publication Date: 2006-08-03*Format: PDF*Quality: Good*ISBN-10 / ASIN: 0672329026*ISBN-13 / EAN: 9780672329029 DescriptionSAP Query Reporting is everything an SAP user needs to know to create your own reports in SAP using Query tools, no programming required! Designed as a hands-on learning aid, you will be able t

Dear Dr.Ulf Erlingsson I read your response to one of the articles published in Down To Earth. You wrote “This is the warmest period in 400 years because finally we are out of the Ice Age. We are now back to a more agreeable climate that has been the norm for the past 8,000 years.” I would [...]

Today, I got a very funny and hilarious email from a friend of mine. It is so funny and hilarious that I couldn’t stop myself for posting it. It is the SQL query created by a programmer who is just going to get married and take a look at this cool SQL query created by [...]ShareThis

After creating a query in BEX, you try and save the query, it gives you the following popup message: "The query could not be saved due to a problem in transport". Steps to correct the problem: 1. Within Adminstrator Workbench click on the Transport Connection tab in the Navigation Window on the left hand side. 2. Select the Request BEx button on the toolbar. 3. Create a transport. 4. T

You formatted a query view ( By changing Fonts/column width etc ) and saved as workbook in your favorites in the Browser. When you execute the workbook thru the browser you get the format that has been saved. However, you loose the format when you click the Refresh Button. How to set permanent settings so that formatting remains same as has been designed in the workbook? You can do this :- In Exc

We are have authorization issues with Querries. We have created a genericRole that has some Standard Query's for our Company attached to this Role.We give access to this role to our user community. The problem we arehaving is that the users can Execute the querries and what they are supposeto do is only Save the Workbook to there favorites. We are running acrossa problem because some of the

Many people are confused by the differences among: Query, Workbook, and View. Here are my thoughts on the subject: A query definition is saved on the server. Never anywhere else. Although people say a workbook contains a query (or several queries); it does not. It contains a reference to a query. The workbook can be saved on the server; or anywhere else that you might save an Excel workbook. Wha

I was surprised when I made a query of “tonetsdaily” in Google. In Google results, I found a posts results below my homepage url that is shown below. Share This

One question came up just a day ago while I was writing SQL SERVER - 2005 - Difference Between INTERSECT and INNER JOIN - INTERSECT vs. INNER JOIN. How many tables in database AdventureWorks have column name like ‘EmployeeID’? It was quite an interesting question and I thought if there are scripts which can do this would [...]

@DeepakApollo tyres is a good company to remain invested in.it has an eps of abt 4.35.the company will regain its levels where u bought by 6-9months and may go 5-10 points further.so if u keep it as a long term investment,i think u ll make decent returns out of it coz the EPS is expected to rise to 6 in abt 1.5-2yrs time.For others i wud recommend a buy on it with a taget of 46-48 in 9-12months.H

Spam Bots You know when you chat or idle on irc you often come back and see tons of spam bots lines here is a chance to ignore them automatiquelly without closing your Private Message. This script for Mirc will recognize some keywords said in private message and will automatiquelly close the query with the nick and [...]ShareThis

Let us try to understand this subject with example. We will use Adventurworks database for this purpose. Table which we will be using are HumanResources.Employee (290 rows), HumanResources.EmployeeDepartmentHistory (296 rows) and HumanResources.Department (16 rows). We will be running following two queries and observe the output. In the resultset the order of first column (EmployeeID) is different

Does anyone on BIO live in the Raleigh, NC area?  My sweetie is taking me on vacation there next month, and it’s fun to meet online friends face to face, the way we had a chance to get together with Ken Grandlund on a trip to San Diego a while back.  We’re thinking about relocating [...]ShareThis

I just read Karine Bosch's blog where she posted some news on the U2U CAML Query Builder, so I just ought to get your attention in that direction. Check the detailed updates out in Karine's blog: ... (More)

Lecture slides: Search Engines Today Personalization Aspects of User Profile User Modeling User Profile Modeling Sources of User Information Our Mobile Search Personalization Architecture Process Distribution User Profile Representation User Profile Creation Updating User Profile Features of the Formula Personalizing Search Results Personalization Process Re-Ranking Ranking Algorithm Experimental

Lecture slides: Introduction What is a Query Log Our Logs What Does it Contain? How We Exploited Caching Policies Probability Driven Caching Static Dynamic Caching SDC Sections SDC and Prefetching Hit Ratio Throughput Collection Partitioning and Selection Innovations Contingency Matrix Co-clustering Results Experiments Precision Better Term Partitioning Why Term Partitioning? Encouraging Figures.

@DINSBirla Sunlife Tax Relief 96 (G) is a good fund,c all the mutual funds r in huge losses. Many have lost abt 33% of their value.So i dont think Birla Sunlife Tax Relief 96 (G) can b a exception.Switching to dividend option wont do u any good.Rather if u switch again then there will be service charges.U hv only one option and that is to hold it for atleast 12months.All will b fine in the next ye

Les paso un tip a los que andan en las mismas, trabajando un un proyecto (si vieran cada cosa rara que le piden a uno en las instituciones finanicieras :S) intente llenar un gridview con una sencilla consulta como esta: SELECT D.id_deposito As ID, D.id_empleado As Empleado,D.monto As Deposito,D.Fecha,IF((D.registrado=0),'CANCELADO','REGISTRADO')As Estado,C.num_cuenta As Cuenta,CONCAT(D.periodo_ini

One of my favorite and most heavily used PHP common functions retrieves variables from the query string. I found that without this function, I was inefficiently checking if the variable existed, and if not, I was then was manually setting a default value. The function takes in two string variables that handle the above problem. [...]

When working with databases and records sometimes we find difficulties in displaying data from many tables using SQL join. For example you wish to include some aggregate columns from three tables below : the structure of the products table : ProductID text(15), VendorID text(15), Descriptions text(50), UnitsInStock integer, Price integer Data in the products table : ProductID VendorID Descript

Query About Tcode PFCG 1. How to check the name of all users who has been authorised to use a particular transaction? I am trying to find through SUIM, but failing to find the name or total number of users of a particular t-code say SPRO. 2. I know that a particular transaction say SPRO is available in a particular role and I want to remove that t-code from that role. But I am unable to find that

@ DineshBuy Nifty 4000 July PUT at Rs102 or less with SL of Rs88 for target of Rs130-135

@ ASHISHSorry Bro, hadnt logged into the Chatbox so dint get the msg earlier.@ ALLHope u enjoyed the calls;all expect essar oil are bang on target.........If u hv had huge profits;do donate a part of it to my Acc.This ll help keep the Blog Alive.

@ AshishI see HDIL breaching the 52-week low of 320 in the near future though it has support at 330.Its a good company to invest for a long termbut when the global cues r so -ve and the market sentiment so nervous with the rising crude(it may reach 170$),i c a downfall in the indian market for very short term and no company including HDIL is exception for this.So i wud advice u to wait for the rig

  The examples below are based on the following demo schema's: user SCOTT created with script:                              $ORACLE_HOME/rdbms/admin/scott.sql user HR created with script: $ORACLE_HOME/demo/schema/human_resources/hr_main.sql The Export Data Pump and Import Data Pump examples that are mentioned below are based on the directory my_dir. This direc

PHP4 doesn't have built-in php_build_query function as in PHP5 does. We will create a function that mimic http_build_query function that works on both PHP4 and PHP5.Here's the code: function http_parse_query( $array = NULL, $convention = '%s' ){ if( count( $array ) == 0 ){ return ''; } else { if( function_exists( 'http_build_query' ) ){ $query = http_build_query( $array ); } else

Sometimes we have problems with our network and we are not able to work normally because of this making our customers to wait longer. Deadlines are very important to us and as much as possible we are hoping that it will not happen on that specific situation wherein we are the one who are blamed [...]

Reason: Your database is in a folder where there is no write/change permission.Resolution:If using Windows 2000 - IIS5- the {Server}\ASPNET User Account must have Read, Write, and Change Control of the Folder where database residesIf using Windows 2003 - IIS6- the NETWORK SERVICE User Account must have Read, Write, and Change Control of the Folder where database residesGiving EVERYONE account full

You might have seen the post coming up on this blog again in last week after I come back from the hospital, everything went well and I am enjoying bed rest since last couple of days until all next week. Due to the blogging break for surgery, there were three pending actions for me here. [...]

In response to my survey of starting salaries for entry level positions at district attorney’s offices around Texas, one of my readers wrote in asking whether it was worth going through three years of law school to become a prosecutor. I’m posting my answer here so that others can add their thoughts and comments on [...]

Ever wonderd what website or page would be at the top of a search query list if you typed a single letter of the alphabet into a search engine? Probably not! But hey I wonderd for you, so here’s my results: Live Search (United States) A is for FunBrain.com - The Internet’s #1 Education Site for K-8 [...]

Improving Magento performance is at the top of the list for most professional Magento developers. There’s no doubt that enhancing the speed at which Magento performs can only be good for business. (more…)

First construct the logical database and generation of query report is as follows.The transaction codes used in Query reports are:1. SQ01 – For creating Query.2. SQ02 – For creating Infoset.3. SQ03 – For creating User.First u need to create the USER and generate the INFOSET, in turn can produce theQuery report.INFOSETAn SAP InfoSet (formerly known as a Functional Area) is crucial for ABAP qu

First construct the logical database and generation of query report is as follows.The transaction codes used in Query reports are:1. SQ01 – For creating Query.2. SQ02 – For creating Infoset.3. SQ03 – For creating User.First u need to create the USER and generate the INFOSET, in turn can produce theQuery report.INFOSETAn SAP InfoSet (formerly known as a Functional Area) is crucial for ABAP qu

GetAFreelancer.com New Projects Hello I am looking for someone to update a url field in MS Access. This is a simple project in that I will give you a url field and you will add 3 parameters to it to include city state country and then update the url field for me in an Access DB... Budget 30 250 Jobs Windows - Bali based Web Design, Development and SEO Services

I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips. Twelve Tips For Optimizing Sql Server 2005 Query Performance 1. Turn on the execution plan, and statistics 2. Use Clustered Indexes 3. Use Indexed Views 4. Use Covering Indexes 5. Keep your clustered index small. 6. Avoid cursors 7. Archive old [...]

YouTube has announced the addition of query suggestions for search. In case you're not aware, query suggestions are search suggestions that pop up once you start typing a search. The announcement said that you have to opt in to the suggestions using the "advanced" link next to the search button. But I'm getting suggestions without doing the opt in. YouTube has also added a contact impo

This post is a mere followup to my previous minor posts on the subject of SPQuery and SharePoint queries located here. Basically this post will provide step-by-step instructions to construct your CAML (Collaborative Application Markup Language) queries using the U2U CALM Query Builder which you can ... (More)

Today we have a quickie for SQL jockies working in MS Access land: how to select a result set of random records. Disclaimer The meaning of the word quickie in this article is two-fold. First, this is a small article — a quick tip. Second, this is not mean to be used for large or frequently-called queries. ORDER BY RAND() is very inefficient. The table I am working with contains only a few hundred records, and I need to generate the result set just once. How not to do it Thinking in MySQL terms, my first instinct was to use the following query to produce a small result set of random records. SELECT * FROM [MyTable]ORDER BY RAND() LIMIT nThis does not work in Microsoft Access — instead, you need to call the Rnd function.Querying Random Records in MS AccessThe following query

Το LINQ, όπως έχω αναφέρει και στο παρελθόν, είναι μία από τις σημαντικότερες προσθήκες στο .NET Framework. Κάνει τη διαχείριση των δεδομένων πραγματικά εύκολη ειδικά για όσο&u

htmlSQL is a PHP class for querying HTML using a SQL-like query. It saves you from writing complex regular expressions to extract values. htmlSQL example: This query returns an array with all links that contain the attribute class="list". Isn’t it great? How to use? You [...]

CrunchyFrog is a database explorer and query tool for GNOME. Currently PostgreSQL, MySQL, Oracle, SQLite3 databases and LDAP servers are supported for browsing and querying. More databases can be added using the plugin system. This application requires GTK+ version 2.12.x. Other dependencies include: For a (almost) complete list of dependencies see

Sub-queries are often referred to as sub-selects, as they allow a SELECT statement to be executedarbitrarily within the body of another SQL statement. A sub-query is executed by enclosing it in a set ofparentheses. Sub-queries are generally used to return a single row as an atomic value, though theymay be used to compare values against multiple rows with the IN keyword.A subquery is a SELECT statement that is nested within another T-SQL statement. A subquery SELECTstatement if executed independently of the T-SQL statement, in which it is nested, will return a resultset. Meaning a subquery SELECT statement can standalone and is not depended on the statement inwhich it is nested. A subquery SELECT statement can return any number of values, and can be foundin, the column list of a SELECT stat

This question is quite a popular question and it is interesting that I have been receiving this question every other day. I have already answer this question here. “How to find Nth Highest Salary of Employee”. Please read my article here to find Nth Highest Salary of Employee table : SQL SERVER - Query to Retrieve [...]

Geek Football Hooliganism at its best! The “Juventus” search result “Forse Cercavi:Merda!” translates too “Do you Mean: Shit/Sucks!” They will be shouting Klingon war chants in the terraces next.via

Many times when I am just bored I surf Book On Line for SQL Server 2005. Almost all the time I find something new which makes me believe that I have lot to learn and there are so many things I am not aware of. Today I found system catalog view sys.dm_exec_query_optimizer_info. I just enjoyed [...]

Chelsea Clinton Startled by Monica QueryExcerpt:"Chelsea Clinton had a quick retort Tuesday when asked whether her mother's credibility had been hurt during the Monica Lewinsky scandal."Wow, you're the first person actually that's ever asked me that question in the, I don't know maybe, 70 college campuses I've now been to, and I do not think that is any of your business," Clinton said during a campaign visit for her mother, Sen. Hillary Rodham Clinton."

After creating a query in BEX, you try and save the query, it gives you the following popup message: "The query could not be saved due to a problem in transport". Steps to correct the problem: 1. Within Adminstrator Workbench click on the Transport Connection tab in the Navigation Window on the left hand side. 2. Select the Request BEx button on the toolbar. 3. Create a transport. 4. Try to change the query again.What Is SEM and BPSWhat Are Routines and TransferCustomer Exit Variable In BexDifferences Among Query, Workbook and ViewLO Cockpit Step By StepDelete unwanted Objects in QA systemSAP ConsoleBEX Query AuthorizationsStop a scheduled infopacketQuery View WorkbookThe query could not be saved due to a problem in t...ODS infosource not showing upCOPA Extraction StepsHow to

You formatted a query view ( By changing Fonts/column width etc ) and saved as workbook in your favorites in the Browser. When you execute the workbook thru the browser you get the format that has been saved. However, you loose the format when you click the Refresh Button. How to set permanent settings so that formatting remains same as has been designed in the workbook? You can do this :- In Excel using BW, you have what I categorize as 2 different types of cells. You have "Excel" Cells and "BW" Cells. You can determine which you are in by selecting a cell and right mouse clicking. If you get the BW options (Drilldown, Swap, Insert.....) then you are in a BW Cell. If you get the standard (Cut, Copy, Paste) you are in the Excel Cells. If you are formatting an Excel Cell, Format using

We are have authorization issues with Querries. We have created a genericRole that has some Standard Query's for our Company attached to this Role.We give access to this role to our user community. The problem we arehaving is that the users can Execute the querries and what they are supposeto do is only Save the Workbook to there favorites. We are running acrossa problem because some of the users are saving the workbook as existingworkbook. So when they do this it wipes out the Query in that Role. Howcan I stop users from overlaying the MASTER Query. There has to be a waythat you can protect a query so that it cannot be changed. Because wehave generic querries that are being used throughout our company, I need tobe able to protect the query so that it can only be saved to u

Many people are confused by the differences among: Query, Workbook, and View. Here are my thoughts on the subject: A query definition is saved on the server. Never anywhere else. Although people say a workbook contains a query (or several queries); it does not. It contains a reference to a query. The workbook can be saved on the server; or anywhere else that you might save an Excel workbook. What happens if someone changes the query definition on the server? Answer: the next time you refresh the query in the Excel workbook, the new query definition replaces the old query definition in the workbook. Maybe. It depends on what change was made. For example, if someone added a Condition to the query definition, the workbook will be virtually invisible to this. The Condition is available; but

Author: Tobias Zimmergren Url: If you've read my last two blogposts you already know how to configure ASP.NET 2.0 AJAX for your SharePoint Server and how do deploy a UserControl that uses AJAX functionality on you SharePoint Server. You can find my previous articles ... (More)