Viewing 15 posts - 391 through 405 (of 1,082 total)
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 9, 2009 at 6:16 am
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) =...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 6, 2009 at 10:33 am
Awesome thanks
I thought there was a hash bad body in there somewhere.
Thanks again to all
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 5, 2009 at 9:12 am
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?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 5, 2009 at 8:31 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 5, 2009 at 3:15 am
OK found another solution.
I changed the properties of my variable to be an expression and then build the expression based on that
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 5, 2009 at 3:00 am
what type of connection should I be creating?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 5, 2009 at 2:56 am
thanks for the reply :-). I have installed VS2005 and BI is now working 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 4, 2009 at 8:00 am
Thanks Jacob,
Thats pretty much what I was thinking 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 4, 2009 at 3:59 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 4, 2009 at 3:13 am
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?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 4, 2009 at 2:18 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 3, 2009 at 10:24 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 3, 2009 at 9:03 am
"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....
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 3, 2009 at 8:15 am
Firstly why are you using SELECT *.
do you really need to retrieve every column in the table?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
February 3, 2009 at 7:54 am
Viewing 15 posts - 391 through 405 (of 1,082 total)