How abt this....

select (select count(*) from TableA )+(select count(*) from TableB ) as total

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11585

Comments posted by Frank Kalis on the order of execution of the FROM and WHERE clause gives insite into the query execution process.

There is a whole tread dedicated on this topic on http://www.sql-server-performance.com

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11585

I know that using exec, you can have a variable name in the from clause.

exec('Select * From '+ @Tbl Name)

Hoping this helps...

Looks like the solution for this problem and a lot more  is in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=242919

Thanks,

Chandra

select substring(companyname,len(companyname) - 2,len(companyname)),companyname from customers

this is a query that returns the last three characters from northwind database

Does it help if we can generate columns in a temp table based on values in Attribute_name and insert values in the temp table.

Create Table #temp1(

column1 int

)

Declare @col2 as varchar(10)

set...

Does this work for u

sp_helpindex <tablename>

it gives the indexname , index description, index keys

http://www.itrain.de/knowhow/sql/tsql/pivot/sp_transform_v1_1.asp -  construct a sp that pivots the columns as rows and stuffs data in it. I dont think you are looking for an sp as a solution but it...

select dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate()  )+1, 0))

more date formats are discussed in this article where I found this solution

http://www.databasejournal.com/features/mssql/article.php/3076421