Can anyone help me create an expression for a column in a query that holds
only the date portion of a smalldatetime column? I've tried DatePart and had
a look around for other functions but I couldn't find anything. Thanks in
advance,

We have a legal copy of Sql Server and want to use Sql
Reporting Services.  Where can we download a real copy
not a test or time-limited one?
Thanks.

2004-08-21 11:52:38.64 spid52    Error: 0, Severity: 19,
State: 0
2004-08-21 11:52:38.64 spid52    language_exec: Process 52
generated an access violation. SQL Server is terminating

I need to create sequence numbers for a column in a table,
I wanted to find out how can I create it?
I have a column, depending if the file type ='A'
the fileNumber should be 'A001'

How can I replace null value of a column in a query
with something like 'TEST'
for eg. if I run the query
select contract_num, prodid from product

Dear Anyone,
I am no expert with SQL server but I am trying obtain
some data from this server using SQL syntax, I would like
to average out the data by correction_col_date below, can

how do I find all records that were created before
today minus 150 days. I could easily do this in MsAccess
by doing the following
by filtering off of the Date created field using the

I have duplicate records in a table based on say
OrderNum, I would like to copy 1st record for each
OrderNum from this table into a new table and then update
the OrderNum record in the 2nd table with values from

Is it possible to do updates to a grid result from the
query analyzer?
i.e.  select * from ABCD gives a grid result (w/ PK cols),
can I edit one or more fields in the gride and update ?

I am trying to sort a really large file of information
and I need some help as I cant work out how to get some
of it.
the fields I have are:

I have created a Job that uses "cmcexec" to execute a SQL script.  This Job
brings SQL to single_user mode then restores from a directory that is local
to the server.
1) When I run this restore in the GUI it takes 15 minutes but is still

I am looking into storing images into SQL and want to use BLOB which I
understand to be the best method. Can someone supply me with a simple
example of how to import a file into the database?
Thanks in advance,

Im relatively new with sql and im having a problem
creating a criteria based on todays date less 150 days.
I tried to use the following...
  < GetDate () -150 however it will not let me use this.

I tried to renaming database using query analyser of sql
server 2000 but I got this error msg.
Server: Msg 5030, Level 16, State 2, Line 1
The database could not be exclusively locked to perform