Viewing 4 posts - 1 through 4 (of 4 total)
i fixed my code to support the "problematic" gmail which strips any CSS styling...
and as you say "keep it simple" , so NO bcp, NO xp_cmdshell ,NO Blat = ONLY...
June 20, 2013 at 7:30 am
No Need to put <head> tag 🙂 this is a In-Line CSS in the <body> of the HTML...
BUT Gmail is striping any Style (CSS) out of the HTML......
June 20, 2013 at 2:32 am
Why not using CSS?
Example:
DECLARE @bodyMsg nvarchar(max)
DECLARE @subject nvarchar(max)
DECLARE @tableHTML nvarchar(max)
SET @subject = 'Query Results in HTML with CSS'
SET @tableHTML =
N'<style type="text/css">
#box-table
{
font-family: "Lucida Sans Unicode", "Lucida Grande", Sans-Serif;
font-size: 12px;
text-align: center;
border-collapse:...
June 20, 2013 at 1:35 am
the fastest way to remove time from datetime is:
select CONVERT(datetime,floor(convert(float,getdate())))
Itzik Ben-Gan had a big post on Date Manipulation with benchmarking..(long time ago..)
April 6, 2010 at 11:07 pm
Viewing 4 posts - 1 through 4 (of 4 total)