Using dynamic SQL try this:

CREATE PROCEDURE AddnewServiceCategory

(

@tablename nvarchar(50)

)

as

DECLARE @sSQL nvarchar(500)

SET @sSQL = 'SELECT ' + @tablename +'.Funder, ' + @tablename +'.[Facility ID]' +

' FROM ' + @tablename

PRINT...

Second thoughts ... myself being a VB programmer ... I can understand how your apps were written ... to convert them can be a daunting prospect... in general what T-SQL...

This should give you the users name -- test it and see if it does

suser_sname()

Assuming that all user updates, deletes, inserts are implemented via

stored procedures Here is an idea for you to consider:

1. Create a table to record the data collected, such as:

CREATE...

This answer is based on a few assumptions, and yes I do know what this translates to .... but here goes.

If all you want to do is to dynamically view...

Having been a plant manager for a manufacturing facility and as such I learned that the personnel department's (now known as Human Resources) major function is to weed out applicants...

Thanks for your unique point of view - it works like a charm ... will be added to my bag of "tricks"

Steve as one who has suggested a review panel, let me say it was without knowledge of what you and others have done in the past, for that I apologize....

Getting tired, so very tired of sloppily worded questions ...

dob not defined as a column name in the table or for that matter anywhere in question ... so it...

You have to believe me - read this article at 10:55 PM.

It appears to be all of what you might need. Give it a try

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1308141,00.html?track=NL-414&ad=633481&asrc=EM_NLT_3420820&uid=667360

If you do not have a text file with all your SP's text. This might be an additional aide to store the text of all your SPs. Run this SP...

Many thanks for your script. In particular the inclusion of the 'null bit map' - something I did not really consider. Have taken the liberty of adding your...

Here we go again ....

For Steve and others - might I suggest asking a few users to form a panel to check the questions BEFORE they are published as...

Looking at sysobjects with

SELECT name, xtype,base_schema_ver,schema_ver,refdate FROM sysobjects WHERE XTYPE ='p' ORDER BY Name

1. Ran the query

2. Went into the sp and altered same

3. Ran the queriy again

Results

Column ...

Other possible aids

Applies to:

SQL Server 2005 Reporting Services

Excel 2007

Word 2007

http://msdn2.microsoft.com/en-us/library/aa964136.aspx

Found in a blog:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2524069&SiteID=1

SSIS sql server 2005 uses...