Viewing 13 posts - 1 through 13 (of 13 total)
Give it a try...
I don't see the rolling over as a big problem. Every time you read in a row, check to see if it starts with "author=", "year=", "title=",...
June 26, 2009 at 4:20 pm
Thum,
I guess at this point I'm a bit confused about exactly what it is you are trying to do. I thought someone was sending you the XML you provided in...
June 26, 2009 at 12:58 pm
The only issue with this method is that in some cases a line e.g. author maybe longer than a line and roll over to the next line. In this case...
June 26, 2009 at 11:39 am
There are probably a lot more elegant (and faster) ways to do this but one simple and straight forward way would be to pull the whole thing into a temporary...
June 26, 2009 at 11:03 am
What about using a loop? Not that this is the best way but it's getting late and it was the first thing that popped into my head...
I haven't done any...
June 25, 2009 at 7:05 pm
I'm a little confused by your post because in the first sentence you mention "sorting...outside of the order by clause" but then your select statement clearly has the order by...
June 25, 2009 at 6:08 pm
Grasshopper,
Will something like this work? I know it runs the command SQL twice but maybe it's worth it.
DECLARE @ProblemFound INT
SELECT @ProblemFound =
CASE DATEDIFF(day, MAX(dbname.dbo.FRQuoteRevision.StartedOn), GETDATE())
...
June 25, 2009 at 5:55 pm
Terry,
I took Lee's code and tweaked it just a bit to account for the fact that you can have multiple projects.
CREATE TABLE Project (
Project varchar (10)
...
June 25, 2009 at 4:58 pm
Do you have any special requirements? Such as...
- Are you trying to save the 90 percent of the rows you need to get rid of?
- Do...
June 25, 2009 at 4:09 pm
Based on the pseudocode, I think it makes sense...
When you ran the code, the transaction started.
When the error was caught, it jumped over the commit and went straight to the...
June 25, 2009 at 4:05 pm
Thum,
I'm not exactly sure which "one" of the "Reads" you want to set to False, but you can do something along the lines of:
SET @FeatureList.modify('replace value of (/FeatureList/Feature[@id="9CF9805F-367A-41A2-81F2-78562AA4D310"]/Read)[1]
...
June 25, 2009 at 3:09 pm
There are probably quite a few ways you can accomplish this.
1. One way I've tried in the past is to create another column at the end of each table and...
June 23, 2009 at 5:54 pm
I had the same problem and it apparently couldn't cycle the error log was for the same reason that the logs were getting so large. Once I corrected the problem...
June 9, 2008 at 5:53 pm
Viewing 13 posts - 1 through 13 (of 13 total)