I have a table with a branch code, pay date, hours & description.
within the description field the options are either Actual or budget.
id like to create a query to add to my reporting services dataset that works
out the differnce between the budget & actual for each pay ...

I have made the following test stored proc that all it does right now
is accept a string variable that will be a list ie. :5,9,6,13. Right
now all the SP is doing is creating a temp table to store the values in
the list, then looping through the list and inserting the values into

I have two tables.
The first one is called Protocols and contains the following columns:
ID (table key)
Name

Is it possible to move the distribution database to a new folder/drive
without removing replication? I am attempting to do it the same way you
would move tempdb:
ALTER DATABASE distribution MODIFY FILE

I was running an MSDN version of SQL 2000 Developer Edition on a server
until I accidentally upgraded it to Enterprise Edition while attempting
to install some Management Tools. Is it possible to downgrade it back
to Dev Edition?

-- Business Rule, first name, middle name and last name can all be null
-- ddl
create table #cat (catID char(8) primary key, first_name varchar(15)
null, middle_name varchar(2) null, last_name varchar(15) null)

                                                         OMNI GROUP
                                                   tgugger@aimexec.com
                                T-SQL/ CONTRACT TO PERM/  ATLANTA
    I'm looking for 1-2 TSQL developers for a 4 month contract to hire

my structure table in database:
Amount float(53) not null default 0
when i try to run his script:
alter table ABC alter column Amount float(53) null

How do I change the Authentication for MSDE 2000 to SQL? I cannot connect
using the sa login but I can connect if I say it is a trusted NT Connection.  
Help Please.

hi gurus
have a employee table which consist of the normal employee related
fields which the fields empid and supervisor mainly related to this
question.

Hi groups,
which is the best one among JOINS..?
Comparison of joins if any..?

People used to design database systems with date column as varchar or text in
earlier days. Why was that ? Is this convention still used in todays world of
Relational databases like MSSQL Server ? Is there any particular advantage in
using varchar ot text over native Date ...

This is my table:
Ordernr    Date  Article
O1        1.1.05   22
O2        2.2.05   33

I have a stored procedure which is performing a search against a "task"
table. I would like to pass in a variable called @strAssignedTo which
will be a comma delimeted list of employee ID's ie: "5,6,10". So my SQL
without this variable would be something like:

Can someone tell me an easy way to update all my views/queries that are
dependant on a table after I alter that table?
If I delete a column from a table, all my views that are dependant on that
table become incorrect. I've been opening each view individually and simply