Again, if you would please post table defs (CREATE TABLE statements), sample data (series of INSERT INTO statements for the tables), and expected results that properly illustrate what it is...

Didn't think of this earlier, but you really shouldn't be using @@IDENTITY either. You should be using SCOPE_IDENTITY().

mcommmgr (2/1/2010)

---

That is correct. And going forward too of course. I am imagining when we hot 8/1/2010, my academic year would now be 1011 instead of 0910. So on and...

lmu92 (2/1/2010)

---

Please note my statement from one of my previous posts 😉

Any...

I'm sorry, but I really need something to work with to help. Tables, sample data, expected results all would help greatly with understanding the problem.

mcommmgr (1/25/2010)

---

I have a standard datetime field value. I need to write a query that looks aggregating numbers by acedemic year. This acedemic year is defined by August 1st thought...

Stumbled onto the thread the Lutz was talking about. Steve took care of the sample data.

All I did was verify the EXECUTE statement syntax in Books Online (Shift {f1} in SSMS).

Glad I could help.

Try this:

exec InsertVersion 'EE','JUL','2001-01-01','2001-02-01','dw134121',1, @id OUTPUT

Care to provide an example of what you are talking about? Table def(s) (CREATE TABLE statement(s)), sample data (series of INSERT INTO statements for the table(s)), expected results based...

To make things a little clearer, I hope, the following are equivalent:

select * from dbo.Customer cus where exists(select * from dbo.Order ord where ord.CustomerID = cus.CustomerID);

select * from dbo.Customer cus...

Agree I must with Alvin and Roy.

Depending on how many records your inserting into your table variables, you may want to change those to temp tables. As the number of rows increases the chances of...

I have some code for you, it requires that you have a Tally table to work. You should look at the fourth article I reference below in my signature...

Converting your existing function into an Inline TVF is not going to be easy and it may not solve your problem. One reason I say that, NVARCHAR(MAX)/VARCHAR(MAX) fields. ...