Hi Shehap, Thanks for the reply. It give the sum of values for the two groups team member ERP Jack ERP John ERP Mary CRM Robert CRM Diana CRM ERP...
Hi, If I have the following data how can I use the PIVOT statement to return it like team member -------------------- ERP Jack ERP John ERP Mary CRM...
Does anyone have any suggestions?
Hi, When using table partitioning where is the metadata which shows which partitions have had new data or which partition has had data removed. I...
yeah. At last The following was what was missing.RESTORE DATABASE Test FILEGROUP='FG01' WITH RECOVERY, REPLACERESTORE DATABASE Test...
Arghhhhhhhhhhhhhhhh. I'm going to explode. Or am I just thick? Please don't answer that. I am able to restore an additional FILEGROUP but then the...
Hi Frank, Thanks for the reply. I have taken a look at BOL and am a little bit confused what exactly I need to backup to make this work. If I use...
Hi, Please can someone advise if the following is possible? I have a production and a dr site with the same database on. If I have a table which is...
Hi All, I'm trying to insert some records from one table where they have corresponding rows in another. I have tried a couple of approaches. Please...
You could also filter on ObjectID and Number of writes >=1. This would help keep the noise down.
Thanks for your reply. I understand it is possible to use the use statement. What I have is a SQL Agent job which runs daily and and each day the...
I have a process which executes a number of times per day. when it runs a snapshot is created and a bunch of select statements are executed against...
Hi Satya, Thanks for your reply. I am a little confused by it though. I read this in BOL and I don's see how it answers my question. Please can...
Hi, Thanks for the confirmation. Regards Jamie.
Apologies if this is old hat. I was having a problem this morning with a production db. I was unable to run UPDATE STATS for a certain table. Which...
Hi, I was wondering if anyone had any suggestions for duplicating data in a column? What I want to do is update a column on a table i.e....
Managed to sort it. Thanks anyway.
I would like to do the following and am struggling. Please can someone tell me if I am flogging a dead donkey? I have DB1 that has one table that...
Hi Greg, Thanks for the swift response. It sounds like quite a good idea too. I shall suggest this to the developer. Thanks, Jamie
Hi, Is it possible to sysadmin from seeing certain data? I have been asked to come up with a method where managers can only see employee salaries at...
Separate names with a comma.
