I'm doing repetative calculations in my select statement below:
select client, path,
      str(kb/1024.0/1024.0,10,2) as 'GB',
      str(elapsed/3600.0,10,2) as 'Hours',

I am writing a stored proc for generating a report and it has below SQLs.
I am attempting to update the Premium and remittance basing on the source
id. But its not giving me the desired result. I am trying to update 34
columns basing on the source id.

I am getting this error "Timeout expired. The timeout period elapsed prior
to completion of the operation or the server is not responding."  And this
error pops up in 30 seconds.  Now the Sertver timeout is set to 600 seconds
or 10 minuted yet this is timing out in 30 seconds.  ...

I have a table with the following information/columns:
ServerName
UserName
PWord

Visual Studio database edition's schema comparison tool does a good job of
identifying all differences between two databases.
How do I go about doing this schema comparison directly in SQL server 2005
or 2008 and without the Visual Studio database edition?

Is there a way to create both stored procedures and/or views that are not
editable?  I.E. - a user cannot alter or see the code inside the procedure
itself?

Is there an SQL function that compares version strings?  I know it can be
done with CLR function using  .NET System.Version class
Thanks,
Avi

We have a table called Clients that allows up to 4 telephone numbers to be
entered.  I am trying to write a query that will identify if another client
has the same telephone number.  I need to look in any of the 4 fields.  E.g.
If Client 1 has a tel no of 555555555 in TelNo1ID ...

My tables have date ranges where the 'to' date can be open. I was advised not
to use nulls in date/time columns. How is this normally done? I was told to
put something like '12/31/2999' in there and test for that instead of null
but this seems strange to me.

In a sproc I need to issue a select, it returns five columns and always only
one row. I need to pass those five values back to the calling proc in output
parameters. Any of the five values could be Null. How do I do this? My 1360
page book (Wrox) does not show me. All the ...

Is there a way to capture the current SQL version into a variable?  I want to
use this to build a conditional in a stored procedure.  Do it this way if
your on 8.0 or this way if your on 9.0.
- Mark

I am trying to write a simple CTE query in SQL server 2005 as below:
WITH TPAIPCTE(PIN, PINCount)
AS
(

SQL 2000.  I want to find all records in a table that have special
characters (e.g. %, &, @, etc.) in the RateCode column, basically anything
other than a number or a letter (both upper and lower case ok).  My SELECT
stmt would be like

How can I display some specific defaults on some tables? For example some
tables may have a default on a CreatingUser_ID column that default the value
to suser_sid(). How could I display:
  1. table name

The following is the problem query.
MetricValue nvarchar(50)
Valid values for TargetValue can be NULL, '', or some other string.
INSERT INTO @M (ParameterID, EntityID, TargetValue)