In a stored procedure is it possible to excecute some SQL that returns a
single value and then get that value into a variable? thanks.

How can I do this from four dates in each record?

I will be using SQL server 2008.
If I have users accessing the system via web page then I don't want to always use their local date/time. Instead I will use the GMT
date/time. So let's say that I use GETUTCDATE() to capture the GMT date/time.
1. How do I convert this to my local ...

Is it possible to declare a variable in QA and run like few statement at a
time. I know this can be done via SP but just wondering if this can be done
with QA
e.g

I was going through a database and modifying a stored proc.
when i opened the stored proc using sp_helptext then it displayed the
body of stored proc in which the name of stored proc was different
for e.g.

I am trying to code an insert from a table in one database to another.  The
table I am trying to insert into has an identity field and so I am turning
on to allow.  My code is below and I am getting the following error:
IDENTITY_INSERT is already ON for table 'Filedata.dbo ...

In sql server configurations, named pipes (NP) is disabled and shared memory
(SM) is enabled.
using t-sql I am trying to find out whether or not they are enabled. See
below...

I'm working with SQL Server 2005 Management Studio. Is it capable of doing
code folding? Is it any tag I can use for hiding lines of code at will?
Thanks in advance
Sammy

I need to create sql login based on the query result from a result. (for
example, select memberid from membership where create_dt=getdate().  The SQL
login will have a default password as summer.
How can I do it?

I am using SQL 2000. There is a table Orders with Order information.
OrderID(PK), EventId(FK) to table Events
There is a table Events EventID(PK)
Based on an OrderId I have to calculate how many distinct events are

SQL 2008 rc0
I want to give a remote business partner access to my data on my home
network.  I would prefer to NOT open port 1433 on my firewall, for obvious
reasons.  Does anyone know if any type of web interface tool exists,

and if so what happens if I am within a cursor, can I come back to it and
continue?
Thanks.

I'm breaking some new ground (for me) by trying to output a Quark Tags file
from my sql 2k db. This is to create a classified directory.
A Quark Tags file is just a plain text file which has the text to be
formatted marked up with proprietary Quark tags. The text file contains ...

I have a script that creates several (4+) temp tables.  However, when I run
the script, it acts like the first two exist but the latter ones do not.  I
use the code
SELECT TABLE_NAME FROM tempdb.INFORMATION_SCHEMA.TABLES WHERE [TABLE_NAME]

I have a table of trials against several parameters that generate data, like
this:
parameter   trial   result_1   result_2
---------   -----   --------   --------