I have a query where the execution plan is showing a table scan with 32%
I have tried to put indexes on pretty much all the fields and still get the
The predicate from the Query Analysers execution plan for this table is:
([@NameChoice] IS NULL OR CASE WHEN
([dbo].[REVIEWER].[LastName]+', ')+[dbo].[REVIEWER].[FirstName] ELSE
CASE WHEN isnull([dbo].[REVIEWER].[FirstName],'')=''
THEN [dbo].[REVIEWER].[LastName] ...Microsoft.Crm.ObjectModel.MultiCurrencyPlugin + The given key was
I am working with MS CRM 4.0. I have made a custom entity which is having
some money fields. Everything was working fine. Suddenly while saving the
entity below message coming from applicaton:
"The given key was not present in the dictionary"
If i click ok then entity is not saving. I go to application server event
viewer log and saw below error details. Do any body face this issue, please
let me know, it is getting me too much trouble. I know it is related with
money field. I have to use money field in my entity. I have added some also.
Web Service Plug-in failed in Organiz...Help! Excel Formula
Below is an example of data in my excel sheet.
A B C D E F
Cell 1 ?
cell 2 Steve 1 to 10 13/2/04 britain
cell 3 Raj 11 to 17 15/2/04 india
cell 4 Ricky 18 to 35 14/2/04 Spain
Now if i enter a numerical value in A1 (where '?' is), i need a formula
which will check the column B and produce a result as desired below
Entery number = 9 then print "Steve 1 to 10 13/2/04 britain"
Entery number = 12 then print "Raj 11 to 17 15/2/04 india"
Ente...Comparing dates in columns from linked table
I'm new to Access/SQL and have a problem with a query that I just cant seem
to be able to solve.
So, I have an Access database containing client number, security name and
date, that information has to be updated every month, the source for the
update being an excel file that I link to the Access database. But I dont
want to overwrite on the existing data so what i wanted to do was add the
current month's data, when it's not already in there.
What I did was an insert query which inserts the data from the excel file to
the table in the Access database only if the c...Spreadsheet pausing,calculating cells,up2 100%,each input,why?
Everytime I input data into even the smallest of spreadsheets, the
application pauses, in the bottom left it states that it is calculating
cells, then there is a 3 second pause as a percentage rolls up to 100. This
is slowing my work down alot, please help me to understand what is going on
and how to stop it.
You can turn calculation to manual, do your data entry and then turn it back on
(or just recalculate when you want).
You'll see that excel gives you a warning in the statusbar when the workbook
Tools|Options|Calculation tab...convert DVD to play on Microsoft iPhone Video player
[quote][/quote]Many friends ask me how to convert DVD to play on Microsoft iPhone Video player. I always recommend them Cucusoft DVD to iPhone Converter. It backup convert almost any type of DVD to play on Microsoft iPhone Video player. Moreover ,It?s a powerful DVD to iPhone converter with very fast conversion speed. The output also supports full screen viewing.I think it is very useful and easy to use too.So , I recommend this useful software to convert DVD to play on Microsoft iPhone Video player. Hope it can help you.I download it here: http://www.92download.com/wiki/Cucusoft_DVD...microsoft
...How do I do dashboard charts in Excel
I have 3 sets (budget, forecast and actual) of sales and profit numbers and
would like to show them like a dashboard ( two small circles for Budget and
Forecast and a bigger one underneath those two for Actual. All 3 circles with
a hand point to the numbers linked to the source data ). Can anyone tell me
how to make a start?
Thanks and regards
Here are some examples of speedo type gauges.
Nick Cheng wrote:
> I have 3 sets (budget, forecast and actual) of sales a...Excel cannot find match
Using Excel 2003. Excel cannot find match for data that exists in
spreadsheet when using the Find command. Any fixes?
Perhaps Excel cannot find a match and doesn't need fixing.
Your data may need fixing.
Do you have extra spaces in the data?
Are you looking for "entire cell contents"
Are you looking for an exact match as in case-sensitive?
Are you looking in formulas when you should be looking in values?
See the available options under Edit>Find "Options>>" button.
Gord Dibben Excel MVP
On Fri, 8 Oct 2004 11:02:08 -0700, "GLH" <glhoo...Field service table structure and field definitions
The 9 SDK does not reference or define the fields or tables for the Field
service component. Where can I find this information? I need to move RMA
into a data warehouse and am having significant trouble identifying the data
You may want to contact I.B.I.S. They wrote the application.
Charles Allen, MVP
> The 9 SDK does not reference or define the fields or tables for the Field
> service component. Where can I find this information? I need to move RMA
> into a data warehouse and am having significant trouble identifying th...Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
I'm in a confusion that some of my apps.exe wont work with VC++6 but
they do work on VS2005.
Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
So to install VS2005, prior to that do i need to uninstall VC++6??
ARe there much changes in .dll of VC++6 & VS2005?
> I'm in a confusion that some of my apps.exe wont work with VC++6 but
> they do work on VS2005.
> Is Microsoft Visual studio 2005 upgraded version of Microsoft VC++ 6?
> So to install VS2005, prior to that do i need to uninstall VC++6??
> AR...Accidently deleted rows in Excel.
I'm not sure how it was done, but I accidently deleted many many rows in my
spreadsheet. I tried undo, but that's not working. How do I get all those
rows back? Thanks for your help!
Close the file without saving.
"Pelochino" <Pelochino@discussions.microsoft.com> wrote in message
> Hi all,
> I'm not sure how it was done, but I accidently deleted many many rows in
> spreadsheet. I tried undo, but that's not working. How do I...Microsoft Outlook to Microsoft Entourage
I just got my Mac and started using Entourage (by Microsoft) and cannot seem
to find how to get my PST to Entourage. There is support for Microsoft
Outlook Express but not Outlook...
Maybe export to OE first?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Ti...Excel? #2
How do I print titles on every page of a spreadsheet in Excel?
To print titles on every page go to - File - go to - Page Setup - selcect -
Sheet - and insert "Rows to repeat at top" the cells which contain the
titltes your want on every page
Hope this helps
> How do I print titles on every page of a spreadsheet in Excel?
...importing table data
Somehow we ended up with 2 copies of a database and data was entered into
each of them. Is it possible to import the data from a table in one database
to a table in another database that already has existing records in it? If
so, how can I do this?
You can link all the tables from the second in the first then run append
BUT the problem is in adding duplicate records or overwriting new data with
old if records have been updated. If all you have been doing is adding
records then there is no overwrite problem.
Build a little - Test a little
...Need Query Help
I am new to Access. I built a query which gives me purchase orders and
payments on those purchase orders. However, the query dpes not give me
purchase orders with no payments. I need both: (1) purchase orders with
payments and (2) and purchase orders without payments. How do I go about
adjusting my query to include both?
In your query, select the line that joins your two tables and right-click.
That should bring up a context menu with a choice for Join Properties.
Select that, then select the option that will include ALL records from the
purchase order table ...Is there an Excel template for a 1-day Tennis American Tournament #2
Am trying to set up one-day American tournament for 28 mixed-doubles' pairs
.. Seven groups each of four ranked pairingson seven courts. Is there an Excel
or an Access template anywhere for the scheduling of games, league tables etc.
It says on the microsoft website that "Super Suite Deal. Buy Office
2004 and get Office 2008 Special Media Edition for FREE". I accessed
it before and it said that even if you buy a student and teacher
edition now, you get an Office 2008 Special Media Edition for free.
But then I clicked on this link from apple:
and it says that when you purchase an office 2004 mac student and
teacher edition you JUST get a office 2008 for Mac Home and Student
What's happening there?
Plus, on the mactopia website, the supe...Excel #26
I started a new job, and am having to build a call list for potential clients. When I find these companies on certain websites or what not, they are listed on a page from top to bottom, sometimes in the many hundreds of companies in one column..
Here is a link , to a sample of what I am working with .
But Imagine Column A cell values go to A4032, Which is how much information I have to enter.
SO I have list with over thousand company?s names and contact info,
But, I am getting company in...Microsoft XML Core Services 4.0 Service Pack 2 (KB973688)
I have windows XP and this update fails to install tried it various
times..Can anyone help.
Microsoft XML Core Services 4.0 Service Pack 2 (KB973688)
Security updates for Microsoft XML Core Services 4.0 Service Pack 2 may
repeatedly appear in the update list on Microsoft Update or on Windows Update
See <http://support.microsoft.com/default.aspx/kb/941729/> for possible help.
If you can not rename msxml4.dll in normal Windows mode, than boot to
Safe Mode <http://support.microsoft.com/kb/315222>...Pivot Tables #11
I have a userform, and it has 2 textboxes, is there a way that I can
write a macro that will only display that data on a pivot table between
the 2 dates entered in these textboxes?
Right now I have the below, but I don't want to have to have all the
dates written like this.
With thisworkbook.sheets("CARS Survey Results by
..PivotItems("9/28/2005").Visible = True
..PivotItems("9/29/2005").Visible = True
..PivotItems("9/30/2005").Visible = True
I would like to ente...Diff between microsoft.public.outlook and microsoft.public.outlook.general
Unfortunately, I can't download the "descriptions" that goes with each
newsgroup carried by my ISP. The names of the forums described in the
subject line above sound similar, but there must be a difference. Any idea?
J <email@example.com> wrote:
> Unfortunately, I can't download the "descriptions" that goes with each
> newsgroup carried by my ISP. The names of the forums described in
> the subject line above sound similar, but there must be a difference.
At one time there was, but there is no longer. Just choose one.
Brian Ti...microsoft XL
My version of microsoft office XP (microsoft XL) does not
contain the option of showing negative numbers in
brackets. The format/number command only allows a minus
sign or negative numbers in brackets.
Am I missing some other command?
Am I missing something in your post?
First you say
"does not contain the option of showing [negative numbers in brackets]"
then you say
"The format/number command only allows a minus sign or [negative numbers in
regardless the format looks like this
or do you mean
Peo Sjoblo...Button Parameter Query
I am a COMPLETE NOVICE struggling with designing a database... Have Mercy!
I need my user to be able to select from a drop down list of queries from
which the user can then further choose a a single or combination of 7 regions
as the final criteria.
I believe I would need a drop down list of existing queries, for example,
"All Active By Region#", and then allow the user to choose which region(s)
they need to generate the report from a set of buttons on a parameter query
The reports will provide Region#, Name, Id#, address, phone numbers, e-mail,
and teachable qualif...Excel click through
At work I can double click on a cell that is linked to another
spreadsheet and it opens that spreadsheet. How do u turn this on? Does
it work in office 2000 or do u need Office pro?
keithgg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29961
View this thread: http://www.excelforum.com/showthread.php?threadid=496590
uncheck Edit directly in cell
> At work I can double click on a cell that is linked to another