In an sproc is there any problem in having an output parameter being set from
an output parameter of a called sproc. e.g.
CREATE Procedure dbo.ESIMonthlyNC
(

Hi, I have two fields of FLOAT type :
(1) OriginalBilledCharges
(2) BilledCharges
Here is my code:

Using SQL Server 2000, in Query Analyzer both of these statements
properly return "This is NOT null" for columns that are null.  The first
uses 'simple CASE' and the second uses 'searched CASE'.  POLICY_ID is a
char column.

I have a int field in a table that stores bit values for example:
0 -view
1- edit
2- delete

I have a table calle [field_definitions] that has the fields [table]
and [field_name].  These fields refer to other tables and field names
in the table.
what I want is if I do the following I want the value to return the

I happened to migrate my database from SQL 2K to SQL 2005. Pretty much
everything went well when I simply did backup in SQL 2K and restored it
into a pre-created database in SQL Server 2005. Here is the issue I am
trying to address

how do I create a login so that other databases can not be listed with the
SQL Server Management Studio.
When I do this, I can see other databases:
CREATE LOGIN MyTable WITH PASSWORD='Password', DEFAULT_DATABASE=MyTable,

I have a query that join multiple tables together: emp, person, job. The
result give me duplicate empno, if that employee have more than one job.  
I just want to get unique empno to display, with the latest startdate,
regardless how many job that they had

I have this employee table, want to show unique empno with the latest
startdate.  If the employee have more than 1 jobno, then select distinct keep
showing all jobno for that employee.  All I want is just to show the record
of that employee with the latest startdate, regardless ...

My SQL Server / SSIS and tools build is currently 3161.  If I shutdown my
machine, it automatically installs Hotfix 3233 and breaks my SSIS designer.  
If I try and add a Data Flow task to an existing package I get the following
error:

My table is a history of entries that changed the price of a book
ex. on March 15, 2007  books price was changed to 5.00
     on April 22, 2008 books price was changed to 5.75
     on April 29, 2008 books price was changed to 6.00

ALTER    FUNCTION dbo.getfaelligkeitsueberschreitung_in_tagen( @belegnummer
bigint , @belegdatum smalldatetime )
RETURNS int
BEGIN

I have a stored procedure with 4 defined parameters that will be populated
with dates from select statements...  The parameters are defined as
@BeginDate datetime, @BeginDate1 datetime, @EndDate datetime, @EndDate1
datetime.  I need to find the lowest value of the two @BeginDate ...

People,
I need to substitute the text ‘test’ in the select (see No 2) – does
not work and I didn’t expect it to because it should be done like No
3.

When I try to install SQL Server 2005, I get an error when trying to
configure the OWC11 (office web components). It tells me it cannot
find the
required files and suggest I look into c:\Program Filess\Microsoft