Viewing 15 posts - 3,106 through 3,120 (of 9,725 total)
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
Steve,
Look at Chris's code carefully, because he makes a point I think you missed. OUTER JOINs don't work as OUTER JOINs when you explicity reference the columns in the WHERE...
August 22, 2014 at 4:52 am
djj (8/22/2014)
Brandie Tarvin (8/22/2014)
lpablo (8/22/2014)
DECLARE @Email2 VARCHAR(100)
Set @email= 'helper@sql-server-helper.com'
set @email2='fff@dd.com, helper@sql-server-helper.com,vc@.com'
SELECT case when @email2 like '%'...
August 22, 2014 at 4:46 am
Viewing 15 posts - 3,106 through 3,120 (of 9,725 total)