Viewing 15 posts - 3,946 through 3,960 (of 5,109 total)
If ther'es multiple tables, i need multiple tables in my sample data. I can only work with what I'm given.
Initially you asked for the min and max for...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 10, 2017 at 2:58 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 10, 2017 at 2:33 am
Why do you need it in the report body? Can you not put it in the footer?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 10, 2017 at 2:04 am
With a lot of data, this won't be that quick, but:CREATE TABLE #Weights
(TotalWeight varchar(20));
GO
INSERT INTO #Weights
VALUES
('14 lb 7.6...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 8, 2017 at 10:15 am
So, after getting home, I noticed that you don't actually explain what you want your expected output to be. In your earlier query you only reference code and id, but...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 12:23 pm
As I'm leaving the office now, I'll finish this later, but to save another user creating the sample data:USE TestDB;
GO
CREATE TABLE #Sample
(RECEPÇÃO...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 11:40 am
Consumable sample data, expected output? Does my above SQL not help? 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 11:06 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 11:03 am
Does seem you've missed the aim I'm afraid.
Firstly, this is the SQL you should be looking for:SELECT CAST(a.validtimestamp as date) AS DateStamp,
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 10:18 am
Could you provide a full SELECT statement and consumable Sample data please (normal drill). That JOIN on it's own doesn't really mean a lot to us.
At a guess,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 10:08 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 9:35 am
Duplicate of https://www.sqlservercentral.com/Forums/1869456/I-am-not-getting-COLUMN-TITLES-in-every-page-Why-is-that. Please direct answers to the original thread.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 9:12 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 8:40 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 8:01 am
Using the DelimitedSplit8K function:WITH Paths AS (
SELECT *
FROM (VALUES
('\ENQ123\Testing Data\Testing More Data\Test'),
('\ENQ345\Testing...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2017 at 7:22 am
Viewing 15 posts - 3,946 through 3,960 (of 5,109 total)