Recent content by bperry

I think this also might work (untested): update contract set contract.contractceiling = contractceiling * 1.5 from Contract c inner join Organisation o on c.organisationcode = o.organisationcode inner join Address a on o.AddressCode = a.AddressCode Where a.postcodefirstpart = 'NE31'

>It returns a row, creating a unwanted resultset, This does sound a lot like you are talking about the message line that gets returned after a t-sql staement executes, indicating the number of rows affected. To eliminate this message from being returned by your stored procedures, put this...

A UDF is a good thought, thanks. (Note: Need SQL 2000.) Thanks, bp

Okay, I think I may have this solved. I want the difference in years between two dates, accurate to two decimals. Like 23.17 years, for example. I am breaking up the calculation into two parts: the years component (to the left of the decimal) and then the fractional component (to the right of...

>>and do some simple division to get the years. Because of the issue with leap years, I'm thinking that the division is not that simple. (i.e. there isn't a fixed number of seconds in a year.) But perhaps I'm making it more difficult than it is. Does anyone have a working example available? bp

Hi all, I need to calculate the difference between two dates in a table, but I need the result accurate to a couple of decimal points (example 2.53). I'd like to do something like: Select DATEDIFF(yy, Date1, Date2) as MyDifference but of course DATEDIFF() returns an integer, thereby losing...

Okay, that works, thanks a lot, mate. Did you mention you also had another tip to pass along?

Please forgive this newbie question... I'm having trouble seeing just exactly what MSXML 4 (formerly the MS XML Parser) actually is. Is this a separate program that you might independently launch from the Programs menu, or is it actually just sort of plug-in for IE that allows it to interpret...

I think that's because char columns are padded with blanks (thus filling the column with a full 50 characters. When you try to insert new characters, the blanks actually count as characters, so you end up with 'more than 50' counting your new ones. When doing this in EM like you are, you need...

Okay, later tonight or tomorrow. May as let me have your table name (and column names if different than shown) so I can set up with the right names when I am testing. bp

danc: I have a stored procedure that does what you want. (There were at least 3 similar posts in the last few days.) Automatically determines the number of columns required. But uses 'dynamic sql' (EXEC @SQLSTRing) to run, which not everybody likes. If the cursor approach above doesn't work...

I have no idea: I just picked up the Wrox book re: xXML this week, and have a lot of work to do to catch up. But I notice that in Enterprise Manager, if you right-click on the server to get the Server Properties, then click on the Processor tab, there's a checkbox called 'Use Windows NT...

tb: I had to read that three times to see what you were talking about. Now I get it.

Are the clients represented by the 'DistId' column, or is that something else? I notice that the vertical display starts numbering at 0, but the horizontal presentation starts at 1 (i.e. ColId + 1). That's deliberate, right?

Okay, thanks again, I will look into that. If anyone has tips&tricks of any kind, I am all ears. many thancs