I have a table name tblMHCIntakeDetail in this table is a field named lngdataid and a field named strtype.
There is a field name lngdataid and a field named strtype. In the strtype column there is are value Issue or Pop and in the lngDataid there are values 225 and 172. What I am looking for is to get everyone who has the value of 172 which means a child and is also code as a 225. Thanks
What I really need is a count of all
SELECT strtype, lngDataid
FROM tblMHCIntakeDetail where lngdataid = ?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …