Recent content by alexjones

I've dug into window functions, which, I agree, are way cool. However, I can't seem to find a specification that doesn't "jump over" the active status when setting the date ranges for the inactive status. I've tried lag and lead, first_value and last_value. Instead of getting: OrganizationID...

Database is SQL Server 2012. I am unfamiliar with windowing functions. Might you give me an example?

I have a table tracking, say, an organization's participation in a particular program. The relevant columns in this table might look something like: OrganizationID Year Status 1 1999 Inactive 1 2000 Inactive 1 2001 Active 1 2002 Active 1...

XML Newbie question. The XML file being created is UTF-8 encoded. Does it make any difference if the data is stored in SQL Server as varchar or nvarchar?

That is very cool. Thank you!

Thanks for the quick response. The kicker here is the requirement that the number be rounded up to the nearest EVEN tenth. So 24.48 should round up to 24.6 and ceiling(24.48 * 10) / 10 yields 24.5. alex

Examples: 24.31 would round up to 24.4 24.48 would round up to 24.6. Anybody got a slick way of doing this?

I am a relative newbie with respect to SSIS, so I don't know if this is the proper forum for my question. My file records have over a hundred fields, all different lengths. The documentation gives the start and end columns for each field. Record length is 972 characters. There are probably...

Is there some way to remove javascript embedded in my excel 2007 worksheet? I need to import these data into a SQL Server database.

I'll try that. Thanks. If I have some fuzzy lookups down the line, do I continue to use partial cache with these?

I'm having memory issues when trying to do some "divide and conquer" lookups. I have a reference table - call it Person. Each record contains a unique ID, LastName, FirstName, BirthDate, Gender. I have a second table - call it Respondent. Each record also has an ID, LastName, FirstName...

I often find that the questions I neglect to ask get me in the most trouble. Thank you for your response to this newbie question. Alex

This product was installed on a stand-alone laptop for me, to be used as a BI learning and experimentation tool. Most of the services are set to log on as "Local System". I have no admin training or experience. So, I would just like to know if I can leave it as is, or, if not, what those of you...

That seems to have done the trick! Thank you so much. Have a star [smile]

Thank you for your quick response. The code you suggested resulted in the error: XQuery [#XmlSourceTable.XmlData.value()]: 'value()' requires a singleton (or empty sequence), found operand of type 'xdt:untypedAtomic *' I got the same message after replacing...