I have this query in SQL 2000, I get wrong answer
SELECT B.ID, ISNULL(B.ID,'Is Null')
FROM secuenciales A
LEFT JOIN (

Is there a way in T-SQL to update several fields of a table with fields from
another table using a select statement based on a key? I remember doing that
in Oracle. If so, can you please give me the syntax. Thanks.

I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted.  The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z.  So when the VPN
comes up using a private IP, I can't connect to any of the FTP ...

I have a select proc that will take a bunch or criteria parameters. Based on
how many are not null I would like to decide how many inner joins to do.
for example:
select H1.Priceid as HotelPriceId,H2.Priceid as AirPriceId,

Whats the maimum number of stored procedures you can have in one database?
Would I notice any performance degredation if I had over 2,000?

I have a table with a date field.  I need to convert the date so that it
returns in a text format of DDMMYY - no separators.
How do I do this?

I haven't been able to find an answer to this simple question from any of the
online documentation. In table design view, each one of my columns has a
datatype and length. Specifically, I have a column of dataype "ntext" with a
length of 16, but I don't know what that "16" means. ...

I've been unable to find a way to write the following
query.
Assuming this table:
Year        Quarter

Hi! I ran the upgrade pack for Microsoft last night and
now my localhost on my laptop won't work. I use SQL to
demonstrate a website on the laptop but the "homepage" -
http://localhost won't open.

I've a problem with a trigger :
this trigger update a file with an index field but it's return an error

parameters

 I have requirement.
 I want to format a numeric value with commas. is there
any function to use in transact-sql query to do this.
for example if the numeric value is 27519.37 then it

I have some SQL-statements that are very slow, and I'm wondering if I can do
this in a more efficient way.
The problem is that I need to list out _detail information_, but the where
condition check _sum of the group_.

Does anyone know a (relativly) easy way of keeping records in their created
order? (or a specific order, and maintaining that order through
additions/deletions/changes)
I'm interested in a general method (ie, works for everything), but I'll use

I have a db with a table that records details about order transactions.  The
main columns I am concerned about are the "Transacton_Type" column and the
"Date_Time" column.  Each order has more than one transaction/rows in the
table (ie. Pending, Shipped, etc...), with each ...

I need help in constructing a query against my Db I have.  The DB I have has
122 Tables and 15 columns in each. I have information in a column in one
table that I need to query with data in a column on another table. In other
words, In Table ad, i have a column called ENTRY_ID ...