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. ...

Just to add a little more, you may want to take a look my blog post Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions

Lowell, thank you for reference. Much...

Stressing! (Okay, Databasse Mirroring can be pain.)

Okay,...