Viewing 15 posts - 2,101 through 2,115 (of 3,738 total)
SQLRNNR (11/17/2011)
That's a lot more simple than the expression I use. So easy thanks for posting back.
I'm glad that I remembered; I did not think I was going to...
November 17, 2011 at 6:10 pm
I remembered what I did.
Simply right click on the text box select properties and specify a date format.
November 17, 2011 at 5:45 pm
MyDoggieJessie (11/17/2011)
Did you get your email issue all fixed up in the other...
November 17, 2011 at 3:04 pm
=DateAdd("d", -(WeekDay(Today(),2))+1, Today())
Displays the last day of last week.
11/12/2011 12:00:00:00 AM
How can I format it to omit the time?
November 17, 2011 at 2:53 pm
Disregard this post, I'm going with an HTML solution.
November 17, 2011 at 1:14 pm
Database mail is disabled in that Server.
I created the following SP.
CREATE PROCEDURE [dbo].[usp_SMTPMail]
@SenderName VARCHAR(100),
@SenderAddress VARCHAR(100),
--@RecipientName VARCHAR(100),
@RecipientAddress VARCHAR(100),
@Subject VARCHAR(200),
@Body VARCHAR(8000)
AS
SET NOCOUNT ON
DECLARE @oMail INT --Object reference
DECLARE @resultcode INT
EXEC @resultcode =...
November 17, 2011 at 8:23 am
Lowell (11/17/2011)
email is raw text mode or html mode?is that a static footer/email, or are the elements pulled dynamically in a SQL statement?
The Following are variables derived from a Cursor
@EMailRecipient
@Company...
November 17, 2011 at 8:05 am
SQL_Nw (11/16/2011)
Yes, but thats in 2005, in ssrs 2008 there are options of specifying landscape/portrait by hitting appropriate radio button , then one doesnt need to specify length/width
OK Thanks!
November 16, 2011 at 2:56 pm
Kind of a dumb question.
I just saved the Summary and Detail as seperate reports.
November 16, 2011 at 8:50 am
I figured it out.
Just reverse the width and height.
November 16, 2011 at 8:49 am
Sean,
That was a dumb mistake but at least it was not something difficult.:laugh:
Thanks! I had two CTE's based on different DB's but almost identical.
I'm done with that but I just...
November 15, 2011 at 1:39 pm
Sean Lange (11/15/2011)
The query you posted looks on the surface like...
November 15, 2011 at 1:15 pm
Sean Lange (11/15/2011)
What is the issue? From the sample you posted it looks like your totals are correct.
Sean,
Sorry I fuged the numbers, I have been here over 9 hours no...
November 15, 2011 at 1:05 pm
Hi,
I can create the connection in 2005. That is not what the post was intended to be about.
The thread is about dynamically setting the connection string.
I had other issues when...
November 15, 2011 at 10:31 am
Gianluca Sartori (11/15/2011)
Database Mail disabled for security reasons?And OLE automation enabled instead?
Weird, I would do the exact opposite.
Yes, I agree but sometimes you can't convince someone that that is the...
November 15, 2011 at 8:17 am
Viewing 15 posts - 2,101 through 2,115 (of 3,738 total)