you are welcome.

Would this help?

SELECT Employee_Number, Program,

CHAR(COALESCE([104],0)) AS [IMM 104],

CHAR(COALESCE([109],0)) AS [IMM 109],

...

Are you looking for something like this?

SELECTOBJ.type_desc, OBJ.name, SM.DEfinition

FROMsys.sql_modules SM

JOINsys.objects OBJ

ON OBJ.[object_id] = SM.[object_id]

Scott,

(Edit: ohh just saw that you came back with a reply)

My suggestion is not to use this query below. Its just to show you that you need to write...

Best thing for you to do is to just go one step ahead and test it to see if it works!

As per BOL,

No Transact-SQL statements in a table-valued function...

I dont think so.

You're welcome, but apart from what I mentioned (as Kingston is also asking) do you have any reason why you do not want to use row_number ?

Yes, thanks. Dense_rank is a better way since there could be a tie and dense_rank handles it well.

untested (corrected) code (since you have not provided data to test)

Select *...

Did not really look at that SP as your requirement and what it does looks entirely different. I am guessing you need a function to split it and create a...

Hint: Windowing function Row_number() and order by clause. Do your research and let us know. Thanks 🙂

Thats a nice one by Henrico too, here is a classic one..

DECLARE @iDate DATETIME,

@val INT

SET @iDate =...

It was bit hard to understand the requirement for me. May be thats one of the reasons why you did not get any response to this topic. Data provided should...

I am not certain about ADO.NET but should not you set DBNULL.Value to your variable d?

(Sorry if I am holding the other end of the stick)

Go to section c in this and give it a try. Let us know if you are stuck somewhere. Thanks.

http://msdn.microsoft.com/en-us/library/ms190307(SQL.90).aspx

Ohh!!! There cant be a...