Viewing 15 posts - 256 through 270 (of 476 total)
Or another option
with cte as
(
select RIN, TYPE, Code, Lot, ShouldBe,
MIN(RIN) over...
October 9, 2013 at 6:57 pm
Hi
A couple of other options, NOT EXISTS and FULL OUTER JOIN
CREATE TABLE #FirstDataString
(
FDataString varchar(250)
)
CREATE TABLE #SecondDataString
(
SDataString varchar(250)
)
INSERT INTO #FirstDataString
(
FDataString
)
VALUES
(
'1,3,6,8,9,10,12,13,15,16,20,21,24,26,28,31,33,34,35,49,51,52,53,57,58,61,63,66,69,70,71,75,76,77,78,79,81,82,85,88,90,91,92,93,94,95,96,97,98,99,100,105,107,110,111,112,118,122,124,125'
)
INSERT INTO #SecondDataString
(
SDataString
)
VALUES
(
'1,3,5,8,9,10,13,15,16,20,24,26,28,31,33,35,49,51,52,57,58,61,63,69,70,75,76,77,78,79,81,85,88,90,91,92,94,95,96,97,98,100,105,110,111,118,122,125'
)
SELECT Item AS FirstItem
FROM #FirstDataString f
CROSS APPLY dbo.DelimitedSplit8k(F.FDataString,',') splitf
WHERE...
October 9, 2013 at 2:59 pm
Hi
I can't test this in an email yet (so it may not work) and the rendering of the graph would be dependent on the email client looking at the message.
The...
October 8, 2013 at 6:17 pm
Have fun ... and sorry:-D
October 7, 2013 at 7:31 pm
LutzM (10/7/2013)
I really do like mickyT's approach!!!It's definitely not "out-of-the-box".
The question is: How can the "graph format" be used together with sp_send_dbmail. Any thoughts?
Ah, one of the tricky ones:-). ...
October 7, 2013 at 4:31 pm
peterzeke (10/7/2013)
ztoddw (10/4/2013)
...So is there some way to just create a simple bar graph...?
If you really want "simple", try the following sample query which produces a horizontal bar graph using...
October 7, 2013 at 2:17 pm
I know this is a few days late, but I wanted to have a try at this. Here is what I came up with. Does it do what...
October 6, 2013 at 1:07 pm
Sorry, I should have put a link up for the tally table references
October 3, 2013 at 11:51 am
Hi
I think this is what you are asking for. I've made use of a Tally(Numbers) table to fill out a strength for each day, then summed strength for each...
October 2, 2013 at 7:40 pm
Shaun2012 (10/2/2013)
Is there a carriage return on the last line? don't know what thise mean??Shaun..
Is the last line terminated with a carriage return / newline? eg.
This,is,my,last,line<EOF>
or
This,is,my,last,line
<EOF>
Note the <EOF> is...
October 2, 2013 at 2:32 pm
Is the missing row the first, a middle or the last line?
Is it trying to read one line as a header?
Is there a carriage return on the last line?
October 2, 2013 at 2:00 pm
mario17 (10/1/2013)
AND t.c2 = (select top 1 tt.c2 from t tt where t.pk = tt.pk)
Hi
The clause above is a bit...
October 1, 2013 at 12:48 pm
To avoid messing around with varchars altogether you could do
SET @LongitudeLatitude = Geography::Point(@Latitude,@Longitude,4326)
September 25, 2013 at 9:26 pm
Another option (and another shudder :-)) if you don't mind waiting and have a sandbox type database it to:
Creating a staging table for the data.
Selecting the 'Edit top 200 rows'...
September 25, 2013 at 9:10 pm
Viewing 15 posts - 256 through 270 (of 476 total)