Forum Replies Created
Viewing 15 posts - 616 through 630 (of 683 total)
-
RE: XML Child - Parent Relationship
Hi Amit,
I'm a bit confused.
If 1 doesn't have a parent, why does it have a parent in the XML you've written? Did you...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: "progressive update" query - urgent help needed.
Well, okay, I've done it now (I couldn't resist!
). You can pay me next time 
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: "progressive update" query - urgent help needed.
Scott,
Your problem is very difficult to get to grips with - not because it's that tricky, but because of the way you've expressed it.
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Where clauses that have ''''['''' character in value.
I'm guessing you're using the LIKE clause and need to use ESCAPE...
DECLARE @t TABLE (v VARCHAR(100))
INSERT INTO @t
SELECT 'abc'
UNION SELECT 'a[c'
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: how to find duplcates in a cosecutive period of time
Good point Kevin - I missed that was a requirement.
Thanks
I guess I can just add it...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Can You Search a Single Field on Multiple Patterns?
Read up on 'Full-Text Search' in books online
Once it's set up, you can do things like...
WHERE CONTAINS(LastName, '...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: how to find duplcates in a cosecutive period of time
Well, anyway, here's an alternative to Kevin's solution...
It seems to run marginally faster, but nothing too significant, on my tests, so I guess you'll...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: how to find duplcates in a cosecutive period of time
Hi all,
I love problems like this - please keep them coming!
bug, can I just clarify something? You said consecutive days, but then...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: FRIENS, Is possible to get the local IP since a store procedure??
Good work noeld! Where were you for the other thread?
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Get Curent Users PC Name / IP Address
noeld has come up with a solution in this similar thread...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=264524
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: FRIENS, Is possible to get the local IP since a store procedure??
Did you read the whole thread?
The upshot was that it's not possible...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: FRIENS, Is possible to get the local IP since a store procedure??
I remember this one from before
See this thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=250528
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Import a variable text file
Thanks for the update, and thanks for using the work "shlog". Made me smile
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: Complex function
Hi James,
Is something like this what you're looking for?
--This SQL script is safe to run
DECLARE @Itinerary TABLE (BookingNo INT, TicketID INT, FromId...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
-
RE: SSIS Package
Hi Ryan,
Firstly, good name
Secondly, isn't this in the wrong forum? Unless I'm mistaken SSIS is new for SQL Server 2005, and this forum...
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.
Viewing 15 posts - 616 through 630 (of 683 total)