Did you ever figure this out? I might have recently done something similar, but its been over a month since this post.

I may have misread the subquery join.

Can you find if it is ever possible for the subquery to return multiple rows? even though it doesn't for the example?

Does this return anything?

SELECT T3.Val1

FROMTable3 AS T3

INNERJOIN Table4 AS T4 ON T4.SomeID=T3.SomeID

WHERET3.Val2 = 1

GROUPBY T3.Val1

HAVING COUNT(*) > 1

and does it work if you change your subquery...

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...