Viewing 15 posts - 3,091 through 3,105 (of 9,712 total)
thomashohner (9/10/2014)
I thought the 2008 cert was expired anyway?
After I posted here, I read an article on MSSQL Tips that said no more 2008 certs would be handed out after...
September 10, 2014 at 9:49 am
Wunderbar! I'll take a look.
Thank you.
September 10, 2014 at 5:37 am
It's always better to certify on the latest rather than the one that is about to become obsolete, unless you plan on only working for people who use SQL 2008....
September 10, 2014 at 4:29 am
Shiva N (9/8/2014)
hi please provide me the Training kit on xxxx@xxx.xxxx
Go to Microsoft's website for training kit information. You can order one through there.
By the way, it is a REALLY...
September 9, 2014 at 4:15 am
satish.saidapur (8/22/2014)
HiI have faced same issue after updating SP.
When the Database take offline and back to online its work fine...
That is...
August 25, 2014 at 7:16 am
SQLisAwE5OmE (8/23/2014)
Hi Brandie,"I've created a job to initiate failover of the mirrors in case of database failure"
Do you mind sharing how you setup the job?
The job I set up is...
August 25, 2014 at 6:52 am
Myke85, your code still has the same problem that Tom pointed out. Are you sure that's the code you want to stick with?
August 25, 2014 at 5:56 am
That is a good point, Tom. And not something even my Theatre of the Absurd code addresses.
August 22, 2014 at 11:07 am
Luis Cazares (8/22/2014)
I can't relate to the Phineas and Ferb moment. Should I watch more episodes? 😀
ABSOLUTELY.
Misc. Person: Aren't you boys a little young for ...
Phineas: Why, yes. Yes we...
August 22, 2014 at 10:49 am
Luis Cazares (8/22/2014)
Are you mocking my signature? :ermm:I hope that it can create awareness. :hehe:
I am not mocking the signature. I am drawing attention to something that most people might...
August 22, 2014 at 9:26 am
You are quite welcome.
EDIT: It occurs to me that you might want to substitute "trandate" for GETDATE().
August 22, 2014 at 7:46 am
ChrisM@Work (8/22/2014)
Brandie Tarvin (8/22/2014)
ChrisM@Work (8/22/2014)
Brandie Tarvin (8/22/2014)
Chris,Why the STUFF() and the XML?
It's concatenation of values from different rows of the same column, Brandie.
Split up the email addresses onto different...
August 22, 2014 at 7:41 am
rkl1v09 (8/22/2014)
Hi Brandie,Due date is DATETIME and i am literally just looking for 2 months data.
Kind Regards,
R
Then instead of
WHERE DATEDIFF(MONTH,a.trans_date,a.due_date) >= 2
Try
WHERE a.due_date >= DATEADD(m,-2,CONVERT(DATE,GETDATE(),101))
This gives you every date...
August 22, 2014 at 7:38 am
ChrisM@Work (8/22/2014)
Brandie Tarvin (8/22/2014)
Chris,Why the STUFF() and the XML?
It's concatenation of values from different rows of the same column, Brandie.
Split up the email addresses onto different rows, eliminate any...
August 22, 2014 at 6:24 am
Viewing 15 posts - 3,091 through 3,105 (of 9,712 total)