When I write a query that uses the "for xml,auto" syntax it appears to
create a file.
That is what I need...for my web page to have access to this
file......

I'm trying to populate the list of available values in the second
parameter drop down list based on the value that had
been supplied by the user for the first parameter.
Example:

[SQL2000]
As part of good housekeeping, I would like to script out those SQL agent
jobs that have NOT been executed in the past 30 days. How to accomplish this
via a query?

Good night:
I have received a SQL Server 2000 stored procedure written by a fellow
developer that throws this error when executing:
ODBC: Msg 0, Level 19, State 1

I have an old sql proc that before we switched to 2005 had the old way
of trapping errors where you check @@ERROR, do some logic and then
raise the error.
I ran into a problem where a line of code erred in this proc that

I keep getting error with this function "Must declare the scalar variable
"@courseno" which I don't know what I did wrong.  Thanks for any help.
Han.
Here is my function:

Use TestDB
CREATE TABLE [dbo].[HdrYearly](
    [Licence] [varchar](6) NOT NULL,
    [SerialNumber] [varchar](6) NOT NULL,

Locksmith Los Angeles1-877-364-5264 Locks Installation Rekey Lockout
Services
Los Angeles Locksmth locksmith services, emergency locksmith, car
locksmith, auto locksmith, lock picking, locks and keys, rekeying door

This function keep giving me error "Must declare the scalar variable
"@courseno"  which I am not sure what I did wrong.  Thanks for any help.
Han.
Here is the function:

Hi all
How can I combine these 2 queries into 1:
Query1:
SELECT     empno, fname, lname

I have 2 tables and I need to make selection from one of them depending on
the data in the second one. I was able to do that by creating 2 views based
on tables and then the third view based on 2 views previously created.
I do not know how can I combine the statements in one ...

I have a Pallet table that has two Child tables, depending on the pallet
type.  The tables are very different (which is why I used two tables) but the
particular fields I am interested in are identical in both.
What I would like to do is to be able to select all the Pallets and

hi all... Now I'm stuck in a problem with a query.
I have a datetime field in one table, and I want to check if this
datetime is between the datetime intervals in another table, like this:
Table 1:

Hello, A vendor wants me to turn off the truncate log on checkpoint option on
a particular DB.  Checked in BOL and can't find it.  Can anyone advise?  When
I click on the DB and right click to see Properties, it hangs and doesn't do
anything.  Thanks, Pancho

How can I change the column name in a table
I'd like to do something like
declare        @td char(12)
set        @td = convert(char,getdate(),112)