Viewing 15 posts - 916 through 930 (of 1,082 total)
ooops,
The join should be on Organization and not on Organization_name
....
thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 27, 2008 at 9:43 am
HI there,
Have you tried using a join instead:
update [2009]
set [2009].organization_name = e.organization_name
FROM test_2009 [2009]
INNER JOIN org_2008 [2008]
ON [2008].organization_name = [2009].organization_name
WHERE...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 27, 2008 at 9:42 am
Hi,
Please could you give us an example of the proc?
thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 27, 2008 at 7:30 am
HI,
Make sure you are connected to the correct database and that the table name is correct.
That is basically saying that it can't find your OrderDetails table!
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 23, 2008 at 7:22 am
Hi,
Do you need to update an existing field starting 5000 and counting up.
Or do youwant a new field to default 5000 and then the new row 5001?
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 23, 2008 at 6:28 am
hi ,
Thanks guys,
I was under the impression that in 2000 the views schema would over ride the table for not null in the view and null in the table...
thanks again
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2008 at 7:26 am
Sorry that wasn't real code
CREATE VIEW MyView
as
SELECT
ISNULL(Col1,'') as Col1
FROM MyTable
GO
Now if you run sp_help MyView
you will see the column is not nullable.
How come then it doesn't raise an...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 22, 2008 at 6:24 am
Hi Grant,
Thanks for the reply.
I'll keep that in mind and I'll keep testing my results for each situation that comes up in the future
Thanks again
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 21, 2008 at 9:35 am
Hi,
With regards to Left joins I would expect the data to be different.
Thanks
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 21, 2008 at 6:29 am
Ok further research has showing
1)
JOIN:
SQL Server Execution Times:
CPU time = 93 ms, elapsed time = 1306 ms.
WHERE:
SQL Server Execution Times:
...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 21, 2008 at 6:03 am
I don't think it's a glitch either.
Like most people are saying the VARCHAR(10) can only hold 10 so SQL is correct in truncating it!!!:D
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 20, 2008 at 8:35 am
HI,
Are you sure you are set to compatibility 90 and not 80?
thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 19, 2008 at 8:14 am
HI there,
Here is what I think is a set-based working copy.
(if it isn't please could someone tell me why it isn't set-based)
That aside this will work in 2000 without a...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 16, 2008 at 10:32 am
HI There,
Sorry about that.
Well you could use a temp table or table variable it's just another way of looping.
Why don't you want to use a cursor?
I don't like cursors which...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 16, 2008 at 10:07 am
he he he he
Sorry I should have read the forum heading 🙁
Have you tried using a table variable or derived table?
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
May 16, 2008 at 9:01 am
Viewing 15 posts - 916 through 930 (of 1,082 total)