this will do the trick

select custname, region, upper(left(amount,3)), amount1

from

(

select

custname, region, janamount, febamount, maramount, apramount, mayamount, junamount, julamount, augamount, sepamount, octamount, novamount, decamount

from #test) t

UNPIVOT

(amount1 for amount in (janamount, febamount, maramount,...

fish sticks

1st error, lookup requires 4 parameters, if you used my above expression it only passes in 3.

2nd error, you have a extra function like MIN/MAX/AVG/SUM etc somewhere else which is...

please post the table definition and a couple of sample data rows

the expression isnt complete, its missing 2 closing brackets

this is just my personal preference but i like to format brackets like this so I can see how many (...

if its just a page then its controlled locally and GP will not override any settings that you add in manually unless the folders in the tree are locked like...

sorry i ment at the root level

the last screen before the import runs is a screen which says, run immediatly or save package as, you simply save the package, and then create an agent job to...

a few ways then, take a look at the import export data wizard which will create you an SSIS package which you can schedule, also take a look at creating...

is the txt file going to be the same structure everytime it is imported or is it going to change?

if you have not already, please install books online from the SQL installation media, it will help you in the long run and will give you the same information we...

as an add on to this, yesterdays headline was about adding a monitor to an existing LS plan, so you could add one now without waiting for the failover

http://www.sqlservercentral.com/articles/Log+Shipping/77295/

in secpol, when you look at the log on as a service section, what is the icon showing at the begining? is it a page with 10010 or is...

backups and databases on the same drive?

got other processes which are running around the same time which could cause file growth and shrinking? Index rebuild for example or if tempdb...

we decided against scom as it didn't monitor everything we wanted from SQL

is there a reason it needs to be in scom? Could you nit create a custom stored...