select subs_no from some_table where  (isnumeric(some_column) = 0) OR some_column IN ('+', '-')

-- i believe these are the only exemptions from the isnumeric function. If there are othere caracters, just...

Select UserID, SubscriptionID from YourTable

group by UserID, SubscriptionID

having count(cast(UserID as varchar) + '_' + cast(SubscriptionID as varchar))>1

I would go for Gail's advice.

Before doing so, change your database recovery model to bulk-logged. Use bcp to copy the 1M rows, truncate your table, then use BULK INSERT to...

Your problem may not just be in SQL Server. It shouldn't take 14hrs for 1.5million rows only. Can you give us your server specifications please? I'm thinking you might be...

Hi, I'm an SQL DBA in The Philippines with MCDBA, MCSD, MCAD, MCT certifications.

Do you sponsor a working visa??

RonaldS@pcmall.com

Hi, I'm an SQL DBA in The Philippines with MCDBA, MCSD, MCAD, MCT certifications.

Do you sponsor a working visa??

RonaldS@pcmall.com

Good thing I read this thread. Now I know whom to consult when I pick my lotto numbers.

You can alter an existing check constraint or change the constraint expression but only thru the Enterprise Manager.

I see. I'm not sure if COLLATE can do the trick. I'm unable to test as I do not have the data for the different languages.

ALTER PROCEDURE [dbo].[web_getCustomisedDetails]

(

@varProductCode

char(25),

@varCompany

char(10

The best way to improve the performance is to analyze your query on the view. Try to see its query execution plan and find out what's causing the slow performance...

Not the old syntax...

USE Northwind

select * from Customers c join orders o on c.Customerid = o.Customerid -- INNER JOIN

select * from Customers c left join orders o on c.Customerid =...

Also, use a temp table instead of a table variable. You cannot use

insert @TableVariable exec ('select 1')

in SQL 2000.

Try

Create  table #X (

 c1 varchar(10) null

&nbsp

"

I went in just now to look at some tables and I started getting all sorts of error messages...including one where I couldn't even look at the design of a...

Odd... Hmmm...

Try this.

Select case when 'test' like 'test     '

 then 'The Same'

 else 'Not The Same'

 end