True, of course.

You are very much more accommodating than I would ever be, an...

I suspect (just a wild guess) that the query contains DISTINCT in the select list and, since the OP is selecting the converted date, can only ORDER BY the converted...

cyndi_kemp (10/12/2011)

---

That was it, changing the join to a left outer join did the trick. Thanks so much for your help. Sorry about the table names, come from...

SET @someval = ISNULL((SELECT Name FROM SOMETABLE WHERE ID=3),'')

OR

SELECT @someval = ISNULL(Name,'') FROM SOMETABLE WHERE ID=3

This assumes that the subquery returns no more than one row, which might not be...

This question is not detailed enough.

Please provide sample data, showing source data and desired output, as described in the link in my signature.

Files in the same folder cannot have the same name.

Best practice is to move your files to an archive folder after processing them - so the only files in the...

Why not just use a Foreach loop to process all files in the folder, regardless of name?

Or maybe *.txt - whatever works.

Do the files need to be processed in order?

You can say that again.

Or can you?

😀

If this code is driving an Execute SQL task and a number is required for a subsequent precedence constraint, the query should return a number!

IF ( SELECT COUNT(t.name) AS CheckQuery FROM (

SELECT f.name FROM fleets f

WHERE f.name NOT IN ( SELECT C.CompanyName FROM Company C

LEFT JOIN Accounts A ON A.CompanyName =...

steveb. (10/6/2011)

---

This is...

Please describe how to use that within an SSIS package.

I suggest that you read this to help your understanding of scope.

I can't give a specific answer, because that would require me to look into the design of your report.

But,...

Oooooooh, cool!! Maybe in five years we might have actually migrated to Denali 🙂

The error message seems self-explanatory: what is your question?