Viewing 15 posts - 3,106 through 3,120 (of 9,720 total)
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
Important questions. What data type is DueDate? DATE or DATETIME / SMALLDATETIME?
If a DATETIME variety, do you need everything from midnight on or are you looking for literally 2...
August 22, 2014 at 4:42 am
Aaaannnnnddddd... From the theatre of the absurd, I couldn't get PATINDEX() to work, but I did get CHARINDEX() and REPLACE() to work. I don't know why anyone would want to...
August 22, 2014 at 4:37 am
Myke85 (8/21/2014)
DECLARE @Email VARCHAR(100)
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 @email like...
August 22, 2014 at 4:30 am
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 '%' + @email1 +...
August 22, 2014 at 4:22 am
Bah... Crosstabs...
Luis Cazares (8/21/2014)
Are you seriously taking the advice and code from someone from the internet without testing it?
Why, yes. Yes I am.
Luis Cazares (8/21/2014)
August 22, 2014 at 4:12 am
Viewing 15 posts - 3,106 through 3,120 (of 9,720 total)