Viewing 15 posts - 1,156 through 1,170 (of 1,183 total)
According to the BOL any address will work.
BOL ... "The report server does not validate e-mail addresses or obtain e-mail addresses from an e-mail server. You must know in advance...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 30, 2006 at 6:04 pm
Sorry, I was speaking beyond my knowledge level. *grin*
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 30, 2006 at 5:51 pm
This may help....
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=279460
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 30, 2006 at 8:35 am
Is your empID an int datatype?
Try
SELECT CAST (empID AS varchar(20)) + empName
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 25, 2006 at 10:17 pm
Sergiy is correct, but to fix your issue after the fact....
I see two issues here, and keep in mind I'm only beginning to work with text and ntext fields..
1. ~STOLEN...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 25, 2006 at 10:14 pm
I knew there was an easier way [KH] ....
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 25, 2006 at 6:51 am
There may be an easier way, but this works....
select
dateadd( day, 0, cast( datepart ( month, dateadd( month, -18, getdate() ) ) as varchar(2) ) +
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 24, 2006 at 5:09 pm
Karen,
I've come up with a way to do this in standard. Its rough and I plan on tidying it up, but we're using it at my company and it works.
You...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 23, 2006 at 6:03 pm
This is just a quick thought, but did you don't need "AND" in your IIF. And I think you left out the "1" in the line.
=IIF(Fields!Field2.Value = 0, 0, SUM(Fields!Field1.Value)...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 23, 2006 at 4:52 pm
If the serial number is not an issue, this works.
-----------
declare @I int, @rowcount int, @ctr int, @prod varchar(50), @lastprod varchar(50)
select
identity(int, 1, 1) as nDex,
1 as seq,
prodid,
subpartid,
subpartdesc,
subpartserial
into
#tmp
from
subparts
order...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 22, 2006 at 7:00 pm
Does the table PC have a column with the serial numbers?
I have a second table PC that has a ProdID, PC_SubpartDesc1, PC_SubpartDesc2, PC_SubpartDesc3, PC_SubpartDesc4
>> with the matching serial numbers1...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 22, 2006 at 5:34 pm
In your query convert the nulls to a date that you won't hit...
I.E.
select
field1,
field2,
IsNull( Date, '12/31/2999' ) as...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgMay 17, 2006 at 4:31 pm
Another thing to keep in mind is that the more aggregation and grouping that is done through RS, the more time the report will take to run. You may want...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 26, 2006 at 6:13 pm
I would strongly recommend the "Hitchhikers Guide to SQL Reporting Services" There is a TON of information, and it's not a hard read!
Not only does it give samples using SOAP,...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 26, 2006 at 6:09 pm
If you set the "Cascade Delete Related Records" on the tables' relationship, this will allow you to Truncate them.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 20, 2006 at 6:22 pm
Viewing 15 posts - 1,156 through 1,170 (of 1,183 total)