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...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
...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...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...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 ...Can't add additional components
When I try to add an additional component to Pub 2003 from my installation CD
(using Add/Remove Prog.) I get the error that I have an incorrect pro11.msi
file, both on the installation CD and the one on my system. I think that this
may be because of Office Update changing something. Does anyone know how to
"This installation package could not be opened" error message when you try to run
Office 2003 Setup
How to use a setup log file to troubleshoot setup problems in Office 2003
http://support.microsoft....How do I add sound to outgoing messages
In Outlook Express I could add a sound to outoging messages that would play
when it was opened. I have not been able to figure out how to do it in
Outlook 2003. Anyone know?
If you are using Windows XP SP-2, the ability to add sounds/video to
outgoing mail via Wordmail is broken.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After furious head scratching, Sandie asked:
| In Outlook Express I could add a sound to outo...Microsoft Promo
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>...Publisher 2007 Beta 2 with pdf add-on
I am a newsletter editor for a very simple monthly newsletter and I am
pleased that I can send my letters out in pdf format so eveyone with a
computer can read the letter with the Adobe reader. I think I am going to
leave well-enough alone and not do anything to jepordize this feature until I
can buy the final copy whenever it comes out. Will anything happen
automatically to the Beta 2 version of office to prevent me from using the
pdf feature in Publisher before the final product hits the streets? I am
learning a lot from this discussion group--thanks to all of you.
Depends on when...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 <firstname.lastname@example.org> 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...Outlook Automatically Adds Appointments to the Calendar
have Outlook XP SP3 running on WinXP Pro with SP2.
When i view an appointment invitation that was sent to be in the
preview pane for some reason outlook automatically adds the
appointment (tentativelly) to the calendar. Searching on google.groups
i found some people saying that this is the way outlook works and this
behavior is by design. I really don't understand their explanation. Why
previewing message in outlook would require it to add the appointment
to my calendar? Some other people said to disable tracking options but that
Any other advice.
Thank you very much.
...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...Sum of Descriptions Query
I have a Query that has a WorkID and a Work Description:
1 Go to work
2 Come home
3 Eat Dinner
I want to compile the Descriptions into a single description:
Go to work, Come Home, Eat Dinner
Can I do this & if so how?
can you tell us a bit more - what happens after you put 'Go to work, Come
Home, Eat Dinner' together? Do you have a table with lots of entries like
this that you need to concatenate in the same way?
"Jazflux" <Jazflux@discussions.microsoft.com> wrote in message
news:A8A57FEC-802D-4B54-BFD7-9...Use SQL to delete record from underlying query
I have a form that is a main and subform. The subform uses dlookup to
find multiple values that are used as defaults for the current record.
This process is complex and ends up using code to modify bound fields.
This works great until I want to cancel the update.
If the user wants to add a record, this form is loaded and all of the
prior settings from the underlying tables are brought in. If I then
click Cancel to close the form and not complete the new entry, the
record is saved anyway. I understand why the record is saved by
I wanted to delete the just added record as a roundabout ...Which version of Microsoft Office #2
I've just bought a PC with Windows XP. I need to upgrade Microsoft Office (I
had Office '97). Can anyone confirm that to have a version that will run and
send/receive emails I'll need Office 2003? Can't get a straight answer from
the shop I go to and I don't want to make a mistake.
To answer your question, and not try to steer you to options you did NOT
inquire about, yes, Office 97 is a qualifying product for Office 2000
You may want to look at 2003 as it is the latest version of Office and has
the longest support available. Offic...Microsoft Office 2004
I have been using the microsoft office 2004 on an ibook G4 on panther
for the last 6 months.
Recently, it is refusing to read some of the excel and powerpoint file
created on a PC under the Office 97. I can see the file name but not
the icon next to it when I look under Finder. When I click on the file
name, the file disappears from view completely. At first I thought it
was a software issue so I re-install the Microsoft Office 2004, but the
Has anyone encountered this problem? Any suggestions to solve it would
be much appreciated.
Thanks in advance,
In artic...Add Text To Multiple cells
I am working on this project & I cant figure out how to add a letter in front
of each number in a cell without clicking in to each individual cell and
typing it in. (very time consuming and tedious) The problem is - it's not all
the cells but a majority, all of the numbers are in the same column. To
explain, these are documents in storage. Each item is assigned a number (not
in any particular numerical order but they have to stay in the order they are.
The last three numbers need the X in front of them.
Any ideas? Thanks so much...Synchronizing 2 x Microsoft Outlook 2007 #2
I have MS outlook 2007 on two different PCs. How Can I synchronized the
Calendars from boot Outlooks.
...microsoft outlook and microsoft project
I install MS Outlook 2003, and also MS Project 2007. When I online MS
Outlook, any time when there is message come in my mail box. Window display "
Microsoft config gathering ms project information"
Is it an installer window or a project dialog box?
If installer, the Microsoft installer program is corrupt. Try Detect and
Repair in Outlook or Project to stop it or just let it run and complete.
If it's a project dialog box, you have some addin doing it.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www....Microsoft SQL...
We are using W23K Server, Exchange 2003 SP1, Backup Exec 10.0. We
purchased the Exchange Agent and are using it. Recently, when the
backup runs it skips 22 files, which are in use. These are the files
for Microsoft SQL. In a disaster recover scenario where we reinstall
W23K, Exchange and restore the Exchange data / mailboxes from tape, do
we need to have the SQL backed up or would it be reinstalled with
Exchange / Backup Exec?
Any advice would be appreciated. THANK YOU in advance!
you're running SQL and Exchange on the same box? why is that?
Susan Conkey [MVP]