Viewing 15 posts - 56,416 through 56,430 (of 59,069 total)
Nicely done, Brian. And, Jan, I agree... we've asked you to post the cursor code a couple of times now...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 11:21 pm
There is a "good" reason
... they're probably not allowed to put their own stored procedures in and it must pass a DBA review......
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 11:02 pm
Here's an example... you can't do unlimited hierarchies, but it's normally good enough. And, it's not your specific example... it for something I did for someone else... thought it might...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 10:54 pm
Unlike DTS, Query Analyzer, and BCP, OSQL was NOT designed to scan the data and size the output accordingly. Since you don't want headers, BCP is the best bet. DO...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 10:44 pm
Tell me... is AppointmentDate a VARCHAR column?
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 10:17 pm
Unless you need absolutely awesome performance on a huge table, this'll do nicely with pretty good performance...
SELECT i.IntName,r.RegName,r.RegInterests
FROM Registrations r,
Interests i
WHERE ','+r.RegInterests+',' LIKE '%,'+CAST(i.fk_Interests AS...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 10:15 pm
That's just not the way we do things here... lot's of folks busted a hump trying to help and now you're not going to take the time to explain what...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 10:00 pm
No need for even a single CAST or CASE...
SELECT (
SELECT COUNT(*) * 100.0
FROM @ProviderLink
WHERE PLtat + PLunworkable > 75
)
/ (COUNT(*)) AS Percentage
...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 9:56 pm
Thanks folks... great feedback and I appreciate it very much.
Ben, I've not found much on Triangular joins but I did write an explanation for someone else on this forum. Please...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 9:20 pm
You can go a bit further... the following will return the number of spaces found for each row for that column...
SELECT pkcolumnname, LEN(yourcolumn) - LEN(REPLACE(yourcolumn,' ','')) AS Spaces
...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 9:15 pm
How is it that a casual user has been allowed access to backups? That, in itself, would be a violation on PCI audits...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 9:09 pm
The problem may be with any SQL DMO or sp_OA* code you may have... if you forget to close and drop connections, you may end up with a "connection leak".
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 9:00 pm
A 200 mb TempDB is nothing... I wouldn't recommend leaving it that small... as others have stated, figure out how big it needs to be and the set the intial...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 8:57 pm
Here there everybody... thank you folks for the good info... most of you are of the same ilk about the necessity of a primay key... I think that's why they...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 8:51 pm
Heh... figures... Rudy! They cut off my access to the DB in question so I can't see the table and it's dependents anymore... guess they got tired of my prying...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 16, 2007 at 8:49 pm
Viewing 15 posts - 56,416 through 56,430 (of 59,069 total)