Viewing 15 posts - 2,596 through 2,610 (of 5,109 total)
Chrome is not supported by SSRS I'm afraid. Well, not 2008. SSRS 2016 does, and was the first to officially, support it, but prior to that you will often get...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 14, 2017 at 2:11 am
GAH!!! Comic Sans!!!! MINE EYES!!!!!!!!!!!!! MINE EYES!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Ok, back to normality. CHAR(10) is the Line Break character. So you'll need to use the REPLACE function. REPLACE(StringData,';',';' + CHAR(10))
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 14, 2017 at 2:01 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 14, 2017 at 1:45 am
I would also avoid using FORMAT as well. CONVERT and the style code 126 returns the display format you are after.
If, however, you are storing your datetimes as...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 3:32 pm
Looks like you have a many to many relationship. It's true that an order will contain many items of equipment, and a piece of equipment can be within many orders,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 3:16 pm
Hi jagjitsingh,
I don't mean to be rude, but you've been asked and shown enough times to post your questions properly (with DDL, Consumable Sample Data, Expected results, etc)....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 5:56 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 5:50 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 5:35 am
MAX(LEFT(c1, 1)) OVER(ORDER BY id ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING)
Let's split this into several sections:LEFT(c1, 1)
Returns the left most x character(s) from a string. The...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 4:55 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 3:36 am
I have to ask, but why are you permitting dates to be stored as I string in the first place? They should be stored as a date or datetime(2). Storing...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 3:29 am
Use a CTE and ROW_NUMBER(), ordered by Date Descending. Then only return the rows (from the CTE) where the value of your ROW_NUMBER() column is 1.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 3:01 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 2:54 am
Ok, let's all turn this into something a bit more "readable".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 13, 2017 at 2:05 am
Viewing 15 posts - 2,596 through 2,610 (of 5,109 total)