Yeah, good discussion, then where does the conceptual layer fit?

I expect that you are bringing DateTimeStamp, comment, and Weight  from table S. One way to get denominator of the Select [Percent]  is by using temporary tables, storing the result...

Try something like this, if your data limit does not cross 4000 characters.

create table x

(a ntext)

insert into x values ('www.sqlservercentral.com')

update x

set a = cast(a as nvarchar(4000)) + ' is...

Can you explain the error that you are getting from the asp page.

Use @@RowCount

@@RowCount returns the number of rows affected by the last statement.

Extract from SQL Server Books Online

This example executes UPDATE and uses @@ROWCOUNT to detect if any rows were changed.

UPDATE...

My assumption says that you are joining all the tables and placing the data into a temp table at runtime in a stored procedure(sp). If its true, and you are...

Try this

Declare @userid int

Set @userid=001     -- Some UserId

Select UserId, TradeId,

 Case

  When Exists (Select * From Bank Where (StartValue =0  And EndValue = 0) And (UserId=@UserId)) ...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp

Declare @a int

, @s varchar(1000)

set @a=2                          -- Say some value or parameter

Select @s-2 =

'select distinct convert(varchar(10),au_id),au_fname from authors

order by ' +

 Case (@a)

 when 1...

No, I am not getting it, the following error is raised

'could not find server  '10.1.121.77' in sysservers. Execute sp_addlinkedserver to add the server to syservers'

If you want to use Order By for every select clause of union clause then you need to use the TOP clause like the following

Select * from (

Select TOP 1000...

Try trimming i.e. RTrim

You can try something of this sort using exec, the code will reduce.

CREATE PROCEDURE spReportCoordinatorTimeTracking

 @coorid bigint = NULL,

 @begin datetime = '1/1/1900',

 @end datetime = '12/31/3000'

AS

CREATE TABLE #Final (

 Protocol varchar(41),

 PIName...

Here're some links for you - the first seems to have what you want!

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=183331#bm184520

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=181191#bm181614

Can you explain in detail with an example please. are you looking out to execute ddl statements dynamically?