Database

Lil Turtle wrote:

I am working with sales data from a table joined to several other tables(confusing I know).

Lil Turtle wrote:

My question is whether or not there is a way to combine all the data for one company name and be able to get totals for ie: price, # of sales, etc. I've tried using a group by statement, but as I need all the column data from the original table I'm having to group by every column name.

GETEL - General Telecom wrote:

I am only one administator of SQL 2005 database , I want to divide database in seven administration levels !

Colin Angus Mackay wrote:

My question is return is: What do you mean by an "administration level"?

Paul Conrad wrote:

Would this be different user roles?

VK-Cadec wrote:

Is there a way I can select out this value from across all the tables in a particular database

SELECT * FROM Table1
UNION
SELECT * FROM Table2
UNION
SELECT * FROM Table3

DECLARE @sql nvarchar(4000);
DECLARE EventCursor CURSOR
FOR
SELECT 'SELECT * FROM ['+TABLE_SCHEMA+'].['+TABLE_NAME+'] WHERE eventNum= @eventNum' 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME = 'EventNum'
OPEN EventCursor
FETCH NEXT FROM EventCursor INTO @sql
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC sp_executesql @stmt = @sql,
         @params = N'@eventNum int',
         @eventNum = 4 -- Replace this number with the desired event number
                       -- or a parameter that represents it.
    FETCH NEXT FROM EventCursor INTO @sql
END
CLOSE EventCursor
DEALLOCATE EventCursor

Ennis Ray Lynch, Jr. wrote:

Don't listen to the naysayers. Using T-SQL you can

DECLARE @sql nvarchar(4000);
DECLARE EventCursor CURSOR
FOR
SELECT 'SELECT * FROM ['+TABLE_SCHEMA+'].['+TABLE_NAME+'] WHERE eventNum= @eventNum' 
FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'EventNum'
OPEN EventCursor
FETCH NEXT FROM EventCursor INTO @sql
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC sp_executesql @stmt = @sql, 
        @params = N'@eventNum int', 
        @eventNum = 4 -- Replace this number with the desired event number 
                      -- or a parameter that represents it.
    FETCH NEXT FROM EventCursor INTO @sql
END
CLOSE EventCursor
DEALLOCATE EventCursor