Viewing 15 posts - 1 through 15 (of 98 total)
Very cool idea. Just wondering if you've 'reinvented the wheel' a bit. If you use OPENXML and omit the WITH clause, it produces an edge table with very...
June 30, 2010 at 2:50 pm
To solve this same problem in the past, I've created a CLR function or stored procedure to do a regular expression replace. You could also use the ...OA stored procedures...
November 16, 2009 at 8:14 am
Has anyone found a way to deal with daylight savings time changes?
In the fall, there would be the possilbility of having duplicate times for events that happened an...
December 22, 2003 at 7:02 am
I liked the article...I am amazed that people still use pre ansi-92 syntax...it has been over 10 yrs already.
In addition to using ansi join syntax, I like to move the...
December 17, 2003 at 7:48 am
Just curious, has anyone in your organization addressed moving database development from the production environment to a development one...?
December 17, 2003 at 7:42 am
I have built several FTI solutions but never using anything other than pure text. I would be interested in how FTI works with different formats of binary data from...
December 11, 2003 at 4:16 pm
Just curious why you went the SQL route instead of using Crystals functions and grouping capabilities as a means to display the data in the desired format?
Seems as though if...
October 30, 2003 at 6:37 am
The example you have given is not very clear...can you rephrase?
September 19, 2003 at 1:18 pm
Troy,
I'm not sure we're are going to be able to come to an agreement on what is wrong with the table and stored procedure (I don't see an issue)... ...
September 9, 2003 at 6:14 am
I think I understand where you are going...
The only way anything can be written to the production TimeTable is via the stored procedure UpdateTimeTable. No applications or users have...
September 8, 2003 at 1:05 pm
Hi Troy,
Not sure I follow you in regards to incorrect data within the date variables. Could you elaborate?
September 5, 2003 at 1:06 pm
Glad to hear others have encountered similar problems and attacked them with similar solutions...was never sure if I was off base or not with my approach. Its always nice...
September 5, 2003 at 6:11 am
Take a look at using DataSets. (If you're using ASP.NET). They have a get children method, that may help you recurse through the tables.
September 2, 2003 at 6:23 am
The first time this article posted, I got quite a response. Due to those responses, I wrote a follow up article addressing several other methods for solving the same...
August 29, 2003 at 7:58 am
Viewing 15 posts - 1 through 15 (of 98 total)