J Livingston SQL (2/7/2016)

---

Raxter (2/7/2016)

---

I added the DDL statements to create tables. I apologize for not supplying all the needed information. I am new to this site but will make...

Stix83 (2/7/2016)

---

@hugo, my apologies I am just trying to get to see which method will work best as I am fairly new at SQL:

1. what I need to be done...

Again, if you really need to loop you can do so without temp table.

DECLARE MyCurs CURSOR LOCAL FAST_FORWARD

FOR SELECT brId, sdate

FROM Somewhere

ORDER...

Again, this is not possible.

If you want to export...

I'm not sure I understand the question. Can you please post a full repro script?

(I.e., CREATE TABLE statements for all tables involved, INSERT statements with just enough rows to show...

Do you really need to loop? In most cases, it is much more efficient to use a set-based approach.

If you do need to loop, then using a temp table is...

I'm afraid your post lacks a lot of the details that we need in order to be able to answer it.

First: you say you want a trigger; later you also...

First of all, if you have *any* control over the design of that database at all. Change it. Now. This design is a disaster waiting to happen. It is not...

Duplicate post. Please continue the discussion here.

MyDoggieJessie (2/6/2016)

---

I don't fully understand how this works to detect changes at the table level. BOL states that 'ALL' is the default value yet using 'ALL' doesn't work when...

sestell1 (2/5/2016)

---

david.dilworth (2/5/2016)

---

I had to look that function up as I hadn't seen it before.

Is anyone able to provide a real-world example demonstrating the usage? What I'm interested to...

Reported as spam

Ed Wagner (2/5/2016)

---

Luis Cazares (2/5/2016)

---

curious_sqldba (2/5/2016)

---

I have a stored procedure which takes varchar type variable as an input, the variable should be able to loop through multiple values and execute...

Ed Wagner (2/5/2016)

---

The ms_foreachdb uses a cursor to iterate through the databases on the instance. If you have to cursor through only a few databases, why not write your...

There are basically three ways to return data from a stored procedure.

1. (The version you are using in the stored procedure itself): just run a SELECT statement. The result will...