Viewing 15 posts - 106 through 120 (of 180 total)
I've updated the code to show what i mean with multiple outers. Sorry for the confusion.
CREATE TABLE #TestMapping
(
ID INT IDENTITY(1,1),
ValueID INT,
IsEnabled BIT,
CreatedDateTime DATETIME
)
INSERT INTO #TestMapping (ValueID, IsEnabled, CreatedDateTime)
VALUES
(10,...
April 4, 2016 at 5:52 pm
Phil,
I've had a quick read, I'm a little confused... The values of 4,8,30,N... will be passed via the #temp table i created.
Since I'm using an outer apply in this case...
April 4, 2016 at 5:48 pm
Thanks for the quick reply. I thought it was the case but thought I'll see if anything else could be done.
I'll have a look at that link and revert back...
April 4, 2016 at 5:31 pm
XML tags are case sensitive so you just need to simply change it to correct formatting when requesting data (i.e. ContentRecords becomes contentRecords etc...).
The below change should resolve your...
February 26, 2014 at 3:20 pm
mister.magoo (10/8/2013)
try this instead:
DECLARE @PDFFileName VARCHAR(8000) =
(
SELECT ( SELECT PDF_FileName + '.pdf<...
October 8, 2013 at 5:31 pm
mister.magoo (10/8/2013)
Can you try this to see if it works?(replace the profile and email address and fix...
October 8, 2013 at 5:14 pm
sorry, IE crashed as i edited the reply 🙂
ummm, when i select my variable i get the wierd characters etc.... but when the email generates it shows BR.
how...
October 8, 2013 at 4:37 pm
by putting the '< br/ >' (spaces were removed) it generates this
<html><head></head><body><p style="font-family: arial, verdana, times; font-size: 12px; color: #000000;">Original File.<br/><br/>test.zip<br/><br/>PDF Filename.<br/><br/> abc123.pdf<br/>, test.pdf<br/>, test123.pdf<<br/></p></body></html>
when i execute it i can...
October 8, 2013 at 4:31 pm
mister.magoo (10/8/2013)
I can only think there was a problem with the way you tried?Perhaps if you generate some sample html and post it here we can see what is wrong?
This...
October 8, 2013 at 4:26 pm
mister.magoo (10/8/2013)
October 8, 2013 at 4:16 pm
Edward Boyle-478467 (10/8/2013)
DECLARE @PDFFileName VARCHAR(8000) =
(
SELECT STUFF(( SELECT ', ' + PDF_FileName + '.pdf' + char(13) + char(10)
FROM @PDFResult...
October 8, 2013 at 4:11 pm
Luis Cazares (10/7/2013)
Where are you checking the results? The grid from SSMS won't show line feeds.
I'm checking the results in the actual out of the email, not the grid in...
October 8, 2013 at 3:55 pm
I read about using the CHAR(13) + CHAR(10) and i tried that but no difference.... I then read to just use CHAR(10) and that also failed to work.
There were...
October 7, 2013 at 4:21 pm
dan-572483 (10/3/2013)
It's going to represent the number of seconds, so the possible range is 00 to 59.
one way is like the below. There may be a better method but this...
October 3, 2013 at 11:23 pm
forgot to add some important details. reason I'm doing it this way is because I'm passing the variable @PDFFileName into a email template using:
REPLACE(REPLACE(HTML,'[[FileName]]',@ProcessingFile),'[[PDF_FileName]]',@PDFFileName)
October 3, 2013 at 9:04 pm
Viewing 15 posts - 106 through 120 (of 180 total)