Now I see the full article. I really can't explain it. At home I use ie6 but in the office I use ie7. Thus I quickly connected to my workstation...

Tomm Carr (10/26/2007)

---

Michael Meierruth (10/26/2007)

---

If you want an answer to that, see my spec a few pages back. It makes sense out of adding a day to Monday that gives...

If...

Tomm,

I have checked it out and it seems to work just fine for everything I threw at it. Even though I'm not happy...

By the way, here is another simple way to eliminate the datepart headache:

-- capture these for known dates as they may vary based on SET DATEFIRST and who knows what...

Sergiy,

When the start date is a workday it works fine. When the start date is a...

I tried

select dbo.fnAddWeekdays_Sergiy('20071017',4) and get '20071022'

select dbo.fnAddWeekdays_Sergiy('20071017',5) and get '20071024'

Can't remember if Sergiy's intention was to include the start date or not, but one of these two has got to...

The concept of calculating the number of work days between two dates and adding work days to a date are based on the concept of a start date and an...

I think that's why...

Matt Miller (10/22/2007)

When in the eidtor window - pick the CODE IFCODE, and paste your code between the two tags.

Still won't paginate it, but that's what puts the gray background...

How to you select/copy/paste the sample code in the gray background areas?

When I do this I don't get any line breaks.

In the past I too was suffering from the wide presentation in my Lotus Notes mail client. It sometimes returned to normal but then became wide again, sometimes different widths...

I think the OP wants the functionality of an identity column without an identity column. I strongly recommend to convert the table via 'insert into select...' preceeded by 'set identity_insert on table-name'.

An alternative is...

I ran

create table t(code varchar(10))

select code from t

through a jdbc driver without any problems.

However, when I did

select code2 from t

I get your error message. Thus 'code' doesn't seem to be...

Well, just counting the number of node separators should give you the sequence length. Load this function and do

select sequ,dbo.seqlen(sequ) from sequences

if exists (select name from sysobjects where name='seqlen' and...