I think what you are looking for is the following

SELECT LogText as [*]

FROM LogFile

FOR XML PATH(''), TYPE

The [*] tells SQL that the data represents XML, so it should retain the...

The correct forum is here: http://www.sqlservercentral.com/Forums/Forum148-1.aspx

Drew

There are a number of ways that you can approach this. I tend to use the system views, because they have some of the necessary joins already set up...

It's actually very simple, but if you have any records that are missing a comma, you will get an index out of range error message. You can fix this...

frfernan (5/5/2011)

---

I'm curious about the use of this field; I never designed a table with a field like that (or don't remember), and when I worked with fields like that...

I used a calendar table fragment for this, because dynamically generating half-hour intervals would be a bit of a mess. Also the conditions under which two time intervals overlap...

frfernan (5/5/2011)

---

You can do it following this code

declare @Temp table(MonthID char(6))

insert INTO @Temp values ('201010')

insert INTO @Temp values ('201011')

insert INTO @Temp values ('201012')

INSERT INTO @TEMP

select convert(char(6), dateadd(m, 1, cast(max(MonthID) +...

Ken Jr. (5/4/2011)

---

Do you want the stored procedure to execute after each row updated, inserted, deleted or after each transaction? Example: If a user inserts 10 rows in a transaction...

That's exactly what triggers are for. You can look up triggers in BOL to find out more.

Drew

PATINDEX is NOT...

Let me be clear.

* It's best to use a datetime field to store and manipulate datetime data.

* Adding a month is manipulating datetime data.

* Your MonthID is...

Do you really need to do a character by character review of the given column or just find columns that contain invalid characters? Perhaps you just need to return...

First, you say that you want a monthID, but your formula actually calculates a WEEK ID.

Second, you don't say how the timestamp field relates to the month ID, if at...

It's just what it says, "The package failed validation." Presumably there is some other error message that gives more information about how it failed. We would need that...

I think what you are looking for is

WHERE field NOT LIKE '%[^0-9]%'

The square brackets specify a subset of characters determined by the contained expression.

The caret (^) at the beginning of...