Create us a sandbox. A couple (perhaps 2 to 4) of tables, some sample data for the tables (not a lot, just enough to cover the problem domain), and...

Biank (3/13/2013)

---

I'm trying to chekck the existance of a table first and then get a value ONLY IF when the table is there. So, I tried this;

if exists (select...

Or:

DECLARE @time TABLE (StringTime VARCHAR(6))

INSERT @time

SELECT '112345'

UNION SELECT '12345'

UNION SELECT '2345'

UNION...

Sean Lange (3/13/2013)

---

tn_350z (3/13/2013)

---

Hopefully, I am posting this in a right area if not I am sorry. Dont mind the $$$$,#### and ****

I am trying to get the last...

I can't figure out what your problem is here.

fmuzul (3/13/2013)

---

Lynn Pettis (3/13/2013)

---

Nothing here to work with. Many of us have optimized SQL to perform similar calculations in the database reducing processing time from hours (or longer) to...

Look at the table sys.objects, it has the columns create_date and modify_date. This won't tell you the last table data in a table was updated or when a stored...

fmuzul (3/13/2013)

---

Eugene Elutin (3/11/2013)

---

...

But, the most important thing, is that making the change in a C++ procedure let me use the full power of the C++ language. Can't be beaten...

ryan.mcatee (3/13/2013)

---

To demonstrate this behavior:

CREATE SCHEMA testA

GO

CREATE SCHEMA testB

GO

CREATE TABLE dbo.Cities (city varchar(50))

GO

CREATE TABLE testA.Cities (city varchar(50))

GO

CREATE TABLE testB.Cities (city varchar(50))

GO

INSERT INTO dbo.Cities VALUES ('Chicago')

INSERT INTO testA.Cities VALUES ('Cairo')

INSERT INTO...

Sean Lange (3/12/2013)

---

I can't for the life me remember the details but there is...

Sean Lange (3/12/2013)

---

You have enough points that I can assume you are not around here. Please post ddl, sample data and desired output. I suspect you want a cross tab....

Especially when you deal with ownership chaining.

Will have to research further later.

It is interesting behaviour.

Actually, if you do not provide the schema for the object it will look...

Never mind on mine at the moment, needs more work. Have to look at it tonight.