Viewing 15 posts - 4,516 through 4,530 (of 5,109 total)
Yes, Master database first, then the remainder.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 7:02 am
Wrong topic.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 5:25 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 4:49 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 4:41 am
Out-Gridview -PassThru is very interesting. Definitely a consideration for some of my scripts 🙂 Even I don't use the back up solution, I've definitely learned something today.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 4:38 am
It seems that the word wrapping goes a bit odd at the end of a line. When you have a word that is long enough to go on to a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 4:24 am
I almost wonder if the Format menu should be always displayed, rather than only when you hover over.
We have a hard enough time getting people to post their SQL in...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 3:57 am
If you're using two tablixes, you could set them to be hidden depending on the parameter value.
For example, if the tablix for 5 could have a hidden expression value...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 3:49 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 3:44 am
Revenant (1/11/2017)
GilaMonster (1/11/2017)
Eric M Russell (1/11/2017)
GeorgeCopeland (1/11/2017)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 12, 2017 at 3:26 am
Eirikur Eiriksson (1/11/2017)
Suggest you read up on the CONVERT function!😎
Example
DECLARE @DSTR VARCHAR(50) = '20151025'; -- ISO FORMATSELECT CONVERT(VARCHAR(30),CONVERT(DATE,@DSTR,112),101) -- US OUTPUT
The only problem I have with the convert function is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 11, 2017 at 9:55 am
DECLARE @Date VARCHAR(10);
SET @Date = '20151025';
--Assuming format is always yyyyMMdd
SELECT CAST(LEFT(@Date, 4) + '-' + LEFT(RIGHT(@Date,4),2) + '-' + RIGHT(@Date,2) AS DATE);
You should change the format of the date, for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 11, 2017 at 9:33 am
How do we determine how these value should be paired?
In your example you had:
14522345 30245123
Why not any of these?
14522345 31451831
14522345 32452632
14522345 31458142
What's the logic there?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 11, 2017 at 8:42 am
richlion2 (1/11/2017)
Thom A (1/11/2017)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 11, 2017 at 7:36 am
David.Poole (1/11/2017)
I think you may be doing the DBA community a mis-service.
I wasn't intending any mis-service, apologies if it seemed that way.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
January 11, 2017 at 7:01 am
Viewing 15 posts - 4,516 through 4,530 (of 5,109 total)