Properly used, UDF's good; improperly used, UDF's BAD.

Comes down to an "It depends".

I have a set of tvf that allow me to do As Of queries against our ODS database....

Anders Pedersen (5/8/2008)

---

Kind of the same as I hesitate when people with years of experience suddenly go and get one of the MS certifications. I mean. ...

Use this as a starting pointing:

DECLARE @Query varchar(8000), @ColumnName varchar(50), @vho char(6)

--SELECT @ColumnName = ChannelMapName

--FROM myTable WHERE idNum = 1

--SELECT @vho = vho_cd

--FROM myTable WHERE idNum = 1

set @ColumnName =...

Do you know how the data was encrypted?

😎

Frank,

That sort of helps, but doesn't. The output sample at the top of the post doesn't match the sample data at the bottom. I am a visual type...

Not sure where you are looking in BOL, but my local copy matches the version at Microsoft, and it clearly discusses 5 system databases, including the Resource Database (mssqlsystemresource.mdf/mssqlsystemresource.ldf).

Here is...

Sugesh Kumar (2/4/2008)

---

you can't change collation at server level. but you can change the collation on particular columns. also changing collation on the database only makes the collation effective for...

True, the Resource database is not listed in sys.databases; however, the documentation does refer to it as a special, read-only database that must be located in the same directory as...

As far as I know, you can't turn it off.

😎

Actually, I'm still waiting for more information since the four date fields are in four seperate tables. BDate is in TableB, CDate is in TableC, and DDate is in...

NEI (Not Enough Information). Still don't know what you are trying to accomplish, plus the code I see just looks wrong from the get go. Plus, you have...

Rhetorical question on your part? A good answer would be this: T-SQL is SET based while the other languages you mention (even if OO) are procedural. Many...

First, only partial code in your post, so not a real help. Second, why do you need to create a cursor dynamically? What are you try to accomplish?

😎

I'd also be interested in seeing enough of the tables DDL, some sample data, and expected results so I could understand the query as well. Looks like you have...

Marvin,

No problem. I didn't even notice the error in the code itself. I just thought I'd help fix it to give the first of the month.

😎