So there's nothing we can do to help as you can't control the query?

Using a script task inside a loop you could check if the file exists and end the loop when the file is found to continue with the package execution.

I...

That's a really weird requirement. I can't see why would you want to do this but here's an option.

WITH ConcValues AS(

SELECT ROW_NUMBER() OVER( ORDER BY Name)...

At first sight, I though you needed just MAX and MIN, but looking at the expected results I found out that it was a little more complicated.

Here's an option:

WITH CTE...

You might need to post more information to get good advice. Check the following article to know how to do it.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Another use is to work with parameters that work as arrays contained in strings.

I know that this can be done using table-valued parameters but some might like the splitter option...

I added that thread to my briefcase because I'm sure it might get handy some time. I use a digital camera for my photographic memory but from time to time...

Something like this?

CREATE FUNCTION [dbo].[ProperCaseWithNumbers]

(

@StrIn VARCHAR(255)

)

RETURNS TABLE WITH SCHEMABINDING

AS

RETURN

SELECT STUFF(

----Start of first parameter

(SELECT CASE

WHEN split.Item LIKE '%[0-9]%'

THEN ' ' + split.Item

ELSE ' ' + Upper(LEFT(split.Item, 1)) + Lower(Substring(split.Item, 2, 255))

END...

It might have been a problem with the site. It seems to be intermitence due to maintenance.

In other words.

This:

WHERE (dbo.TCDaily.Kind <> 'A02') AND (dbo.TCDaily.Kind <> 'J02') AND (dbo.TCDaily.Kind <> 'J04') AND (dbo.TCDaily.Kind <> 'J06')

Is exactly the same as this:

WHERE NOT( (dbo.TCDaily.Kind = 'A02') OR (dbo.TCDaily.Kind...

KoldCoffee (5/29/2014)

---

I know that STUFF takes 3 parameters: (the string, the starting position, the number of characters to delete) but I can't break Luis's TVF into those three. Can...

Sean Lange (5/29/2014)

---

Here is an example of a real world case for using a splitter. This iTVF will return a string with the proper case. I did not write this...

You're welcome.

I hope that you could understand it and learn something new. 😉

I'm not in favor of "sprocs" but I prefer them over "store procedures". AFAIK, we're not selling anything.

At work we have DTS that simply call an SP or even better,...

You shouldn't compare cost percentages on query plans against 2 different queries. They are just estimates and can lead to wrong assumptions.

Run your queries against a large number of rows,...