Viewing 15 posts - 466 through 480 (of 3,544 total)
Brandie Tarvin (10/30/2015)
Okay DataTables are a C# thing? I honestly did think you were talking SQL Server. And now DataViews?
In this context, yes C# as in .NET
Look up DataSets, DataTable...
Far away is close at hand in the images of elsewhere.
Anon.
November 2, 2015 at 2:27 am
Brandie Tarvin (10/30/2015)
Far away is close at hand in the images of elsewhere.
Anon.
November 2, 2015 at 2:14 am
Eirikur Eiriksson (10/30/2015)
David could maybe use a little shrinking but he doesn't need a shrink:-P😎
LOL Thanks Eirikur 😀
Far away is close at hand in the images of elsewhere.
Anon.
November 2, 2015 at 2:06 am
Brandie Tarvin (10/30/2015)
David Burrows (10/30/2015)
Far away is close at hand in the images of elsewhere.
Anon.
October 30, 2015 at 11:39 am
Just a guess but if you had pairs of labels (ie J1,J1a,J2,J2a etc) to hold job name and response respectively then
string[] MyJobs = SvrBJobNames.Split(',');
Label[] JobNameLabels = {J1,J2,J3,J4,J5};
Label[] JobResponseLabels = {J1A,J2A,J3A,J4A,J5A};
for...
Far away is close at hand in the images of elsewhere.
Anon.
October 30, 2015 at 10:10 am
Or
string[] MyJobs = SvrBJobNames.Split(',');
if there are no empty entries 😉
Far away is close at hand in the images of elsewhere.
Anon.
October 30, 2015 at 8:31 am
Also you need to put the WHENs in the order you want them tested
ie
WHEN A.[Measure] IN ('RTT-01','RTT-04','RTT-07') AND A.Value NOT LIKE '%[0-9.]%' THEN ''
WHEN A.[Measure] IN ('RTT-01','RTT-04','RTT-07') AND A.Value >...
Far away is close at hand in the images of elsewhere.
Anon.
October 29, 2015 at 9:01 am
dramaqueen (10/29/2015)
I have added that extra where clause. I agree with what you are saying but it still come back with an error.
Sorry forgot to mention that you will have...
Far away is close at hand in the images of elsewhere.
Anon.
October 29, 2015 at 8:57 am
ChrisM's solution is correct.
The error will be due to inconsistances between your Measures and numeric/nonnumeric Values
You will need to add extra WHEN conditions to avoid implicit cast errors
i.e
WHEN A.[Measure]...
Far away is close at hand in the images of elsewhere.
Anon.
October 29, 2015 at 8:18 am
ChrisM@Work (10/1/2015)
David Burrows (10/1/2015)
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
Where have you found ESB on draught?
Many many...
Far away is close at hand in the images of elsewhere.
Anon.
October 1, 2015 at 9:56 am
ChrisM@Work (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
Where have you found ESB on draught?
Many many moons ago when...
Far away is close at hand in the images of elsewhere.
Anon.
October 1, 2015 at 7:23 am
Poor performance :angry:
But....
WITH
cte1 (Dt,Item,RowNo) AS (
SELECT Dt,Item,ROW_NUMBER() OVER (ORDER BY Dt ASC)
...
Far away is close at hand in the images of elsewhere.
Anon.
September 16, 2015 at 10:13 am
DECLARE @value int = 2;
WITH cte AS (
SELECT Dt,Item,
ROW_NUMBER() OVER (ORDER BY Dt ASC) -
ROW_NUMBER() OVER (PARTITION BY Item ORDER BY Dt ASC) AS [Grp]
FROM #tab1 t
),
...
Far away is close at hand in the images of elsewhere.
Anon.
September 16, 2015 at 6:14 am
In Tablix make blue section the detail group and the yellow section group header (Phase Code)
See attached sample.
Far away is close at hand in the images of elsewhere.
Anon.
September 15, 2015 at 7:23 am
if we have same job_cd and permit_nbr, reference number should be same
Is this for existing allocated reference number?
take max(reference number) from the table +1 for all rows where reference_nbr column...
Far away is close at hand in the images of elsewhere.
Anon.
September 15, 2015 at 6:48 am
Viewing 15 posts - 466 through 480 (of 3,544 total)