Viewing 15 posts - 5,461 through 5,475 (of 5,588 total)
Another thing to think about...
In the other thread, you had mentioned that you'll do a bunch of data retrieval operations through a view.
If the view is coded with a select...
April 22, 2009 at 2:41 pm
doran_doran (4/22/2009)
April 22, 2009 at 1:45 pm
Well, I got it working, by doing it the "wrong" way. I went to computer management, services, and set the logon acct that way.
April 22, 2009 at 1:10 pm
How about some table definitions and test data? See the link in my signature.
April 22, 2009 at 7:53 am
-- build some test data... you should have provided this in this format for us
declare @temp table (
ID int,
[Group] int,
Node varchar(3),
Parent varchar(3))
insert...
April 22, 2009 at 7:43 am
select LEFT(Student_ID, CharIndex('*', Student_id)-1) [Real_Student_ID],
SUBSTRING(Student_ID, CharIndex('*', Student_ID)+1, len(Student_ID)) [Real_Department_ID]
from tbl_student
April 22, 2009 at 7:08 am
RBarryYoung (4/15/2009)
Easy, and I don't bother with anything less than a million rows:
Select TOP 1000000
ROW_NUMBER() over(order by c1.object_id) as N
into Numbers
From master.sys.columns c1, master.sys.columns c2
Ummm Barry.......
April 21, 2009 at 11:22 pm
Time to quit lurking on this thread... 😀
I'm wrapping up an aricle on @tables & #tables. If you'd like to review it, please PM me w/ an email address...
April 21, 2009 at 10:39 pm
John,
Your performance problem is that you are performing your data load in a row by row method. Your process needs to be converted to be a set-based process.
There are several...
April 21, 2009 at 11:26 am
Bruce W Cassidy (4/16/2009)
WayneS (4/16/2009)
Thomas (4/15/2009)
Using a cross join is not itself counter-intuitive. Using it in this fashion to generate a bunch of numbers probably is to most developers.
I think...
April 18, 2009 at 5:47 pm
Chris Morris (4/17/2009)
What do you want as your output, Wayne?
I'm trying to get rows from table1 that are different from table2. I was able to get it through above suggestions......
April 17, 2009 at 10:58 am
jbreffni (4/17/2009)
use except to find the records you needwrap that up as a sub query
use the sub query as a filter for the records you want all columns from
Thanks... my...
April 17, 2009 at 10:56 am
SQLRocker (4/17/2009)
if 2005, Have you tried TableDiff.exe?
TableDiff compares all columns, and if any are different it shows the differences.
So, every row with different data (the identity column, the modified_dt column,...
April 17, 2009 at 9:36 am
Thanks, that is pretty slick (and pretty fast also).
My actual tables have additional columns (modified date, guid, others... I should have included some of them in the test) ... to...
April 17, 2009 at 9:11 am
Thomas (4/15/2009)
Using a cross join is not itself counter-intuitive. Using it in this fashion to generate a bunch of numbers probably is to most developers.
I think that this is one...
April 16, 2009 at 10:04 am
Viewing 15 posts - 5,461 through 5,475 (of 5,588 total)