What would the Sql syntax look like if I wanted to select +/- 10 days of a d
elivery date.
For instance; Table has Actual Delivery Date & Expected Delivery date, and u
sing the ABS Sql function, I want to select only the rows from the table tha
t were delivered with +/- 10 days.
And even if it's not the best way to do it, I would really like the info on
ABS.
Any ideas?
Thanx!Use DATEADD function like:
BETWEEN DATEADD ( d, -10, dt ) AND DATEADD ( d, 10, dt )
Anith|||I don't know your table structure or sample data, but here's a guess:
WHERE ABS(DATEDIFF(DAY, ActualDate, ExpectedDate)) <= 10
"Jude" <judes@.email.uophx.edu> wrote in message
news:%23NQBlSwQGHA.1868@.TK2MSFTNGP09.phx.gbl...
What would the Sql syntax look like if I wanted to select +/- 10 days of a
delivery date.
For instance; Table has Actual Delivery Date & Expected Delivery date, and
using the ABS Sql function, I want to select only the rows from the table
that were delivered with +/- 10 days.
And even if it's not the best way to do it, I would really like the info on
ABS.
Any ideas?
Thanx!|||Trust me I would, but someone taking a class asked me this question & I said
I had never used this function, but knew where to go to ask the experts!
Thanx!
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:u1RNgfwQGHA.4960@.TK2MSFTNGP12.phx.gbl...
> Use DATEADD function like:
> BETWEEN DATEADD ( d, -10, dt ) AND DATEADD ( d, 10, dt )
> --
> Anith
>|||Fantastic, Thanx so much Aaron! This is a favor for a friend who is taking
a class, and since I haven't used this function & would just use DateDiff
functions, I didn't have an answer. I knew the experts in here would
though!
Thanx again!!!!!
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e%23zWkBxQGHA.1160@.TK2MSFTNGP09.phx.gbl...
>I don't know your table structure or sample data, but here's a guess:
> WHERE ABS(DATEDIFF(DAY, ActualDate, ExpectedDate)) <= 10
>
> "Jude" <judes@.email.uophx.edu> wrote in message
> news:%23NQBlSwQGHA.1868@.TK2MSFTNGP09.phx.gbl...
> What would the Sql syntax look like if I wanted to select +/- 10 days of a
> delivery date.
> For instance; Table has Actual Delivery Date & Expected Delivery date, and
> using the ABS Sql function, I want to select only the rows from the table
> that were delivered with +/- 10 days.
> And even if it's not the best way to do it, I would really like the info
> on ABS.
> Any ideas?
> Thanx!
>
>
Showing posts with label delivery. Show all posts
Showing posts with label delivery. Show all posts
Thursday, March 8, 2012
Saturday, February 11, 2012
About E-mail delivery Settings, where can I set E-mail account and password
Hello, everyone,
During RS setup, we can only set two values about E-mail delivery, one is
SMTP server address or name, the other is Sender E-mail address.
My question is , now the popular SMTP server all require Authentication,
where can I set E-mail account and password?
Thanks in advance.
EdwardRS only supports anonymous and NTLM authentication. If you need to use basic
auth your best option is to set RS to use the local smtp server to relay the
messages. In the RSReportServer.config file, set the smtppickupdirectory to
you local smtp pickup directory and then set SendUsing to 1.
You will then need to configure the local smtp server to do the actual
relaying.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Haitian" <xinhaitian@.126.com> wrote in message
news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
> Hello, everyone,
> During RS setup, we can only set two values about E-mail delivery, one
> is
> SMTP server address or name, the other is Sender E-mail address.
> My question is , now the popular SMTP server all require Authentication,
> where can I set E-mail account and password?
> Thanks in advance.
> Edward
>|||Thanks, Daniel.
BTW, do you mean to use the SMTP service built in IIS ?
> RS only supports anonymous and NTLM authentication. If you need to use
basic
> auth your best option is to set RS to use the local smtp server to relay
the
> messages. In the RSReportServer.config file, set the smtppickupdirectory
to
> you local smtp pickup directory and then set SendUsing to 1.
> You will then need to configure the local smtp server to do the actual
> relaying.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Haitian" <xinhaitian@.126.com> wrote in message
> news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
> > Hello, everyone,
> >
> > During RS setup, we can only set two values about E-mail delivery, one
> > is
> > SMTP server address or name, the other is Sender E-mail address.
> >
> > My question is , now the popular SMTP server all require
Authentication,
> > where can I set E-mail account and password?
> >
> > Thanks in advance.
> >
> > Edward
> >
> >
>|||Yes, that is what I was referring to.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Haitian" <xinhaitian@.126.com> wrote in message
news:OfK9IDfWFHA.3188@.TK2MSFTNGP09.phx.gbl...
> Thanks, Daniel.
> BTW, do you mean to use the SMTP service built in IIS ?
>
>> RS only supports anonymous and NTLM authentication. If you need to use
> basic
>> auth your best option is to set RS to use the local smtp server to relay
> the
>> messages. In the RSReportServer.config file, set the smtppickupdirectory
> to
>> you local smtp pickup directory and then set SendUsing to 1.
>> You will then need to configure the local smtp server to do the actual
>> relaying.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Haitian" <xinhaitian@.126.com> wrote in message
>> news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
>> > Hello, everyone,
>> >
>> > During RS setup, we can only set two values about E-mail delivery,
>> > one
>> > is
>> > SMTP server address or name, the other is Sender E-mail address.
>> >
>> > My question is , now the popular SMTP server all require
> Authentication,
>> > where can I set E-mail account and password?
>> >
>> > Thanks in advance.
>> >
>> > Edward
>> >
>> >
>>
>
During RS setup, we can only set two values about E-mail delivery, one is
SMTP server address or name, the other is Sender E-mail address.
My question is , now the popular SMTP server all require Authentication,
where can I set E-mail account and password?
Thanks in advance.
EdwardRS only supports anonymous and NTLM authentication. If you need to use basic
auth your best option is to set RS to use the local smtp server to relay the
messages. In the RSReportServer.config file, set the smtppickupdirectory to
you local smtp pickup directory and then set SendUsing to 1.
You will then need to configure the local smtp server to do the actual
relaying.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Haitian" <xinhaitian@.126.com> wrote in message
news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
> Hello, everyone,
> During RS setup, we can only set two values about E-mail delivery, one
> is
> SMTP server address or name, the other is Sender E-mail address.
> My question is , now the popular SMTP server all require Authentication,
> where can I set E-mail account and password?
> Thanks in advance.
> Edward
>|||Thanks, Daniel.
BTW, do you mean to use the SMTP service built in IIS ?
> RS only supports anonymous and NTLM authentication. If you need to use
basic
> auth your best option is to set RS to use the local smtp server to relay
the
> messages. In the RSReportServer.config file, set the smtppickupdirectory
to
> you local smtp pickup directory and then set SendUsing to 1.
> You will then need to configure the local smtp server to do the actual
> relaying.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Haitian" <xinhaitian@.126.com> wrote in message
> news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
> > Hello, everyone,
> >
> > During RS setup, we can only set two values about E-mail delivery, one
> > is
> > SMTP server address or name, the other is Sender E-mail address.
> >
> > My question is , now the popular SMTP server all require
Authentication,
> > where can I set E-mail account and password?
> >
> > Thanks in advance.
> >
> > Edward
> >
> >
>|||Yes, that is what I was referring to.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Haitian" <xinhaitian@.126.com> wrote in message
news:OfK9IDfWFHA.3188@.TK2MSFTNGP09.phx.gbl...
> Thanks, Daniel.
> BTW, do you mean to use the SMTP service built in IIS ?
>
>> RS only supports anonymous and NTLM authentication. If you need to use
> basic
>> auth your best option is to set RS to use the local smtp server to relay
> the
>> messages. In the RSReportServer.config file, set the smtppickupdirectory
> to
>> you local smtp pickup directory and then set SendUsing to 1.
>> You will then need to configure the local smtp server to do the actual
>> relaying.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Haitian" <xinhaitian@.126.com> wrote in message
>> news:%23WZRXrPWFHA.3076@.TK2MSFTNGP12.phx.gbl...
>> > Hello, everyone,
>> >
>> > During RS setup, we can only set two values about E-mail delivery,
>> > one
>> > is
>> > SMTP server address or name, the other is Sender E-mail address.
>> >
>> > My question is , now the popular SMTP server all require
> Authentication,
>> > where can I set E-mail account and password?
>> >
>> > Thanks in advance.
>> >
>> > Edward
>> >
>> >
>>
>
about delivery channels
Which deleverychannels does NS support?
Can i use smartphone to receive notification?
If can,have any samples for this? Thanks
Out of the box, SSNS supports 2 delivery channels - SMTP and file. But it's easily extensible so you can use the API to create your own delivery channel to send notifications to an SMS device, a fax server, voicemail, whatever you can programmatically address.
BOL is a good place to start, but Shyam Pather's book has a better example of how to do this.
HTH...
Joe
|||
I have reading Shyam Pather's book of sql server 2005 .but I have not its example. who can give the example,special customer deliver channel . my e-mail: sichuanwww@.163.com. thank you very much.
|||In have Shyam's 2000 book, he describes how to create a custom delivery protocol in Chapter 10. I don't have his new book in front of me at the moment but I feel sure it's in there too.I don't have a custom delivery protocol that I can share at the moment. I'll see if I can create a simple one and post it on my blog - http://www.sqlns.com. It'll be a couple of weeks before I can get to it though.
HTH...
Joe
about delivery channels
Which deleverychannels does NS support?
Can i use smartphone to receive notification?
If can,have any samples for this? Thanks
Out of the box, SSNS supports 2 delivery channels - SMTP and file. But it's easily extensible so you can use the API to create your own delivery channel to send notifications to an SMS device, a fax server, voicemail, whatever you can programmatically address.
BOL is a good place to start, but Shyam Pather's book has a better example of how to do this.
HTH...
Joe
|||
I have reading Shyam Pather's book of sql server 2005 .but I have not its example. who can give the example,special customer deliver channel . my e-mail: sichuanwww@.163.com. thank you very much.
|||In have Shyam's 2000 book, he describes how to create a custom delivery protocol in Chapter 10. I don't have his new book in front of me at the moment but I feel sure it's in there too.I don't have a custom delivery protocol that I can share at the moment. I'll see if I can create a simple one and post it on my blog - http://www.sqlns.com. It'll be a couple of weeks before I can get to it though.
HTH...
Joe
Subscribe to:
Posts (Atom)