well looking at the cast/convert MSDN page

http://msdn.microsoft.com/en-us/library/ms187928.aspx

it details that ntext to binary convertions are not allowed, you will need to convert to varchar or nvarchar

unsure on that, what I would ask you do is post the query in question, along with data DDL and the rdl file, and detail what the results should look...

take a look at the key word UNION and UNION ALL, it will allow you to specify an additional query which you can create a blank row with a dummy...

please can you post the DDL for the table and some sample data with the results you expect to see and what you do actually see so we can take...

no it wont as your not affecting the transaction log

how are you licensing the servers? CPU lics or Server&CAL lics?

if CPU then you only need to purchase the amount of Enterprise licences which match the number of CPUs,...

the only way to backup the secondary would be to restore it with recovery so that it comes online for you to back it up. this will terminate the...

i've done this in the past when consolidating hardware, there are no issues with it as the binary files are installed in different folders, the only limitation we had was...

truffle shuffle

now your just being cruel :crying:

think we need to change the word now, as all this talk about fish and tartar sauce is making me want fish and chips for my evening meal, which will...

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