Viewing 15 posts - 2,956 through 2,970 (of 9,399 total)
I thought they had changed it for 2014, but I was wrong. Good question.
June 23, 2016 at 5:53 am
ThomasRushton (6/23/2016)
Stuart Davies (6/23/2016)
HappyGeek (6/23/2016)
Ray K (6/22/2016)
whereisSQL? (6/22/2016)
Ed Wagner (6/22/2016)
djj (6/22/2016)
Ed Wagner (6/22/2016)
Manic Star (6/22/2016)
Ed Wagner (6/22/2016)
Luis Cazares (6/22/2016)
Revenant (6/22/2016)
ThomasRushton (6/22/2016)
Manic Star (6/22/2016)
Ed Wagner (6/22/2016)
Grumpy DBA (6/22/2016)
Ed Wagner (6/22/2016)
PerformanceReview
Rate
Raise
Drawbridge
Castle
Palace
Royalty
Glitterati
Paparazzi
Photograph
Def Leppard
Band
Orchestra
ELO
...
June 23, 2016 at 5:48 am
Luis Cazares (6/22/2016)
Brandie Tarvin (6/22/2016)
jasona.work (6/22/2016)
[Commentary deleted by me]
I decided I was getting a little...
June 22, 2016 at 1:53 pm
Luis Cazares (6/22/2016)
Uncomment your preferred line.
WITH CTE AS(
SELECT *, ROW_NUMBER() OVER( PARTITION BY AccountID, Name, Region ORDER BY Special_Flag DESC) rn
...
June 22, 2016 at 1:51 pm
djj (6/22/2016)
Ed Wagner (6/22/2016)
Manic Star (6/22/2016)
Ed Wagner (6/22/2016)
Luis Cazares (6/22/2016)
Revenant (6/22/2016)
ThomasRushton (6/22/2016)
Manic Star (6/22/2016)
Ed Wagner (6/22/2016)
Grumpy DBA (6/22/2016)
Ed Wagner (6/22/2016)
PerformanceReview
Rate
Raise
Drawbridge
Castle
Palace
Royalty
Glitterati
Paparazzi
Photograph
Def Leppard
June 22, 2016 at 1:45 pm
jasona.work (6/22/2016)
[Commentary deleted by me]
I decided I was getting a little too vitriolic with my...
June 22, 2016 at 1:45 pm
jasona.work (6/22/2016)
TomThomson (6/22/2016)
jasona.work (6/22/2016)
Sounds like the next couple weeks / months are going to be...
June 22, 2016 at 11:18 am
David Moutray (6/22/2016)
With SQL...
June 22, 2016 at 10:55 am
Manic Star (6/22/2016)
Ed Wagner (6/22/2016)
Luis Cazares (6/22/2016)
Revenant (6/22/2016)
ThomasRushton (6/22/2016)
Manic Star (6/22/2016)
Ed Wagner (6/22/2016)
Grumpy DBA (6/22/2016)
Ed Wagner (6/22/2016)
PerformanceReview
Rate
Raise
Drawbridge
Castle
Palace
Royalty
Glitterati
Paparazzi
June 22, 2016 at 10:02 am
whymaravele (6/22/2016)
But 0842507889 = 10 digits.. 0 8 4, 2 5 0, 7 8 8 9 those are ten digits
My mistake - I should have said that the value...
June 22, 2016 at 9:03 am
whymaravele (6/22/2016)
I have this function
CREATE FUNCTION [dbo].[fnFormatMobileNumber] (@phone VARCHAR(15))
RETURNS VARCHAR(15)
AS
BEGIN
DECLARE @Formatted VARCHAR(15)
IF (LEN(@phone) > 10)
SET @Formatted = '0' + SUBSTRING(@phone,3,9)
ELSE SET @Formatted = @phone
RETURN @Formatted
END
select
[dbo].[fnFormatMobileNumber](0842507889)
I get 842507889...
June 22, 2016 at 8:56 am
Grant Fritchey (6/22/2016)
June 22, 2016 at 8:39 am
Luis Cazares (6/22/2016)
Revenant (6/22/2016)
ThomasRushton (6/22/2016)
Manic Star (6/22/2016)
Ed Wagner (6/22/2016)
Grumpy DBA (6/22/2016)
Ed Wagner (6/22/2016)
PerformanceReview
Rate
Raise
Drawbridge
Castle
Palace
Royalty
June 22, 2016 at 8:30 am
BWFC (6/22/2016)
jasona.work (6/22/2016)
June 22, 2016 at 7:56 am
Viewing 15 posts - 2,956 through 2,970 (of 9,399 total)