INSERT INTO schedule

SELECT class_id

, class_dte

...

In this case, i.e. if you have control over what...

Using substring is one solution, you could of course do a double cast, and use the datetime functions then:

CAST(CAST(data AS VARCHAR(20)) AS datetime)

Out of curiosity, is there really a need...

On 2000:

SELECT USER_NAME(o.uid) AS owner

...

You...

you could cast the int to a varchar (since it is an email it will be textual anyway, and replace nulls with say ''

Example:

select coalesce(cast(intcolumn as varchar(10)),'') from mytable

Regards,

...

A simple solution (may not be the best though):

SELECT a.Policy.query('data(./Roles/Role/Name)')

, a.Policy.query('data(./GroupUserName)')

FROM xmlTable CROSS APPLY x.nodes('//Policy') AS a(Policy)

To set it up (for others who would like to play):

create...

Could you please repost your question and escape the < with & lt;

XML can get filtered out from posts if they are not escaped 🙁

Regards,

Andras

mick burden (11/19/2007)

---

I've used update to add data to records that fall between 2 dates, is it possible to use INSERT in the same way

update set field1 = 'test'...

You could also make the (left([First name],1)+left(surname,1)) expression a computed column.

Regards,

Andras

ritesh (11/19/2007)

---

Hi , Im trying to get a new column called initial .. I want to obtain this data from the two columns First name and surname.

eg. Bob Ryder...

Chrisb (11/19/2007)

---

Yes, it do work in 2000. However, after Upgrading to SQL 2005, it will not work anymore and I want to correct all possible errors before Upgrading to SQL...

Books online has a good example: http://technet.microsoft.com/en-us/library/ms179331.aspx

Regards,

Andras

Also, isn't the information your query returns the page size? In which case it is 8192 in 7, 2000 and 2005. Since 7 is the earliest compatibility mode you can...

Just a note that this table is still available in 2005, so your query seems to work.

Regards,

Andras