I do I convert a field that is "smalldatetime" to "datetime"?
I am doing a select statement from a table and need my output to be
"datetime".
Thanks,

Is there a way to quickly run an sql query against all the tables in a
database? or will I have to simply write a line for each table? I have 100+
tables where I want to delete rows from from them where ID= (a particular id).
Thanks

Hello, I have a table that lists my bank transactions.  I have a uniqueid in
the first field and several other fields....one of which is DATE.... now, I
want to run a query where my view is based upon the DATE.  however I want to
only show transactions that are the same date as ...

I have a query who returns different result for different user.
This query is just a "SELECT" from a view (or a function), like this:
Select * From MyList('12345', '67890')
When I logged in as "sa", it returns > 3000 lines (this is the number