Nope. That's where Sybase breaks. You can do the sub-query as a select element provided only one value is returned but you can't have it as your "table"...

Can you detach the database? sp_detach_db

or perhaps some of the sp_dropmergepublication or spdropmergesubscription or sp_droppublisher....

It did handle the correlated sub-query but the problem remains that it doesn't pick up the last insert for code b (insert Test values ('b', 4)) because it doesn't exist...

One thought I had when you mentioned that you need to limit the number of connections is to have SQL Server simply write to a file a list of whatever...

According to the DBA here there is supposed to be a patch for this problem.

So, how are you dealing with reporting after removing the e-mails? I depend upon these...

I'm very curious if anyone finds a solution to this. It's very timely as a DTS job that I have scheduled for a daily run appears to have frozen...

My bad. I was using DBArtisan which, for some reason, only displayed 20.8. I tried it in QueryAnalyzer and got 20.800000000000001.

?

Does the sequence number actually need to be a "sequence" number or just a unique identifier? If it doesn't need to perform as a sequence number I would do...

This is definitely one of the longest threads I've seen yet. Could only make it through the first page.

I've used Sybase, SQL Server and Oracle. I learned Oracle...

Strange. This works for me:

create table t_test ( val1 float not null )

go

create procedure p_test

@val float

as

begin

insert into t_test values...

For data modeling I, too, use ErWin. Mainly because I didn't have to pay for it. I've also used Sybase's PowerDesigner in the past and found it quite...

For data modeling I, too, use ErWin. Mainly because I didn't have to pay for it. I've also used Sybase's PowerDesigner in the past and found it quite...

Well, hadn't seen the end not until I had played with this awhile. Came across something but it would need a little more work.

Here is my test table where...

1) What is meant by SELECT 1 is: IF EXISTS (SELECT 1 FROM... WHERE...)

2) Why can't you do something like this:

UPDATE tbl_TEST SET ... WHERE Email=... AND PW=...

IF @@rowcount...

WOW!!! THIS SITE IS SCREAMING FAST NOW.

I don't know if you simply installed the new server or found something else to tweak but I feel no more pain and...