I dont know physics

Is it common for an employer to not allow a PTO carryover from year to year but keep you on an accrual basis? ( I accrue PTO at something like 3.6 hrs a pay period )

It seems that no carryover, but still being on an accrual basis vs an award basis is the worst possible thing for me, short of not having PTO altogether.

How do I use OPENXML in SQL Server 2000 with some elements that are repeated and some elements only contain attributes but others don't?

The problematic part of my XML looks like this:

<ResultSet>

<Result>

<hoursSaturday>Noon to 6:00 pm</hoursSaturday>

<hoursSunday>Closed to Closed</hoursSunday>

<image url="7777.png"/>

<image url="149.png"/>

<field title="Directions" value="From Aber "/>

<field title="Accreditations" value="We belong"/>

</Results>

</ResultSet>

When I use: SELECT *

FROM openxml(@hdoc, '//spResultSet/result', 2)

WITH ([image] varchar(300) 'image/@url',

[image] varchar(300) 'image/@url',

field varchar(255) 'field/@value',

field varchar(255) 'field/@value',

whatever the last @url is gets put into every [image] column, same as the last @Value gets put into every field column.

If I use a 0 or 1 for my flags in my OPENXML statement, other fields aren't read right. I think I need help with the XPATH

How can I convert a char value that I receive from an external data source with a value of '2006926' (supposed to represent September 26 2006 ) to a datetime datatype? Note the '0' is missing from the month. I can not find a way to convert this to a datetime datatype because of the missing '0'. None of the converts or casts I tried could handle this. Is there a way?

I have two stored procedures that are blocking eachother. I have SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED so I think the place the blocking is happening is in the Update/Insert statements within those procs... ?

This is some info about the blocking, both SPIDS say this:

Lock Type : TAB

Lock Status : WAIT

Lock Mode : IX

There are not currently any table hints on the Update/insert statements. So 1.) It looks like the default lock of a update/insert statement is a Table Lock? And 2.) If I add a ROWLOCK table hint, will that help alleviate this?

What I am trying to do is compare fields of matching records to see if they have changed. One table holds new records, the other old records. I only want to select the new ones that have new values... I don't think that all the '<>' opertions are very efficient. Is there a better way to do this?

SELECT m.promotioncode, m.listingid, m.merchantid, m.listinglinkURL, m.listinglinklabeltext, m.listinglinktypeid,

m.listinglinkoptionid, m.listinglinkpoststartdate, m.listinglinkpostenddate, m.sitegroupid, actioncode='U'

FROM#matches m, listinglink ll

WHEREll.listingid=m.listingid and

ll.rowstatustypeid < 900 and

(m.listinglinkURL<>ll.listinglinkurl or

m.sitegroupid<>ll.sitegroupid or

m.listinglinkpoststartdate<>ll.listinglinkpoststartdate or

m.listinglinkpostenddate<>ll.listinglinkpostenddate or

m.listinglinklabeltext<>ll.listinglinklabeltext or

m.listinglinktypeid<>ll.listinglinktypeid or

m.listinglinkoptionid<>ll.listinglinkoptionid

I have a temporary table T1, which holds 'new data' to be inserted into permanent table T2.

Some of the records that are in T1 already exist in T2 so they will need to be Updated. The values in T1 that do not exist in T2 should be inserted. Both T1 and T2 have a ListingID column for a join. Creating a temp table would also be possible if needed.

Deleting the existing rows from the permanent T2 table is not an option, they need to be updated and the new rows inserted. Can anyone recommend a way to do this?

I have 2.4 ghz spread spectrum cordless phone that autoselects the clearest channel everytime you use the phone and there is no way to change the channel manually. I also have a linksys 2.4 ghz wireless router. Using the cordless phone renders my wifi useless 9 times out of 10. I have tried to change the routers wireless channel (possible values are 1-11 I think) but that did not solve the problem. Does anyone know what I can do to prevent this interference?

I think it plays in the opening titles too.