Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2007-05-07 : 17:01:43
|
| Hello All!I have a job that we wrote in SQL 2000 that loops through and finds all the orders pending verification and distributes them via emal to 100+ sales people every night. Each email is sent to the individual sales rep. I did this using sp_makewebtask and attaching the html file to an email and using a WHILE statement to loop thorugh all pending entries in sql.I recently learned that sp_makewebtask is not going to be around for the next release and that I should use RSS for all future development. Question: How can I achieve the same result outlined above using RS? How can I dynamically create and distribute HTML files?I know that RS is xml based, but some pointer on how/where to start would be much appreciated.Many Thanks.... |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-05-08 : 03:32:30
|
| I have an RSS feed and I used this [url]http://www.developerfusion.co.uk/show/4597/[/url] to help create it. I like this approach as it means that all the XML is generated for you by the class. I adapted it to VB.net which was pretty easy so if you want that let me know and I will post it. Having said all that I'm not sure how well it will work for your circumstances but it should at least be a startsteve-----------Don't worry head. The computer will do all the thinking from now on. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-08 : 04:57:40
|
| I've got a current project which might benefit from this Steve.Currently they use a Web Service to interrogate if there are any new "records" for them, and if so the App. lists them. (Sort of like an Inbox if-you-will).Would RSS be better route for this type of this? What's the Pros/Cons and benefits over Web Service?Sorry for my ignorance!Kristen |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-05-08 : 07:02:11
|
Oooh Kristen I'm sure there are much more knowledgeable people on this than me here.  RSS feeds are pretty simple and tend to show simple data with a link to more information. So for example, my RSS feed shows the free disc space on my server drives. i.e. just a number essentially. I look at it and if it is of concern I click the link which takes me to a web page I have setup with more info on it (in my case transaction log sizes and that sort of thing)Web services are more sophisticated in that you can pass parameters to them.I suppose that the difference is that of Push and Pull, i.e. you have to actively call a web service whereas an RSS feed can pop up a nice little box to tell you that something has changed (at least mine does, but that is Google desktop doing it, can't remember if the one in Vista does that, only had it a few days). Apart from that RSS readers are pretty common these days so people can choose the one they prefer or keep their existing one. I think the more recent versions of Outlook can read RSS feeds.My RSS feed is scheduled to run regularly so in that sense I have some control over when the data is refreshed and can tweak it if I need to, though I am not sure that is quite the "correct" way to do this sort of thing it works for me. Then I am the only person consuming this feed!I am quite certain someone here can give more solid advice than mine but I hope this helps. I would be tempted to say - if it aint broke ...steve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2007-05-08 : 08:52:09
|
| I don't think I was clear enought. when I said RS I meant Reporting Services not RSS feeds.Thanks. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-05-08 : 10:49:09
|
Oops - I only saw this line quote:
I recently learned that sp_makewebtask is not going to be around for the next release and that I should use RSS for all future development.
and assumed the rest was talking about that tooassume = ASS of U and ME  sorrysteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2007-05-08 : 11:33:22
|
| Sorry Guys, my mistake. I do need a solution however. How can I generate HTML reports from select statements without using sp_makewebtask?Any ideas? |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-05-09 : 03:30:51
|
| If you look in the master database you will be able to see the code for sp_makewebtask. Perhaps you could modify that to your requirement in the new environmentsteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
|
|
|
RSS replacement for sp_makewebtask