Gail is correct. There are no "row numbers" in a table. You can add an ORDER BY when you query the table, and in that case you can get the...

jay holovacs (4/11/2011)

---

There is LOTS of silly fluff in cars, and lots of unnecessary automation. If you can't determine when you need your wipers on, you do not belong behind...

Joe Johnson-482549 (4/11/2011)

---

First, you mention that turning up your refrigerator is not that bad, but what if it was more malicious -- say they turn it up while you're gone...

Very true, but I wouldn't think this is the case because someone invented a convenience. Only because...

On the surface I...

Rangers look good, Rockies in first place, and Yankees playing well, despite getting shut out last night.

Looks like we have some teams roaring ahead out of the gate, others really...

Interesting. Not necessarily a hard query, but I'll have to see if I can fit it in somewhere.

I was hoping to come, but the timing was bad. If it were 2-3 weeks later, I'd...

Can you run the "dir" job from Agent and have that work?

It's definitely a strange error. It's almost like you have some token or kereberos issue with the job.

If...

Do the select without the cast to datetime and see what data comes back. If you convert everything to varchar at first, you can start to look for places where...

You do pull together the teams quickly, but that doesn't mean you haven't built relationships with people over time. We know people across time, we built relationships across time. If...

If you keep the databases in simple mode, you can really only DR from the night before. That's OK, but really ask your payroll people if the db fails at...

In Management Studio, right click a table, select Script Table, as Create, to wherever and paste that in here. You'll have something like:

CREATE TABLE [HumanResources].[EmployeeDepartmentHistory](

[BusinessEntityID] [int] NOT NULL,

[DepartmentID] [smallint] NOT...

I'd highly disagree. You're assuming that one or two interactions would build some confidence. If I corresponded with a mechanic for a year online, and he/she answered questions I had...

sturner (4/6/2011)

---

Jeff Moden (4/1/2011)

---

I've also seen folks that do it just the opposite. Encrypt the item you're trying to find and look that up in the encrypted column. ...