I need to access a COM object (C++) from a stored proc.  the interface is too complicated for SQL (using sp_OACreate and
the like) so i thought i would write a .net proc as a wrapper for the COM object.
I don't see how to add a reference to the COM object.  When i try to add a ...

Hi i'm trying to reproduce this query using temporary tables, i need to make
it faster
SELECT rough_ID, naasra, road_ID, end_m, direction FROM rough
WHERE EXISTS

Can anyone help me with "incorrect syntax near 'cte'"?
Thanks in advance, Lars
with cte
as

I have a table with state field, if the state is no correct we have XX as
state.
how can I show in my report the XX first and the rest of states after in
order like:

I have a table Orders with OrderId(PK), EventId(FK to Events)
OrderId                          EventId
2                33
2                38

I have a table Orders with OrderId(PK), EventId(FK to Events)
OrderId                          EventId
2                33
2                38

I'm sure that this question has been asked hundred's of times but really
don't know how to search for it.
I have 3 fields that contain street address information.  
The fields are PrimaryAddress, PrimaryAddress2, PrimaryAddress3

I need to upload a file from .xls that have following columns:
Emp     Dept
A          5
B          6;8

I'm in the process of building an insert and update stored procedure, as one
of the fields involved in the insert can contain so much data, I'm using a
field type ntext, the problem that I'm having is that my stored procedure
doen not recognise the field type ntext?

ALTER TABLE MyCustomers ALTER COLUMN CompanyName SET DEFAULT 'A. Datum
Corporation'
follwing error comming
Msg 156, Level 15, State 1, Line 1

CREATE TABLE [dbo].[ASSESSMENT](
    [est_id] [int] NOT NULL DEFAULT ((0)),
    [overall_assessmnt] [float] NULL,
    [bldg_assessmnt] [float] NULL,

I have a webform that enters records into a basic database. I would
like to retrieve every record that was inserted today as well as the
last one from the previous day. Any suggestions?

Apparently this is not legal t-sql :
update table1 t1 join table t2 on t1.t2id = t2.id
set t1.col1 = 'new value 1', t2.col2 = 'new value 2'
Why doesn't t-sql allow this ?  Is this inability a function of the db

I have a table as follows
col1-----col2-----col3-----col4
---------------------------------------
30        1          11       111

I have to convert VB function to SQL:
Function CalcCompItem()
    Dim mValue1
    Dim mValue2