I have 2 seperate queries which give me 2 seprate view objects, then I do
inner join between 2 view to get my result.  How can I do this with 1 query
using sub queries?
Here are my queries:

I am test some stored procedure that consists of a cursor. The procedure
utilizes pubs database. However, I cannot seem to get to compile it properly.
I would appreciate any help to resolve this matter.
CODE:

Is there any other method like the bcp that will allow exporting of header row?
go
declare @sql varchar(8000)
select @sql = 'bcp "select * from twc..vw_dvdn" queryout c:\123.csv -c -t,

1. I have a SQL2000 database which I attached to SQL2005.
2. I wrote a stored procedure containing a number of EXEC statements calling
other procedures.
3. When I try to save the procedure, I get the messages below:

It seems that we can't deploy in SQL Server, a UDT that contains an
enumeration.
I get the following message:
Error 4 Type "TestSecurityMichel.SecurityFilterContext" is marked for native

This seems simple enough; could even be a student's homework problem.  But I
am not a student in a SQL class, and I would like to know how to do this
using a view.  I c could easily do this using a cursor each time, but a view
would be better still.

I'd like to move my database files to my application's folder.
How can I do that?
Thanks

I have an aspnetdb database that has only a few items in it but it is still
2.5 megs.
Is there some way I can make it smaller?
Thanks

I need help with the syntax in getting only two decimal places in a division
calculation. Using SQL 2005. I looked up convert decimal but can't figure out
how to apply it in the calculation. I use the * 1.0 to get a decimal point.
SELECT     COUNT(dbo.CM.CMDate) AS [Calls Monitored] ...

Error: Executed as user: dbo. The EXECUTE permission was denied on the object 'xp_cmdshell'<c/> database 'mssqlsystemresource'<c/> schema 'sys',.
Could you please tell me how to fix

From the following tables:
************************
EXPENSES
Id_Expenses (num)

Is it possible for a SQL Server 2000 trigger to call a web service? One of
the fields in my database contains a lengthy XML string. When a new record
is inserted, I'd like to pass that XML string to a web service written in C#
so I can process it.

I have 2 tables - Table1 & Table2. There is a column named Col1 in
both the tables. Col1 is the PRIMARY KEY in Table1. I want Col1 in
Table2 to be the FOREIGN KEY of this PRIMARY KEY column.
How do I make Col1 in Table2 the FOREIGN KEY using the ALTER TABLE

I have created a view, that is pretty fast when getting the records.
One of the fields is a date that I use to get my data for a certain
period of time.
I now find the following:

I have some SQL that I want to return all agents that are not returned
by a statement. I am using a WHERE NOT EXISTS statement around the main
statement to do this but it doesn't return anything where it should
return 2 agents.