Kenneth, do you happen to know what it's called in 2005? Thanks.

mark lake (3/19/2008)

---

I've recently (about 5 minutes ago) accepted a job as an Oracle DBA, Don't suppose anyone knows of any Oracley type websites that are as good as...

I know SYS and SYSTEM are like sa.

Your crytpic response is creating suspense that's awesome.

Can you be just a bit more detailed in your explanations?

vbandlamudi,

How many times are you going to post this problem?

What you are doing is bad forum etiquette!

In addition, your problem is incomprehensible.

Maybe with some additional and more varied sample data...

PaulB (8/27/2008)

---

1- This doesn't work; you are importing nothing in your example.

2- You do not...

I recently had to add generation of a tray icon to a program. It's essentially done via a Windows API called Shell_NotifyIcon to which you pass a structure which includes...

roger.hurst (8/21/2008)

---

This is a quickie for somebody, I'm sure:

How is "failed login auditing" turned on in SQL Server via some procedural method. I need to set it in a...

How about adding a plate of spaghetti and some sushi.:D

It's not one giant triangle but rather many little ones (for each...

Apart from your specific problems regarding the LIKE operator, I'm very surprised that ss is...

I guess the trick is to generate a view which shows the start date and end date of each employee's stay in a department.

Data:

create table empdep(

empid int,

...

Well, to get back to the OP's original request for sybtax (where I think he meant syntax), here are some simple examples for a Windows based system. Each line is...

Could this be what the OP meant?

It's definitely something I have never encountered in the real world.

create table t(c nvarchar(10))

insert into t values('001')

insert into t values('12')

insert into t values('112')

insert into...

Ahh, that feels better.

But is this truly set based?

Or is this just a SS2000 hack?

I wonder if SS2005 has something to deal with this directly in a select.

Chandru,

This kind of problem has been discussed many times on this forum. You should search for 'generating sequence numbers' or similar terms.

You will need to evaluate the type of solution...