Viewing 15 posts - 7,141 through 7,155 (of 9,400 total)
This sounds like it's due to the time. When you pass your parameters as 09/01/2014 and 09/30/2014 and then query using them, a row with a date of 09/30/2014...
October 21, 2014 at 12:25 pm
Sean Lange (10/21/2014)
rodjkidd (10/21/2014)
spaghettidba (10/21/2014)
rodjkidd (10/21/2014)
spaghettidba (10/21/2014)
Ed Wagner (10/21/2014)
Gianluca, where are you located in Italy?I'm in Conegliano, home of the Prosecco sparkling wine.
It's 50 km from Venice.
Welcome back Gianluca! So...
October 21, 2014 at 11:06 am
spaghettidba (10/21/2014)
rodjkidd (10/21/2014)
spaghettidba (10/21/2014)
Ed Wagner (10/21/2014)
Gianluca, where are you located in Italy?I'm in Conegliano, home of the Prosecco sparkling wine.
It's 50 km from Venice.
Welcome back Gianluca! So not that far...
October 21, 2014 at 9:18 am
g.britton (10/21/2014)
try to move the logic from vbscript to sql and use dbmail to send the email
That's definitely a better approach. While I do like xp_cmdshell, it probably isn't...
October 21, 2014 at 8:46 am
Gianluca, where are you located in Italy?
October 21, 2014 at 8:42 am
Jeff Moden (10/21/2014)
The BatchID column appears as an INT, an NVARCHAR(10), and an NVARCHAR(50) depending on what table you're in.
Jeff, I don't remember creating a login for you on my...
October 21, 2014 at 8:37 am
Gary Varga (10/21/2014)
Ed Wagner (10/21/2014)
October 21, 2014 at 6:57 am
spaghettidba (10/21/2014)
It's been a very long time since I last posted on THE thread...
Actually it's been a very long time since I posted regularly on the forums, but now I...
October 21, 2014 at 6:55 am
The biggest thing that hit home in the article was the constant juggling of priorities. "This is most important...wait, this is most important...drop everything and look at this, but...
October 21, 2014 at 6:44 am
Lynn Pettis (10/20/2014)
Sean Lange (10/20/2014)
Lynn Pettis (10/20/2014)
October 20, 2014 at 12:58 pm
A very interesting question and I got to learn something new, which is always the goal with the QOTD. Thanks.
October 20, 2014 at 10:45 am
GilaMonster (10/20/2014)
Me: I should probably get a DBA hat for when I'm focusing on security, encryption, data protection...
GM (Development): So that we know when to ignore you.
I do so hope...
October 20, 2014 at 10:42 am
Sean Lange (10/16/2014)
October 16, 2014 at 6:47 am
david.holley (10/16/2014)
Thanks. I wasn't certain about if I should post it in both or not.
Many of the regular posters view the most recent posts by date, so we'll see it.
I...
October 16, 2014 at 6:46 am
david.holley (10/16/2014)
October 16, 2014 at 6:42 am
Viewing 15 posts - 7,141 through 7,155 (of 9,400 total)