Linked servers can't directly pass Windows authentication information more than one link. So if you log in from a workstation to a server (that's not installed on the workstation)...

Create a table that's something like this:

create table dbo.EmailQueue (

ID int identity primary key, -- Just to have something here

DateAdded datetime not null default(getdate()), -- When was it added

SendTo varchar(100)...

Can't see your sample XML, but from the description of what you're talking about, you should take a look at "for XML" in Books Online. It's how you change...

I'm afraid I don't see the purpose of nesting these cursors. The only reason I know of to do that is to take a value from the outer cursor...

As a perhaps cynical note on this, keeping a running list of your accomplishments at a job also makes it much easier to update your resume if/when you find you...

You're welcome.

Would end up looking like what I've attached here.

Bob, I've had that song in my head ever since it was brought up that Mangle was allegedly doing so.

I also have to admit I've had a long-term goal of...

Assuming you're on SQL 2005 (from the forum you posted in), something like this should work:

create table #T (

ID int identity primary key,

Year char(4));

insert into #T (Year)

select '1800' union all

select...

You have to parse the string into a table of values, or use dynamic SQL. I recommend parsing, because that doesn't open up injection security issues.

The fastest way I...

I generally do it as one job, with a specific sequence of actions to take. That way, if one takes a bit longer than you allocated for it, it...

If an index is below a certain size, defragmentation doesn't end up doing anything. From what I can see in the data you posted, the index is tiny, so...

You need the number of entries per year? Right?

How about something as simple as:

select Year, count(*) as Qty

from dbo.MyTable

group by Year

order by Year;

Even if it's varchar, that should work.

Can you provide a sample of what the data looks like? I'm not quite visualizing it from your description.

If, for example, you have dates that look like this, "1/2/1800",...

I'm going to be intentionally offensive here.

I just read the other thread, and I'm going to say that Mangal is one of the vicious people who feel the need to...