I'm assuming your problem was that 1900-00-00 is not a date?

Please let us know what the solution was in case someone else has the same problem in the future 🙂

Thanks

CREATE FUNCTION dbo.udfStringtoTable

(

@String NVARCHAR(100) ,

@Delimiter CHAR(1)

)

RETURNS @Results TABLE

(String VARCHAR(100))

AS

BEGIN

INSERT INTO @Results

SELECT SUBSTRING(@String+@Delimiter, n,

CHARINDEX(@Delimiter, @String+@Delimiter, n) - n)

FROM tally

WHERE n <= LEN(@String)

AND SUBSTRING(@Delimiter + @String,

n, 1) =...

Awesome thanks

I thought there was a hash bad body in there somewhere.

Thanks again to all

So it's more that the UNION is not that good rather than UNION ALL is not that good.

So UNION ALL is ok basically if needed?

actually didn't use a connection all.

I just used the paths as variables.

However I have come across another problem in that if the files doesn't exist my I get errors my...

OK found another solution.

I changed the properties of my variable to be an expression and then build the expression based on that

what type of connection should I be creating?

thanks for the reply :-). I have installed VS2005 and BI is now working 🙂

Thanks Jacob,

Thats pretty much what I was thinking 🙂

The only other thing I can think of is that YEAR is an int and it might be faster to compare and int than it is to compare datetime

HI Grant,

How do I check this: "You still need to look at I/O, CPU, execution time, wait states... " for the different operations in the query plan?

Also waiting for the Index definitions, but from the plan I noticed a few Key Lookups on the same table for the same fields, I'm sure some useful indexes could...

wow I got so confused on a thread earlier today when someone was posting a thanks to Gail, and I was thinking to myself, well I don't see your pic...

"Convenient " is the devils work....

the general "rule" is that you should only select the columns you need.

Using a view is prob a good idea on such a large table....

Firstly why are you using SELECT *.

do you really need to retrieve every column in the table?