Viewing 15 posts - 3,901 through 3,915 (of 6,401 total)
Well you will need to change the PLSQL into T-SQL, but is there a reason you cant just use the UPPER function?
SELECT UPPER('hello')
August 23, 2012 at 3:46 am
Just need to specify the DSN in the Data Source and UID and PWD go in the security screen
August 23, 2012 at 2:44 am
Install the Sybase ODBC drivers to your SQL server, create a DSN on the SQL server to Sybase, then use the standard ODBC driver type in the linked server configuration.
August 23, 2012 at 2:03 am
More coffee needed, I didn't read the question right, thought it was inserting many columns not 1 column, so the limit would of been 4096 so selected S,E,E doh to...
August 23, 2012 at 2:01 am
Create a DDL trigger for the CREATE DATABASE event and get it to log to a table, that way you dont need to have a trace running, it is captured...
August 22, 2012 at 1:40 am
Only way I know would be to add event handlers which logged pre and post execute times to a table which you can then compare.
August 22, 2012 at 1:31 am
And the subscription schedules dont have the "stop this schedule on" value set?
As for shared schedules, the same applies, the whole schedule stops not just individual subscriptions against that schedule,...
August 21, 2012 at 8:49 am
Total stab in the dark, but are the subscriptions using shared schedules?
Could it be that the subscription have expired, but due to the schedule being shared, the schedule doesnt get...
August 21, 2012 at 8:37 am
The only gap you would get is if you leave any points between the tablix's, there wont be a massive gap between tables as the HTML is smart enough to...
August 21, 2012 at 7:43 am
Would be quite easy in reality.
You would create your report as if you where showing all 4 data sets on screen at the same time, that way a the correct...
August 21, 2012 at 6:32 am
Boom - it works, sweet as a nut
Also helps if you read the article in detail aswell as I missed a critical part on one step.
Only thing it doesnt translate...
August 21, 2012 at 5:13 am
Gazareth (8/21/2012)
Table containing location ID's (en-GB, es, es-MX etc) as PK, columns Header1, Header2.. HeaderN.., Label1 etc (obviously with better names - more on design in a...
August 21, 2012 at 4:49 am
http://www.keepitsimpleandfast.com/2011/09/localization-of-your-ssrs-reports.html
Going to try this out
August 21, 2012 at 4:49 am
For the moment, it will be a small set of languages. The reports are for our new SaaS product and could be sold in every country in the world,...
August 21, 2012 at 4:17 am
One way so far I have looked at is using SWITCH for the labels etc based on User!Language, but seems like a pain to maintain having to modify the reports...
August 21, 2012 at 4:11 am
Viewing 15 posts - 3,901 through 3,915 (of 6,401 total)