Viewing 15 posts - 21,346 through 21,360 (of 26,490 total)
Made a simple change to the data and broke my own code. This requires additional information regarding he requirements. If the data is inserted as specified by the...
April 27, 2009 at 1:45 pm
Scott Roberts (4/27/2009)
Lynn Pettis (4/27/2009)
Possibly, but based on the trivial data, table structure, and expected results provided, it works.
Actually, it doesn't.
Check your results against the "expected results" in post...
April 27, 2009 at 1:33 pm
Actually, its broke, something was missing. Ignore the current code, i need to rework it a bit.
April 27, 2009 at 1:13 pm
Bob Hovious (4/27/2009)
Lynn, doesn't this assume that all the duplicates are going to fall together in sequence?
Possibly, but based on the trivial data, table structure, and expected results provided, it...
April 27, 2009 at 1:09 pm
How about this?
EDIT: Code posted here was removed as it failed!
I noticed that your table def had RawData defined as varchar(5000) but your cursor function had it defined as varchar(300)....
April 27, 2009 at 12:59 pm
I may be wrong, nothing available to do any testing, but isn't this the equivalent of the code you originally posted above?
SELECT
M.MainTableID,
M.PageName,
...
April 27, 2009 at 12:14 pm
Here is another method:
create table #Orders (
OrderNum int,
LineNum int,
Product varchar(10),
Result varchar(25)
)
;
insert into #Orders
select 1,1,'ABC',null...
April 27, 2009 at 11:50 am
aaronxramirez (4/27/2009)
April 27, 2009 at 11:35 am
Samuel Vella (4/27/2009)
Steve Jones - Editor (4/27/2009)
April 27, 2009 at 10:30 am
Here is an example of how to use the STUFF...FOR XML using the example from AdventureWorks:
Set NoCount On;
Declare @cpu_ int;
Declare @lreads_ int;
Declare @eMsec_ int;
Select
@cpu_ = cpu_time,
...
April 27, 2009 at 10:28 am
ALZDBA (4/27/2009)
First findings .... It no longer works .... SQL2008 ( sp1...
April 27, 2009 at 7:48 am
Very good article. In fact, I'm thinking of printing each of the articles in the series and providing them to my team as required reading.
The test harness you have...
April 26, 2009 at 10:10 pm
RBarryYoung (4/26/2009)
For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from...
April 26, 2009 at 3:22 pm
Bob Hovious (4/25/2009)
1. Create temporary table "A"
2. Populate it with base ids
3. Query table "B" and update one...
April 25, 2009 at 11:47 pm
Florian Reischl (4/25/2009)
New information from splitter front... 🙂
As first I have to apologize for all those "great" CLR test results... Since I tried to reduce the test results to the...
April 25, 2009 at 6:51 am
Viewing 15 posts - 21,346 through 21,360 (of 26,490 total)