Viewing 15 posts - 451 through 465 (of 3,544 total)
Add another column to signify row type or ordering and union all to join the two sets of data, i.e.
SELECT 1 AS [RowType],
'Brockton Hospital' AS [col1],
...
Far away is close at hand in the images of elsewhere.
Anon.
April 7, 2016 at 6:17 am
Brandie Tarvin (4/7/2016)
I've got MY lightcycle. Where's yours?
At the end of the tunnel....
trouble is it's a bl**dy long tunnel 😛
Far away is close at hand in the images of elsewhere.
Anon.
April 7, 2016 at 5:44 am
Sean Lange (3/30/2016)
Far away is close at hand in the images of elsewhere.
Anon.
March 30, 2016 at 8:30 am
Sean Lange (3/30/2016)
Far away is close at hand in the images of elsewhere.
Anon.
March 30, 2016 at 7:43 am
Chad Crawford (3/29/2016)
Feeln' good. 😀
+1
I am a developer and I knew the answer :w00t:
:sick: Blurgh! I hate C#
Far away is close at hand in the images of elsewhere.
Anon.
March 30, 2016 at 2:30 am
Sean Lange (3/24/2016)
... I always figure the questions asked by threadizens would make me cry. 🙂
Cry, I'd be too afraid to go to the interview :pinch:
Far away is close at hand in the images of elsewhere.
Anon.
March 24, 2016 at 8:29 am
=Split(Fields!PRE_LAB_VAL,"=",-1,CompareMethod.Text)(1)
Far away is close at hand in the images of elsewhere.
Anon.
March 9, 2016 at 5:29 am
If you can get the list into a dataset then you can use the dataset in a tablix and use the field in an expression in the textbox in the...
Far away is close at hand in the images of elsewhere.
Anon.
March 1, 2016 at 2:26 am
DATEPART(hh,'01/01/2016 13:23:42:985')*60*60*1000
+DATEPART(mi,'01/01/2016 13:23:42:985')*60*1000
+DATEPART(ss,'01/01/2016 13:23:42:985')*1000
+DATEPART(ms,'01/01/2016 13:23:42:985')
Far away is close at hand in the images of elsewhere.
Anon.
February 29, 2016 at 8:36 am
Textbox control has a 'Go to URL' option in Actions via textbox properties
You can point to a PDF using file:// reference, either fixed or using an expression.
Far away is close at hand in the images of elsewhere.
Anon.
February 29, 2016 at 8:26 am
Are the numbers and NA in separate rows or in the same column?
WHERE [column] LIKE REPLICATE('[0-9]',LEN([column]))
will check for integer values only
SELECT LEFT([column],PATINDEX('%[^0-9]%',[column])-1)
will return numbers before the first character that is...
Far away is close at hand in the images of elsewhere.
Anon.
February 29, 2016 at 7:59 am
when I compare the original DateTime column of data
Where are you viewing the original value, if in Excel then check the formatting of the cell as Excel will round...
Far away is close at hand in the images of elsewhere.
Anon.
February 29, 2016 at 6:47 am
Also check out the Switch expression
Switch(IsNothing(fields!date2.value), "no", DateDiff(DateInterval.Day, fields!date1.value, fields!date2.value) >= 0, "no", True, "yes")
Far away is close at hand in the images of elsewhere.
Anon.
February 29, 2016 at 6:19 am
If it is truly a black box then using any table(s) will not work because if you know the what the output will be then it is not a black...
Far away is close at hand in the images of elsewhere.
Anon.
February 18, 2016 at 6:15 am
djj (2/9/2016)
Dogs seem not to learn..
True.
What may smell horrible to you, may not to the dog :sick:.
My dog has a penchant for hedgehogs :pinch:
Far away is close at hand in the images of elsewhere.
Anon.
February 9, 2016 at 6:23 am
Viewing 15 posts - 451 through 465 (of 3,544 total)