Viewing 15 posts - 57,931 through 57,945 (of 59,070 total)
If it's not slow on all the servers, then you may be having some router or hub problems. For example, if the port and card the server is on are...
July 31, 2006 at 4:55 pm
Juan,
I'm a bit confused.... you say the users are going to do deletes, sorts, filters, and analysis but you have concerns about their capabilities with the software (Access)? I'm thinking...
July 31, 2006 at 4:50 pm
Thanks David... and I agree, but it's nothing quite so serious... our standards currently have some fairly strict naming conventions that do not include Hungarian Notation (except for the letter "p"...
July 31, 2006 at 4:41 pm
If you need a text column for Results, tell me why this won't work...
select RGnameLast+', '+RGnameFirst AS Adjuster, RGnameLast, COcity AS ClientOffice, IOofficeName, WRworkOfficeId,
WRid, SRnameLast+', '+SRnameFirst AS Subject,
CONVERT(CHAR(8),...
July 31, 2006 at 4:34 pm
Seqiy,
Do you have a Microsoft URL for "And prefixing tables with "tbl" as well as all other objects in SQL decreases database performance. Just in case you did not hear...
July 31, 2006 at 12:23 pm
Shyam,
Although Serqiy has gotten blunt as all get-out, he's absolutely correct. Why on earth would you want to modify the content of the IDENTITY column? If you run out of...
July 31, 2006 at 12:18 pm
Unless you haven't posted all of the code, you, in fact, as the SQL Junkie suggested, do not need a cursor for this. Did you try the SQL Junkie's code? ...
July 31, 2006 at 12:07 pm
A little off-the-wall but I've run into similar problems with other things... the way I got around it was to run this type of thing on each server with an...
July 31, 2006 at 11:58 am
Actually, if your users are experienced in MS-Access, what's wrong with them using it? The only other thing you could do is either write you own Web app to do...
July 31, 2006 at 11:49 am
Thank you for the feedback. If you add tabs instead of commas, it'll open up in Excel without much of a conversion at all. Didn't realize that the target of...
July 31, 2006 at 11:40 am
So, what your telling me is that @facturas_id2 is a VARCHAR like it needs to be? Make sure because I didn't see it defined in any of the code you...
July 28, 2006 at 5:53 pm
You'll take one look at this and think I'm as crazy as a cyclist on steroids... but try it... no real loop, nasty fast, and does not require a function...
July 28, 2006 at 5:42 pm
My 2 cents...
SELECT DATEADD(mi,30*Number,0) AS BW1
INTO #v_hcdata_Total
FROM MASTER.dbo.spt_Values
WHERE NAME IS NULL
AND Number < 48
July 28, 2006 at 4:38 pm
Certification will require some tenacity on your part...
Anyway, take a look at this url...
http://www.microsoft.com/learning/mcp/sixsteps.asp
July 28, 2006 at 6:48 am
How true, how true... I'm still waiting for Ravi to post some code and maybe give us a hint as to the rowcounts in the tables.
Ravi, while were waiting,...
July 28, 2006 at 6:36 am
Viewing 15 posts - 57,931 through 57,945 (of 59,070 total)