Recent content by iaresean

Hi r937; Well just about any 2 tables with a 1-to-many relationship will do. Say for arguments sake I have a table of People, and another table of Jobs. I want to select all the people from the people table along with the first job that they did. Thanks again; Sean. [peace]

Hi All; Been a while since I have visited Tek-Tips, but I small SQL problem that has been bothering me. I need to select a set from a table and include the first row of a related set of data from another table. Does anyone know of an elegant statement that SQL Server 2005 may provide to solve...

Hi All; I have a small wireless network at home and I am trying to set a download cap on one of the machines in my network that is getting some download abuse. I have full access to the router and machines. Is there any tools out there (preferably free!) that could help me achieve this...

Hi SQLSister, Wow, I can see that you have had some bad experiences with this before. You can rest assured that this is not going to be for any high usage front end components. It is merely to power a simple backend list, that I believe will have at most 2 people ever using it - there is...

Hi Chance; Yes I did come across this, but this isn't exactly what I am looking for. My requirements are fairly different. Sean. [peace]

:-( Should I go for a temp table rather? Sean. [peace]

Sorry, forgot to change the last command 'PRINT' to 'EXEC'. Please do so to get the stored proc to work. Regards; Sean. [peace]

Cool, thanks ca8msm. I used some of your logic (fetching the columns), and managed to create my own procedure. Managed to learn some things in the process. Thanks for the guidance all the same. :-) CREATE PROCEDURE sp_SearchTable ( @TableName nvarchar(100), @SearchStr nvarchar(100)...

Hi All; Does anyone know of (or know how to make) a generic search stored procedure. I really need a procedure that will allow me to pass it a table name along with a search string. Using the search string the stored procedure will search through any string type columns (varchar, nvarchar...

Hey, I did post a link to the project. But, LOL, it looks like codeplex currently has an ASP.NET error they need to resolve. :-D Hectic. You can download it here in the mean time: http://www.microsoft.com/downloads/details.aspx?FamilyID=62ef5f79-daf2-43af-9897-d926f03b9e60&DisplayLang=en It...

This message is targeted at ca8msm, the person who introduced me to the Microsoft Patterns and Practices Enterprise Library. What a wonderful addition to my programming arsenal it has been! My coding has grown so much and I can now easily incorporate standards based enterprise ready solutions...

Awesome. :-D Sean. [peace]

ca8msm - Wow, seems like whereever I go a tip from you is sure to follow. :-D Thanks for the advice, I will certainly do some reading up about this DLL. ---------- AlexCuse - I look forward to hearing from gmmastros, if he is in the mood of sharing his wisdom. :-) Unfortunately this...

Thanks alot! I will certainly put your logic to the test. Yeah the string manipulation would be alot easier if SQL Server 2000 had built in Regular Expression support. :-) Thanks again; Sean. [peace]

Ok, I think I might be able to rustle up something. For interests sake, how would I do it using a varchar data type? :-D Sean. [peace]