Calling Dex Procedures from SQL
Is there any way to call dex procs from SQL or VB code?
There is an undocumented and unsupported method of calling Dex code from
VBA. However, I know of no method of calling Dexterity from SQL.
Please email me if you want an example, just remove the online. from the
David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific
Microsoft Business Solutions
Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This p...is SQL 2000 architecture different SQL Server 2005 / 2008 architecture?
Hi I have a book "inside SQL Server 2000" by Kalen Delaney, which I
have been told is a good book. I am going backwards... reading about
the sql server architecture in chapter 3 of the book.
As I'm reading... I was wondering is it different SQL Server 2000 vs
SQL Server 2005/2008? Also
where can I find a book/or link that can give me more details about
the internals on architecture?
norm (email@example.com) writes:
> Hi I have a book "inside SQL Server 2000" by Kalen Delaney, which I
> have been told is a good book. I am g...Moving customizations from SQL 2k to SQL 2k5 CRM
This may be a non-issue but I wanted to check to see if anyone has done this
and ran into issues.
I have the XML customization files from our previous install of CRM 3.0 with
SQL 2k database. I now want to import and publish these same customizations
to CRM 3.0 on SQL 2k5.
Has anyone done this or can point me to documentation that tells about the
success or issues for doing this?
On 7 Feb., 06:35, Chris Treanor
> This may be a non-issue but I wanted to check to see if anyone has done this
> and ran into issues.
&...stored procedure glppostbatch returned the following results:
I am getting this message after posting:
The Stored Procedure glppostbatch returned the following results: DBMS: O
Microsoft Dynamics GP: 20286
I am not sure if should use PSTL KB 898996 missing the triggers.cmp file
or if I should use the new Database maintenance with V10?
I am on V10, SP3
Can someone clarify the steps I need to take?
I would use PSTL to recreate the SY00500 table as it would maintain the
existing data. If you use the SQL maintenance option in GP, you will then
have to run check links and reconcile to recreate and update all batches
across al...Meeting Requests do not display properly
I am hoping that someone may have seen this problem
before. When any of our users with Office XP send a
meeting request in Outlook, it does not display properly
for recipients that are using Office 2000. Any clues?
...sequential text and numbers problem
I am trying to save myself an incredible amount of time and could use some
help. I am listing a series of cell and need a formula so that I dont have
to type each the value. The sequence is as such (the "+" is strictly text
and has no mathematical function: 0+73, 0+78, 0+83, 0+88, 0+93, 0+98, 1+03,
1+08, 1+13,... The numbers before and after the "+" change per document but
the number after the "+" always increases by 5. Note that the number before
the "+" increases by 1 once the numbers after the "+" exceed 100 (so that
This is a multi-part message in MIME format.
Does anyone know if Outlook uses port 1550?
Colin M. McGroarty, MCSE, MCP+I, NT-CIP
2004 Microsoft MVP, Windows Server - General
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>...How can i create a query on text input to return closest match?
I would like to create a text based parameter which will return the closest
e.g Drink is the search citeria, the search will look for the word drink in
every record and bring up those with the closest match
Can you explain what you mean by closest match?
Looking for the word Drink in a field and returning all the records where
"drink" is included in the field would be simple.
Criteria: LIKE "*" & [Enter word] & "*"
But if you wanted to enter DRINK and find
Drink or Drank or Drunk or Dink or Rink Or Dunk or ....
in...CRM 3.0 Install Error with SQL Reporting Services and SQL 2005
Doing a CRM 3.0 Server installation. During the last page of the install
wizard (or what I assume is the last page) when I goes through and does
verification I get a red X next to SQL Reporting Services. The message I
receive when I look at the details is:
The specified path is not a metabase path.
Parameter name: path
Now SRS is installed and working. I put in the URL:
http://<servername>/reportserver and every other variation on that I can
also assuming you did not use ssl...
=======================...Data Conversion Expression returns #Error
Objective: Convert txt data representing a time stamp on a particular
activity into DateTime format.
1. If the data field contains any data convert it to the DateTime format
2. If data field is Null or a zero length string would like to return a null.
3. The data usually come in 0000 format but it could be 000 or 00 or 0 or “ “.
CDate(IIf(IsError(FormatDateTime(IIf(Len([Cut_Time])<1,"",Left([Cut_Time],2)+":"+Right([Cut_Time],2)),0)),"",FormatDateTime(IIf(Len([Cut_Time])<1,"",Left([Cut_Time],2)+":"+Right([Cut_Time],2)...Assigning a number value to a letter?
I am trying to see how I can assign a number value (10) to a letter (X) that
is typed into a cell. Everytime I type (X) I want it to represent the number
(10) in any formulas that I want to use it in. So, if a type (X) in seven
cells it should add up to 70. Can I do this?
as an array formula, so commit with Ctrl-Shift-Enter
(remove nothere from the email address if mailing direct)
"Orphan86" <Orphan86@discussions.microsoft.com> wrote in message
> I am trying t...SQL 'for xml' and C# example??
I'm missing some piece of the puzzle. I'm using 'for xml' type queries from
SQL2K - and now trying to change the front-end from ADO to C#, I can't quite
figure it out..
It seems that I could use an XmlReader.. and somehow use that instead of a
DataReader.. but that didn't work.. I tried using a DataReader and get the
byte array - but that wasn't right.
SQL returns formatted XML, I need to load that XML into an XmlDocument
somehow without ANY molestation of that dom. Any ideas? Examples? Missing
THANKS!! I've been looking for the answer to ...sql summarizing help
id, cdate, weeksago, amount, typeid, timeclose
496, 2010-02-11, 0, 450, 3, 1
490, 2010-02-01, 1, 200, 4, 1
491, 2010-02-01, 1, 350, 2, 2
493, 2010-02-01, 1, 500, 5, 1
489, 2010-01-21, 3, 150, 2, 1
136, 2010-01-12, 4, 500, 3, 2
137, 2010-01-12, 4, 100, 3, 1
138, 2010-01-12, 4, 500, 2, 1
1. i'm trying to create a sql that will give me a summary resultset grouped
2. i want to sum the columns and get counts based on typeid.
3. avg of timeclose
here's the sql i have:
, (sum(timeClose)/(count(timeclo...Update multivalue field in table from form with SQL
Access 2007 on Vista
I am using a form to establish the variables for a report before it is
created. One field on the underlying table is a multivalue field, and the
form includes a multi-select combo box control. After selections are made and
the OK button on the multi-select combo drop down is clicked, focus moves to
the next control. I have discovered though, that the underlying table does
not update immediately, but does so correctly when I close the form. This
sequence does not deliver the proper report data, so I need a way to
immediately update the underlying table (m...Refer to SQL statements globally
I have two large SQL statements that I need to use across several
forms, reports, etc.
Rather than repeat them in each form, I'm trying to store and
reference them globally.
For example, I'd like to store strSQL1 and strSQL2 in a global module,
so I can use either like this in a form:
Me!lstResults.RowSource = strSQL1
Me.Report.RecordSource = strSQL2
Would I just store the SQL statements in a global module like:
Public Function SQLSource() As String
Dim strSQL1 As String
Dim strSQL2 As String
strSQL1 = "SELECT blah blah...Transaction Reference Number
Is there any way to SEARCH by transaction reference number?
We sell thru many channels and use this space to put the order number from
the channel, i.e. Amazon's Order Number.
When we get an enquiry about an order, many times it only contains the order
number, not the customer's name, email, or any other identifiable information.
We have to go to Amazon, look up the order online to get the person's name.
I want to be able to query the reference number in RMS.
This is a multi-part message in MIME format.
Content-Type: multipart/a...To SQL or not to SQL?
I have a very vertical product developed 100% in M/S Access. I developed it
myself in 1993 in the initial release of Access and been with it ever since.
It is currently very stable and running in Access 2003. My big question is
how or even *if* we should move it to SQL. My customers are getting bigger
all the time with more users. Typically our customers run one or two
workstations generally never more than 5. Performance, however, is starting
to slow with database sizes passing 500 meg. We also have a LOT of code
behind forms so are bound tightly to the Access development environ...ERROR: "The record you are requesting is currently unavailable"
CRM 3.0, using Web client, Windows Server 2003 SP1 for SBS.
Have found no good solution for this problem I've been getting since
installation couple days ago.
When trying to create a new appointment, upon save get the error:
"The record that you are requesting is currently unavailable. Either
the record was not found or you do not have sufficient security
permissions to view it."
Upon clicking "Ok" I get the error:
"General failure in scheduling engine" with a "Ignore and Save" button
which will save the appointment, but still marks the appointm...PostgreSQL or other SQL servers in RMS
Has anyone successfully implemented RMS with one of the free SQL servers?
Theoretically, is there any reason why we have to use MS SQL Server 2000 for
"dh" <firstname.lastname@example.org> ha scritto nel messaggio
> Has anyone successfully implemented RMS with one of the free SQL servers?
> Theoretically, is there any reason why we have to use MS SQL Server 2000
> large databases?
RMS has implemented only for MS SQL Server (2000/MSDE) and isn't possible to
work with ano...writeback to SQL 2005
hello! I use excel 2007
iI open a connection agianst SQL server 2005 and choose a table. In my
workbook i can now see this data from this table. if i change a value in some
cell i wish to writeback to table in SQL server. Is this possible?
It's possible through the use of VBA and ADO, but not simply using the data
connection you've already established.
"CJ" <CJ@discussions.microsoft.com> wrote in message
> hello! I use excel 2007
> iI open a connection agianst SQL server 2005 and choose a table...Formatting Page Numbers in sections
My document has some pages that are portrait and the page numbers are
centered in the footer.
In a few sections I have pages that are landscape and of course the page
number is in the footer as the layout is 11 across.
However, I need the page numbers on the landscape pages to be on the left
margin so when the document is bound the page number is the same direction as
all the other page numbers. It will be a bound dissertation. with all page
numbers located at the bottom centered.
HELP--fast PLEASE I can't find out how do do this. When I drag the page
number outside...Changing default for Meeting request time
Can you change your default setting to a specific time when scheduling an
appt? Or do you have to highlight the time on the calendar first in order for
it to show in the start time?
The default time is based on your work hours. If you don't want to pick the
time on the calendar you can type it in - use shortcuts like 10a or 230 in
the time fields.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
Does anyone have a comprehensible guide on how to use it that a dolt like me
can follow? Every time I try I get a #N/A.
The only guide I can find is at
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip but it's
really hard to follow.
From the MSDN Library:
Not sure how familiar you are with ODBC; but if you are getting #N/A as a
result, it is usually because of problems either with the SQL syntax or the
connection string. There are a few examples of connection strings in the
re...MSDE or SQL Personal or SQL Developer? or SQL Workstation?
Hi, which one is better for personal non-server computer? MSDE? SQL Personal?
SQL Developer? SQL Workstation?
It depends on what edition of GP you are going to run. If you are going to
use Professional, you need to go with SQL Server developer, assuming you are
installing on a non-server OS.
> Hi, which one is better for personal non-server computer? MSDE? SQL Personal?
> SQL Developer? SQL Workstation?
> Thank you.
Is the function of SQL Developer the same as Enterprise edition?
How about personal edition? Can it be used for GP Pro?
Can dev...How to I carriage return in "text" cell?
How can I do a carriage return in a text cell? It alway puts me in
another cell when I press <enter>.
Also, can I use bullets in a text cell?
Use Alt Enter.
"Brett" <email@example.com> wrote in message
> How can I do a carriage return in a text cell? It alway puts me in
> another cell when I press <enter>.
> Also, can I use bullets in a text cell?
I'm not going to be much help, but what you need to do is
write your text string...