You need to use dynamic sql.

Declare @name as Varchar(80), @sql VARCHAR(8000)

Set @name = 'QCP_HRA'

SET @sql = 'SELECT * FROM ' + @name

EXEC (@SQL)

First don't use User, it is a reserved word.

DECLARE @User VARCHAR(30)

SELECT @User = User

SELECT @User

________________________

dbo

There are a few syntax errors.

select distinct

Case -----take out the O.empid

when (O.empid in (select e.empidfrom FROM...

In most companies I worked for only had one platform, so portability was not the issue.  Unless you are talking about moving the data from the CRM system which uses...

I agreed with Chris.  In most of my database design, city, state / province and zip are all in one table. 

I have some questions about your problem.

1.  Is each document has one filename ? 

2.  Does each page has its own category or each document has its own category?

In your design,...

I have a different point of views.  First both companies are US companies and both were found by young US computer guru.  I had a chance to listen to Larry...

Karma,

You are right. I am a perfectionist. I try my best to do everything in the best way.  When I see some develeopers writing lousy codes, the system behaves strange, nobody...

I tried to do the meta data long time ago.  It is basically a full time job. Everytime something changes, you have to change the meta data.

I used to do some...

We use SQL Server 2005.

In order to update TableA from different sources at the same time.  If NOLOCK can only work on SELECT, can we use ROWLOCK.

UPDATE TableA

SET Field1 =...

I don't want to argue but just want to make sure the fact.

This is the website explaining the difference between Kimball and Inmon approach.

http://www.1keydata.com/datawarehousing/inmon-kimball.html

Bill Inmon's paradigm: Data warehouse is...

You are right, an enterprise DW (central DW - as Ralph Kimball's DW approach) is very hard to accomplish.  Most companies jus do data marts for certain departments and projects...

The data warehouse and BI concept started with Bill Inmon's OLAP concept and Ralph Kimball's enterprise data warehouse in the late 90.  I was working for a software company at...

Steve

I want to know how's the break up sessions of the conference.  Do they provide adequate information?   When I looked at the agenda, 2 hours of break up session talking...

Junior DBA, Senior DBA, Application DBA - all these are titles which meant nothing.

For all these years, my title included 'programmer', 'Senior Programmer', 'Computer developer', 'technical specialist', 'Oracle ERP...

My co-workers went to the conference too.  They said they only allowed 1500 attendees and they just registered last week.  I did not think it was very popular conference.