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] ...Excel 2003 file freezes laptop
I took a laptop away from the office and tried to open a large spreadsheet
on the local C: drive. Each time I tried the laptop froze and had to be
rebooted. When I connected back to the LAN at work, and opened the same
file on the local C: drive I had no problems.
What could cause this? If there is any corruption is there a way to
decompile or something as you would in Access?
...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...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...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...Excel not Access
I have designed an Access database that holds records relating to my stores
audit results going back for about 5 years plus a load more information
relating to these stores. This was used to produe a pack once a month,
however a change in senior management means that I have got to shelve this
and prodce a similar pack in Excel.
The idea would be that the user could select a month or a 12 mnth date range
that would produce data that could then be used to populate a number of excel
templates that have been designed. Having not used excel for years I would be
grateful for any suggestion...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...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...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?
...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 ...copy and paste from excel to ppt with VBA
I need to copy a lot of graphs from excel and paste them into a ppt
file using VBA code.
So far, I used this VBA code:
Worksheets("Slide01").Range("BB1:BF1").CopyPicture xlScreen, xlBitmap
and format of the object in the ppt is a bitmap.
Now I would like to copy the object like a "picture".
How must I change the above VBA code in order to do that? (please
consider that the presentation has a lot of slides, so it should remain
Thx a lot for your help
--------------------...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...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>...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...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...Is Microsoft POS (not Microsoft POS 2009) PCI compliant?
Is Microsoft POS (not Microsoft POS 2009) PCI compliant?
This is a multi-part message in MIME format.
1.0 is not, 2.0 and above are. For a list of compliant applications, =
Check Point Software
Search this newsgroup -- http://tinyurl.com/2lmk4w (Stolen from DRS)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3...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
excel is just gone off my computer!!! It is since my last
windows update, and now i cant access my spreadsheets and
cannot run my leasing program. Is there a way to restore
it? it keeps asking for a disk i dont have, this emachine
came with something on it we upgraded to sp pro which i do
have the disk for but it wants 2000 and like i said i dont
have it any suggestions?
you need the correct installation media. If you have upgraded Office
you need the upgrade CDs
"Lee" <firstname.lastname@example.org> schrieb im Newsb...