Viewing 15 posts - 3,781 through 3,795 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2017 at 8:20 am
Rechana Rajan - Wednesday, May 3, 2017 5:42 AMThanks Thom,
No :w00t:
Ok, before ANYTHING you need to look at that. As...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2017 at 5:49 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2017 at 5:36 am
Ok, well you'll want to split the number out of the string first then. If your data is always going to be in the same format, this makes it a...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2017 at 5:13 am
The procedure takes two values as input , the writes happen only...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2017 at 5:02 am
What do you define as the highest number in your example, 9 or 348? Will your strings always be in the format of XXX000? What have you tried so far?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2017 at 4:45 am
Fairly simple this one.DECLARE @Quarters int = 0;
SELECT DATEADD(QUARTER,DATEDIFF(QUARTER,0,GETDATE()) + @Quarters,0);
The value of Quarters can be changed to be a positive or negative integer....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 3, 2017 at 1:53 am
Not exactly a Cross Tab. It's a simple aggregate, I just needed something...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2017 at 1:55 pm
I was honestly wondering how long it would be before you came along with a Cross Tab style query, Luis. 😉
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2017 at 1:05 pm
One option is using UNPIVOT (Using PIVOT and UNPIVOT). For example:USE TestDB;
GO
CREATE TABLE SampleTable (RandomDate date);
GO
INSERT INTO SampleTable
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2017 at 11:37 am
Although this doesn't work for string literals, it works fine when using a dataset. For example:CREATE TABLE #test (string varchar(20));
GO
INSERT INTO #test
VALUES ('LOHAUANIA');
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2017 at 9:33 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2017 at 8:40 am
I notice your dates in your data are in the format ddMMMMyyyy. Is this actually how they are stored; are you using a varchar to store them?
Can we...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2017 at 7:25 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2017 at 7:10 am
Spam 🙁 (reported)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 2, 2017 at 5:27 am
Viewing 15 posts - 3,781 through 3,795 (of 5,109 total)