Search results for query: *

Thank you everyone for your helpful thoughts. I've modified the query to include fewer sorts, and added a few indexes to the tables in question. The query has gone from 12 minutes to less than 40 seconds - primarily due to the indexes. THANK YOU AGAIN, Ben

Good day everyone, Thank you all for taking the time to read my question. I have a Database that I've inherited from a merger with another company. A legacy peice of software interfaces with this database - so I cannot change the schema at all. The database consists of four tables...

Forgive me, but i'm unsure what you mean by 'signed'. Ben

Good day everyone, I have a problem that was noticed by one of my users this morning. We have an Exchange 2003 Sever running on Windows 2003 Server. Clients are Outlook 2003. Suddenly, some email (mostly older messages) are 'missing'. The header (who it's from and subject) shows up in...

THANKS!

Hi all, can't that you enough for the help I find on these forums.. One (Hopefully) quick and easy.. I have a column in a SQL 7.0 database called 'area' which is of type 'int'. In a view, simplified of couse, I would like to; SELECT header.[area] / 10 as smAREA FROM sp50devel.[dbo].[header]...

Hmm... That actually seems to have worked, however, I'm confused. Even if there are leading or trailing blanks, i'm comparing plx_name with plx_name, so shouldn't it match WITH the blanks, and NOT Match without? " ABC " Doesn't EQUAL "ABC", but " ABC " DOES match...

I switched header."plx_file" from text to varchar(50), and am getting the exact same results. The query as written returns an empty set, but if I replace the ( SUBQUERY ) with 'IT-E03184A' I get the 10 records that I'm looking for. Thanks for all your help so far, hoping you can get...

I could switch to VarChar(50) in that case. Would that help make the Query function properly? Correct, circuit names are less than 50 charachters. Thanks for you help, Ben

Unfortunately, Yes. It is the actual name of a circuit board. It is unreasonable to request our engineers to name all of their boards using only 0-9 charachters. Ben

The text, ntext, and image data types are invalid in this subquery or aggregate expression. State: 42000, Native: 279, Source: Microsoft OLE DB Provider for SQL Server The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. That's what I...

Hi All, Hoping someone can help me with this. SELECT TOP 10 header."uid" FROM sp50devel."dbo"."header" WHERE header."plx_name" LIKE '(SELECT TOP 1 header."plx_name" FROM sp50devel."dbo"."header" ORDER BY...

Try having the users login using DOMAIN\USERNAME instead of just USERNAME. It worked for me.

Is there a way in Windows 2000 Professional (and NT4 WS for that matter) to prevent people from changing the domain during login? We don't want anyone to be able to login to the local machine - ALWAYS to the domain. I would like to just delete or grey out the 'Domain' Selection box at the...

I am new to Cisco Switches, and have one that we picked up through a company merger that is failing on POST. I have captured a console output of the post sequence, and have attached it to this message. after POST, the 2x port light stays on blinking amber. If someone could diagnose this...