Re: Use BiztalkUtilities adapters?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Eeeks... I didn't realize my replies would end up at the end of the
thread when I replied from a middle post. Anyway, I'm still not sure
if you are working with MYSQL or MS SQL Server. If you are working
with MS SQL Server and using the SQL Adapter that came with BizTalk,
you can use the following Stored Procedure.

NOTE 1: I'm assuming you are using the Northwinds Database installed in
SQL Server 2000.
NOTE 2: I'm also assuming you've added a bit column to the Customers
Table with a default of 0.
NOTE 3: The biggest difference in this stored proc from the one I
provided earlier is the FOR XML AUTO added to the final query.

CREATE PROCEDURE [dbo].[retriveNewCustomers] AS

DECLARE @l_PrimaryKey nchar(5)

Select @l_PrimaryKey=CustomerID From Customers Where IsPolled = 0 Order
By CustomerID

Select TOP 1 @l_PrimaryKey=CustomerID From Customers Where IsPolled = 0
Order By CustomerID

Update Customers Set IsPolled = 1 Where CustomerID=@l_PrimaryKey

Select CompanyName, ContactName From Customers Where
CustomerID=@l_PrimaryKey FOR XML AUTO
GO

If you are still having problems, please provide a complete description
of the environment you are working in.

Good Luck,

David Carroll

.

Relevant Pages

  • Re: Use BiztalkUtilities adapters?
    ... I'm still not sure if you are working with MYSQL or MS SQL Server. ... I'm also assuming you've added a bit column to the Customers ... provided earlier is the FOR XML AUTO, XMLDATA added to the final query. ...
    (microsoft.public.biztalk.general)
  • Re: SharePoint Services
    ... I'm under the impression that the data tables can be uploaded to a SharePoint location, and that read / edit permissions could be enabled for different users??? ... It was common for customers to have accounts in more than one store / town ... ... However if you do not have share point services setup, nor do you have the expertise and training and resource personnel to run and set up those servers + SharePoint, **if** you users NOW have some type of connection to you network, then then I think the easiest and least amount of effort would be to simply put the backend database on SQL server and and link your front ends to that back end user. ... So, if these people are outside of your corporate network now, then expertise and ability to set up secure connections to allow them to come into your corporate network and pull data from sql server is VERY seriuos issue. ...
    (comp.databases.ms-access)
  • Re: FP/DOS 2.6 -> vfp9 report conversion
    ... There is an ASP.NET application that uses a SQL Server provider. ... about the platform. ... in terms of the installation and system that most customers have. ... So it's the marketplace and the repeat sales concept that I was stressing ...
    (comp.databases.pick)
  • Re: SQL Server Royalty
    ... would the customer, but this "royalty premium"... ... > to work on its database. ... > in house applications using SQL Server to other databases ... >>> customers this 'premium' if customers want to use their ...
    (microsoft.public.sqlserver.clients)
  • Re: Assume SQL Server Rights for apps, any cons?
    ... Since your customer is the sysadmin on his SQL Server box, ... >administrates the underlying SQL Server 2000 database by himself. ... >wants that my software assumes the user rights automatically from the SQL ... >My application offers a GUI to manage customers. ...
    (microsoft.public.dotnet.framework)