Adi: Which rule of Well-Formed XML do you think that 'this is not a valid XML' violates?

UNION [ALL] is an "binary infix" operator, which means that it works like addition (+) and multiplication (*):

{Select statement} UNION [ALL] {Select statement} UNION [ALL] {Select statement} ...

So you only...

Start with telling us what you want to do (not how you think you should be doing it). If you could script the table definition and post that here,...

Try it like this:

DECLARE @FirstDay DATETIME,@LastDay DATETIME

SET @FirstDay =(SELECT DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE())-0,0 ))

SET@LastDay =(SELECT DATEADD(MONTH,DATEDIFF(MONTH,-1,GETDATE())-0,-1))

SELECT

Loanreference

,BranchCode

,Firstdisbursementdate

...

And please post the view definition also.

Tell him to use a SQL Server View. If he doesn't want to be aware that it is a view, try using the VIEW_METADATA option.

What edition of SQL Server 2005 has an "INPUT INTO" statement?

And by the way: this would of course work much faster and much better (many more options) if the Parameter column's data type were XML.

So... what exactly can you change?

umanpowered (10/28/2008)

---

...But rather than have such data appear on every single row in the table, is there some code I can use to have the updated table trigger the creation...

Most tools (like management studio) either filter them out or shunt them off in a "system" folder.

Depends on what you mean by "quick":

Insert into ptApointment(...)

Select ...

From ptSchedule s

Where ScheduleID NOT IN(Select Cast(a.ID as int) from ptApointment a

...

You probably should try another approach. What are you really trying to do with this?

Substring is, like almost all functions and operators in...

Jim Mace (10/27/2008)

---

I have seen is done where you use temporary tables and timestamps, then by grouping and ordering you loop through each one updating the OrderID, but that is...