Viewing 15 posts - 1 through 15 (of 116 total)
Thank you everyone for answers. All work, and answer my question.
November 12, 2019 at 5:03 pm
Hi an edit in my month values and a diagram of what I am trying to achieve.
IF OBJECT_ID('TempDB..#tmpFUnit','U') IS NOT NULL
DROP TABLE #tmpFUnit
the test table with
CREATE TABLE #tmpFUnit
(rptMth varchar(6),Buiding varchar(4),Unit...
November 11, 2019 at 7:22 pm
I think my table could have been populated better, because there would be rows that have valid dates that in this case I would want to omit because they are...
July 17, 2015 at 9:05 am
Hi Luis, based on the select query, I would only return the two rows that meet the filter in the where clause. When I'm identifying rows that meet bus...
July 17, 2015 at 8:39 am
Thank you amurjani and drew ... so simple ... once I saw it!
June 12, 2015 at 11:00 am
My apologies spaghettidba ... should know better ...
June 12, 2015 at 10:58 am
Thank you cphite, worked like a charm.
April 17, 2015 at 9:25 am
on side note, in the test data the nulls are actually zeros ... sorry about any confusion.
April 14, 2015 at 2:42 pm
Right now we're only working with a few internal data sources that we can control. The final solution will have files from multiple outside clients who will likely be...
April 9, 2015 at 9:46 am
Hi Sean, I am receiving data from many different types of file sources. The data from the each source is being transformed into a comma delimited string with as...
April 9, 2015 at 9:28 am
Thank you for taking time to respond: Eirikur, Jeff, Magoo ...
April 2, 2015 at 7:56 am
Hi, just wanted to close this topic off, I apologize for taking too long to respond at all. Got caught in a rabbit hole ... Anyway, a colleague helped...
April 2, 2015 at 7:18 am
thanks for the suggestion jason, I'm calling a web service in my clr that takes long and lat coords and give back distance 'route' options, rather than an as the...
March 20, 2015 at 11:11 am
Hi Lowell, I had tried the SQLDouble and was still receiving the data type conflict error. Creating a scalar function worked for me. But I think Babe may...
March 20, 2015 at 11:07 am
Viewing 15 posts - 1 through 15 (of 116 total)