Glad you got it.

BEGIN...END is only needed when a function has multiple statements. Multiple statement table-valued functions are bad for performance, while inLine table-valued functions won't affect performance and would...

The function you tried has no RETURN. All functions need to return something.

Also, ORDER BY is not allowed in functions and views,...

fergfamster (4/29/2016)

---

hi Guys, Gals-

I have the following query which works well. However, changing this to reside inside a table function has been challenging. Any suggestions?

--===== Suppress the auto-display of rowcounts...

As part of personal experience, I would suggest to get away from cursors for this thing. Making complex calculations one row at a time will slow down your system in...

cmick 77911 (4/29/2016)

---

I would turn it into a column and order by it. Cleaner this way.

SELECT

(CASE WHEN AddDt > UpdateDt

THEN AddDt

ELSE ISNULL(UpdateDt, AddDt)

END) AS MaxDt,

Id, Name,...

Brandie Tarvin (4/29/2016)

---

HA! Even SSMS agrees I have too many jobs. Using just a part of the code from Lowell's second link (to create the drop job stuff), I got

An...

To start on why it stays in an infinite loop, you have the Set @AutexCount before the begin, so this is the only statement running as a loop without any...

Divine

Just to be sure, I like to use the quotename function.

SELECT 'IF EXISTS (SELECT 1 FROM msdb.dbo.sysjobs_view WHERE name = N' + QUOTENAME( name, '''') + ')

...

yb751 (4/28/2016)

---

Luis beat me to the sample data speech...but that being said I would advise not to use ordinal position in your ORDER BY clause. It's a bad habit...

Please post some sample data (no need for real data) and expected results based on that data. To know how this is needed read the articles in my signature.

This is...

Corsair

Read blogs, articles...

An alternative to John's nice query.

ALTER PROCEDURE Doc124NEW_new (@DMIGRATIONNEW nvarchar(128)) --Objects can only have 128 characters. Could use sysname instead.

AS

SET NOCOUNT ON;

-- SET NOCOUNT ON added to prevent extra result...

tindog (4/28/2016)

---

Did the queries Luis provided not work? What happened?

An alternative would be to change your parameters to DATE instead of DATETIME, then use BETWEEN as you have (without the...