Should not be too difficult if there is always a blank as delimiter.

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17517 might give you some ideas

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Can you post some sample data?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Actually when you look at the code of this procedure you will know why it is undocumented, but I agree that you won't get a 'shorter' solution to type.

Just to add one more

DECLARE @base_date DATETIME

DECLARE @end_date DATETIME

DECLARE @offSET int

SET @base_date='01.02.2004'

SET @end_date='31.12.2004'

SET @offSET=1

SELECT * FROM mytest

SELECT

person,

birthday,

DATEADD(yy,@offSET,CAST(CAST(day(birthday)AS CHAR(2))+'.'+CAST(month(birthday)AS CHAR(2))+'.'+CAST(year(getdate())AS CHAR(4))AS DATETIME)) AS [Next Birthday],

FLOOR(CAST(DATEADD(yy,@offSET,CAST(CAST(day(birthday)AS...

This might help

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=18119

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Since you can write your t-sql code in one line or each word in a new line and the used approach may vary from developer to developer in your organization,...

hm...I'll ask my network admin

Frank

http://www.insidesql.de

http://www.familienzirkus.de

Just a couple of thoughts.

Whether stored procedures are precompiled or not is not relevant.

It *might* be that the first execution of a procedure takes a little bit longer than...

Well, at least your results are consistent to what you have noticed. Same space allocated, but roughly half the space used.

All I would do has been mentioned above, and I...

I really enjoyed it, although I'm inclined to mention that some people out there who are ANSI SQL hardliners would now argue:

quote:

---

SQL...

I suggest this onr for reading http://www.algonet.se/~sommar/arrays-in-sql.html

Frank

http://www.insidesql.de

http://www.familienzirkus.de

quote:

---

The 'ordinary' user should not be able to change the datbase structure. I think that would be a failure. That's why I...

You mean you want to have all db's structure synchronized?

Do you change your database objects via EM?

If so, you should get in touch with the Query Analyzer. The scripts you...

quote:

---

I was blamed for crossposting last time, so if this is not the right group - please help me anyway.

---