Ed B (4/12/2013)

---

Does the view have to be schema bound?

Where I used to work there was a common misconception that a schema bound view was the same as an indexed...

Also, using profiler, check the connection options for the problem database.

In Object Explorer, right click on the server, click properties. On the General page, what is the language setting?

sqlfriends (4/12/2013)

---

We need to change a view that is using schema binding. In the view we used a UDF.

But when alter it, it complains that the function is not schema...

djackson 22568 (4/12/2013)

---

majorbloodnock (4/12/2013)

---

TravisDBA (4/11/2013)

---

Any answer the man seem to give was not the right answer, so either the question was not plain enough up front or the interviewer was...

A quick BING search (search string: ORACLE and INFORMATION_SCHEMA views) led me here, does this help? http://www.alberton.info/oracle_meta_info.html

TravisDBA (4/12/2013)

---

Yes. They're called requirement specs and they are...

Have you checked the error logs to see if anything is going on elsewhere with SQL or Windows?

GilaMonster (4/12/2013)

---

Lynn Pettis (4/8/2013)

---

2) Actual execution plan as a .sqlplan file, not XML plans you included in...

True, Gail, but apparently it is required that a temp table...

The CTE and NoCTE versions are comparable on a small data set. I'd like to try them both on a million row data set and see how they compare.

Perhaps...

grasshopper26 (4/12/2013)

---

Hi,

I went to retrive the the maximum of one cloumn in the table meet some where criteria. I tried the folowing SQL

Select Name, Max(version) from table1...

jcrawf02 (4/12/2013)

---

Lynn Pettis (4/5/2013)

---

GilaMonster (4/5/2013)

---

Am I the only person who gets 'I don't think that's true' replies to their posts from a certain person and am I the only one...

The code runs fine in SSMS on my system. Haven't tried it using sqlcmd yet.

Have you been able to find a site that supports fisql? Your two posts...

ByronOne (4/11/2013)

---

Hi Lynn

Is it possible to adapt this code slightly so that rather than updating the sales figures for a specified product type ie LEISURE. It creates a new product...