I have a stored procedure that returns a select set and I want to use the
result of that SP within another stored procedure.  But I have not figured
out the syntax and I'm not sure it can even be done.  Here is a simplified
example.  Can anyone show how this is done for real.  ...

please help me understand mysql file format or or any related links
would also be very helpful

Basically, I am trying to get invoices in a specific finacial year. See
below. So, if I start with 2008 I will get 2008/2009 between 6th April 2008,
and 5th April 2009.
declare @targetDate as int;

Hello, I have a table with complex primary key( consisting of two fields ).
MSSQL2005
Example:
CREATE TABLE PersonPhone(

I am using SQL Server 2000 and have written a fucntion that I would like to
include in a view. The function returns a decimal value.
When I go to my view, right click and select "Add table..." and then click
on the "Functions" tab, there is nothing there to pick. What am I ...

I have asked in some question before about use a select by choosing table you
want, this is like:
DECLARE @Table VARCHAR(20)
SELECT @Table = "tblSome"

SQL 2005 (and 2008):
I need to know if the results of this UPDATE statement are "undefined"
(as documented in Books Online) or not.  It seems that I need an ON
statement (like when Update is used with Inner Join), but SQL doesn't

How can I contruct a statement like such which may return many values
(@type)
select @type = "select type FROM hlsoccupancy
  WHERE hlscaseno = @hlscaseno = AND seqno = @seqno"

I have 3 tables:
create table dbo.Files
(
 FileID uniqueidentifier not null

Is some posiilities to connect SQL Server CE from Delphi 5 ?
I'm trying ADOConnection (OLE DB), but without result. One what I done is a
message box with "Unknown error" text.
Waiting for any sugestions.

I have to go to all tables within a database and assign a default value to
the column DATE_CREATED. I am considering creating an automated script to do
that. Is there any existing tool for these kinds of global changes?
Thank you,

Below statement works fine in 2000 but in 2005 it fails because All is
deprecated . What can be used in place of ALL for 2005 version
SET Grant = 'GRANT ALL PRIVILEGES ON /* ' + @object_type + ' */ ' +  ['+
@object_name + ']'+ 'TO Dev_user'

When I issue the following search in my page 07/06/1975, the SP returns
records with a date value of 06/07/1975 as a match.  Where do I change this
setting to match on UK format?
Regards

I have a very strange problem.
I'm working with 2 servers with sql 2000 SP3.
Linked server has "Microsoft OLE DB Provider for ODBC Drivers" as
provider.