Hello dwo,

Can you please post the actual DDL for the table and the index?  Sample data and the actual select statements you are using would also be helpful.

Thanks

Wayne

G'day,

In order to index a view, take a look at 'WITH SCHEMABINDING' in books online.  Your hosting company may or may not allow you to do this on their database. ...

G'Day,

DECLARE @TestString VARCHAR (25),

        @TestNum DECIMAL(20,10)

SET @TestNum = 125.4587878

SET @TestString = CAST(@TestNum AS VARCHAR)

SELECT @TestString, LEFT(@TestString,CHARINDEX('.',@TestString)+2)

SET @TestNum = 1.369888

SET @TestString = CAST(@TestNum AS VARCHAR)

SELECT @TestString, LEFT(@TestString,CHARINDEX('.',@TestString)+2)

SET @TestNum = 15487.9887

SET @TestString...

hmmm...

Sounds like the first few characters of FirstName may not be space characters.  You may be dealing with control characters.  Here is a snippet from some of my data validation...

G'Day,

I would try something like this:

UPDATE Sellers SET FirstName = LTRIM(RTRIM(FirstName))

I do this routinely when pulling data in from an external source.

Hope this helps,

Wayne

G'Day,

I googled: <OLEDB:Execution of the sql using arrays of parameters failed Database HR=80004005 E_FAIL> and found this link.  It appears that your error message is application specific, and is due...

Hello Damian,

I am going to turn your question around.  What file format will you receive the fingerprint?  What file format will the pictures be in?  Depending on the size and...

G'day

I googled "SQL SERVER READ REGISTRY".  The first link was this: http://www.4guysfromrolla.com/webtech/101499-1.shtml

From that link:

USE MasterEXEC xp_regread 'HKEY_LOCAL_MACHINE',            ...

G'day,

I use code similar to what you are describing every day.

An example is where you want to apply the same select to a dynamic set of databases.  Write a dynamic...

declare @MyVarchar  VARCHAR(25)

SET @MyVarchar = '0:00:00'

SELECT @MyVarchar, LEN(@MyVarchar)

SET @MyVarchar = '00:00'

SELECT @MyVarchar, LEN(@MyVarchar)

Hope this helps

Wayne

Hi Keith,

Do you have access to Visio?  One of the versions of Visio allows you to reverse engineer a database and includes support for all of the defined foreign keys...

Hi Helen,

Are you migrating data from DB2 to MS SQL Server?  Or are you migrating an application from DB2 to MS SQL Server?

Migrating data is not particularly difficult using either...

Hi Dave,

I'll get the ball rolling...  We need more information before we can help you out.  Please give us more of the proc you are using.  Also, can you expand...

G'day,

re: how to test the monster: Take a look at Mercury Interactive's web site.  Their LoadRunner and WinRunner tools are ideal for what you describe.  I have used their software...

G'day,

My opinion is that you do not really want to store the PDF in a DB.  At the risk of arguing semantics, you probably want to store either the contents...