First off, is this a SQL Server linked server? If not, then sysobjects very well may not apply. If it is SQL Server, what version? If it's 2005 try this:

select...

Hey GS, I like those approximations. I don't think we're talking interplanetery landings here so it should be close enough. btw, when I've used a "locate store" function on a...

I can't disagree with it either 😎

You missed the fact that the function returns all zips within a specified radius. It needs to be TBV'd.

Try this...

SELECT

mytable1.dbo.app_TelephoneDetails.FirstName,

mytable1.dbo.app_TelephoneDetails.LastName,

mytable1.dbo.app_TelephoneDetails.City,

mytable1.dbo.app_TelephoneDetails.State,

mytable1.dbo.app_TelephoneDetails.ZIPCode,

Ufn_GetLocationsInRadius.distance,

...

David, rather than create 3 separate flags in one table why not create a "guestscount" table like...

id NumGuests

1 1-4

2 ...

Glad I could help Simon.

Now your next goal should be persuading the "higher-ups" to migrate completly from MySQL to SQL Server.

Doug

Simon, no such errors. Start with something simple. Just select from the MySQL linked server in SSMS:

select * from OPENQUERY( MySQLLInkedServer 'select * from MySQLTable') to validate that the...

Simon, my work was primarily migrating from MySQL to SQL Server and it was done through the use of a Linked Server and the OPENQUERY command.

However, it is not too...

It's really only important if the value is NOT zero.

Are you seeing a lot of blocking?

DAB

Syntactically, yes, the view is correct. But is you want ALL the rows from both tables where the keys match PLUS all the rows from the first table (regardless) the...

ok..

Table1 has M columns with X as primary key, Table2 has N columns with Y that relates to Table1

The following examples are based on number of rows, not some key...

As the database begins filling up pages, yes, your PLE will drop. That is not a bad thing, Going below 300 is. One thing to look for are distributed queries...

Look at Grant's idea about setting up a regular process in Perfmon that saves the results to csv. Then use the Relog tool to load that into a db. And...

Do you have schema data for the table and code for the view?

DAB

Can you please provide a little more information? Is the data coming from a website, other data source (Excel, etc)? Using an nvarchar data type will enable you to store...