please research if you can use Pivot table in t-sql, does not limit how many columns in the string or data

SELECT [Emp Number], SUM(Amount) FROM [" & PayrollSheetName & "$] " & _

" WHERE Code NOT IN ('GST','TAX', 'COMM') AND Ty NOT IN ('A','C') AND [Cr Ind] =...

the client want to just populate those values in the columns they provide me and they don't care if values are same.

thanks all.

thanks.

the question was can one column that exists in all the tables in a database be used as a primary key for each table and foreign key for each...

sorry, I did not mention that this tables are just for demo and not actual tables

and I was trying to show you that UID exists all the tables 31...

I WOULD RIGHT CLICK DATABASE AND CLICK TASKS

SELECT GENERATE SCRIPS

AND SELECT, SELECT SPECIFIED DATABASE OBJECTS OPTION AND SELECT OBJECTS TO SCRIPT

AND SELECT WHERE TO SAVE AND YOU SCRIPT OUT ALL...

just keep trying ploting in different strategies of getting to where you want to go DBA or else. and one day you may realize you are where you wanted to...

Compare all the database settings and logins for working database and the one not working.

I would add Alan.B tips, check unused indexes and statistics update is on

yes, its fixed by re-starting windows server and that stopped the litespeed that is causing the issue with the database

thank

you are right, full log was not the reason database became suspect but

lite speed was blocking while database was trying to recover some transactions

thanks

I don't think there is a job Like Production DBA when it comes to pressure and worries about what may happen next minutes on your watch.

I hopeful, there has to...

good articel about people mentoring each other

http://www.sqlservercentral.com/articles/Editorial/67977/

you have a good point: I'm a fit for what I'm doing now, but do i want to do these things forever.

to understand where I'm coming from, I was DBA...

thanks those are very usefull resources and i use them specially mssqltips.com articles and scripts

and microsoft Virual lab for High availablity labs.

all those resources are availble and i can use...