Jeff Moden (10/29/2012)

---

For all those...

haiao2000 (10/28/2012)

---

I thought about this...

Well, public record or not, if it were about...

Nice easy question. Thanks, Ron.

Good question, managed to be one of the few to get it right. It wasn't by knowledge alone, however, it took a bit of deductive reasoning as well.

An easy, back to basics question.

There really isn't enough information to really provide you with a good answer. Please post the DDL (CREATE TABLE statement) for the table involved in the query.

Also, to better...

ew0619 (10/25/2012)

---

Out of the string below, I would like to create a view that will show the following fields (target values are in quotes). I have tens of thousands...

DBA328 (9/18/2012)

---

Microsoft SQL Server distributed queries can be used to query data from the Exchange Web Store through OLE DB Provider for Exchange and can be joined to tables...

Although posted by someone different, this is the same as this post. Please post any replies on the other thread.

Yes, yes I am still a live. Just haven't had much to say lately.

Create table statements from initial post:

CREATE TABLE dbo.MyTable_A(

c1 int PRIMARY KEY CHECK (c1 BETWEEN 12501 AND 1000000000),

c2 int IDENTITY)

GO

CREATE TABLE dbo.MyTable_B(

...

sql-lover (10/18/2012)

---

That is correct!

Like I explained, the PK is a surrogate key. MS-SQL needs to generate the key itself, no manual intervention.

Here's the modified code ...

IF OBJECT_ID ('dbo.MyTable_A') IS NOT...

shalinder.verma (10/17/2012)

---

Eugene Elutin (10/17/2012)

---

shalinder.verma (10/17/2012)

---

If you are familiar with recursive CTE, you can use following SQL. You won't have to refer to any tables. Moreover this is much more efficient....

What an awesome win! :w00t:

The Paper Division has a really slim margin between the top and the bottom. It's...