Viewing 15 posts - 31 through 45 (of 139 total)
Good point. I don't see it as a Primary/Foreign key combination. So there must be a constraint as I cannot add equipment to the history table that doesn't ready exist...
March 10, 2017 at 11:12 am
March 9, 2017 at 2:58 pm
March 2, 2017 at 12:30 pm
For me, I am not using the Split Function.
Normally I only use the Where 'Something' IN (@Variable). Everything is good. The using can 'Select All' or any number...
February 8, 2017 at 12:30 pm
It seems to fail if:
A) I use the TS.Skill In as part of an OR or Case statement in the Where and
B) The user selects more than one skill.
February 8, 2017 at 7:00 am
Try using And (TS.Skill In...
February 8, 2017 at 6:46 am
Try using And (TS.Skill In...
February 4, 2017 at 11:24 am
TS.Skill IN (@TS) works perfectly. I don't know if the drop down list of the SSRS parameter creates a a comma delimited string. I didn't think that was what was...
February 2, 2017 at 9:02 am
February 2, 2017 at 8:42 am
P.S. If I useWhere
HRMst.ActiveYN = 'Y'
And HRMst.Co = @Company
And TS.Skill In (@TS)
It works with multiple selections, but that doesn't...
February 2, 2017 at 8:17 am
I don't believe it is a comma delimited string; I'm still relatively new with SSRS. The program, if...
February 2, 2017 at 8:13 am
February 2, 2017 at 7:49 am
Wow great ideas. I've never thought of that.
Thank you,
August 19, 2015 at 5:32 am
I found it....
The values are not real they are numeric(9,2). I'm still not sure why they were rounding but at least this fixes it.
August 18, 2015 at 2:53 pm
TheSQLGuru (8/18/2015)
assuming both datatypes ARE real, cast the hard-coded values in the isnulls to the same datatpye - not the result of the isnull.
I'm not sure what you mean? ...
August 18, 2015 at 2:34 pm
Viewing 15 posts - 31 through 45 (of 139 total)