The argument that has worked at my company is that spreadsheet use means we store the same information in many places, which means we do not use standard names and...

We switched from Crystal to SSRS mainly because of cost. We just had the freebie five license web server for Crystal which meant when 5 people were viewing reports, nobody...

Have you checked that the value of @BSTVal is being set correctly in both cases?

I assume prcBSTOn is a proc, the code for which is not listed.

duda (3/26/2009)

---

Hi Anyone,

I have a problem in proclarity front end application. It does not calculate the subtotals correctly in some of the columns. See example below:

...

I have no idea why it works one way and not the other, but why not solve the truncation?

Maybe irrelevant, but SSIS defaults char fields to a length of 50....

This doesn't help, but this is the reason I believe that excel is the devil.

Excel 2007 does a much better job of handling text values that resemble numbers, but I...

One of my cleanup tasks was not working because I had the file suffix as .bak including the dot.

If I posed this question "should I sweep my driveway with a toothbrush or a hairbrush?' would it be more helpful to tell me to use a broom or the...

Will this work?

CASE WHEN TotalTests >2 THEN '3PLUS' ELSE '2MINUS' END AS Tests2

Or do you need two additional columns:

CASE WHEN TotalTests <= 2 THEN 1 ELSE 0 END AS...

Are they both running on the same box? If not then you may have to set up kerberos. It sounds simple, but never works on our network.

What machine are you running the package from? I think you have to be on the server to use bulk insert in SSIS. That's how I got it to work,...

I found this article useful:

http://www.sqlservercentral.com/articles/Miscellaneous/oracleandsqlserverdatainteroperabilityissuespart1/1332/

I had some columns with incompatible data types, so I ended up using SSIS to query oracle and convert some columns, then import into SQL Server.

This...

Whats the function to convert roman numerals to int? 😉

Are you doing this in Reporting Services?

If so, you need to compile the proc in sql, then select that procedure as the source of your dataset, then map your report...

Something like this might work.

CREATE PROC donkey (@MonthNum int, @Year int)

AS

DECLARE @query_head nvarchar(1000), @query_foot nvarchar(100), @sql_string nvarchar(1500)

SET @query_head = 'SELECT * FROM [dbo].[ProductRank~QD~1~'

SET @query_foot = RTRIM(CONVERT(char(2),@MonthNum)) + '~' +...