If you or your users already have the nice report, pivot table, vlookups or offset(match()) structure, formatting and so forth generated, I have had success providing business users, within Excel,...

Are you sure you understand your business requirements? Beach house rental agreements I've seen have a time grain of one week, typically Saturday to Saturday, however, within a rental...

Regarding "some type of closed track", try exercising the old school common law "right to travel" by walking or riding a horse on an interstate highway some time.

In...

You have what you posted when you ask SSMS to generate an insert script for you. Generating an insert script doesn't generate the values you want to insert! ...

Is the underlying model that a Position is a specific atomic work assignment with a 0..1 relation with employees?

IE, the organization might have 100 Positions, of which 85 are currently...

Sharon,

You are asking two separate questions here:

" is there a way to compare the next record in the query to the previous record"

and

"i would like to see if there is...

This forum is provided by a company that sells a tool that will do what I think you are describing.

Scroll up, click on Redgate's banner, and see if...

This can get you:

abc def jkl mno ...

Stefan Krzywicki (10/13/2010)

---

Brandie Tarvin (10/13/2010)

---

The Dixie Flatline (10/13/2010)

---

There is just something I always find curious about posts like these. If English isn't...

It semes SQL Express installs a disabled SQL Server Agent, so my initial suggestion of putting your T-SQL script into an agent job T-SQL step won't work (homework assignment: search...

Jeffery Williams (9/29/2010)

---

Right....

I am looking for some recommendations into doing this natively through Excel. Not sure how my job title plays into this however any recommendations on the coding...

I found the line about training statisticians to think in SQL to be telling. Immediately after undergraduate college, I washed out of a graduate program in a physical science...

"One way to avoid worrying about NULLs is never to use them, always declaring columns as not allowing NULLs and designating default values for "empty" or "unknown". This will save...

While I appreciate the point of view of the article, I think it misses two points:

First, there's a great ecosystem of what I call "cargo cult" developers and adminstrators which...

As this site is a community service of Red Gate, I'm curious if you've tried Red Gate's SQL Compare and SQL Data Compare tools? I use them, and they're...