The problem is that you will need to use dynamic sql for the update statment. Oh BTW: you will also want to declare your variables for the tablename and fieldnames to...

Then I would hope you have a datetime column or identity column that you could do the order by on.

True you can't call a stored procedure from within a UDF. However you certainly can use SET. The UDF is very powerful and if you learn to live with it's...

As I stated it is a "Database Project" that I created. In Visual Studio .Net it is under "Other Projects". When you create the project it will ask you to...

You might want to look at the following thread... http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=96968

I think what I would do is change your methodology. I prefer to have all my SPs saved as scripts. Anytime I change the SP I do it from the...

Very nice Thomas! I still think I would limit the depth level. Leaving it open will ultimately leave you in a bit of a performance and maintenance bind.

Here is an example of what I mean.

SET NOCOUNT ON

IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('NRGroups'))

    DROP TABLE NRGroups

CREATE TABLE NRGroups

    (ID_ int primary key, PID int, Grp...

Now you know why I cringe everytime one of my developers wants to do this! If you put a limit on how many levels deep you will support then you...

You got me there Jonathan. However if you don't do it as a correlated subquery it'll return the same results as NOT IN.

As Steve pointed out this is a case of lazyness catching up with you! This is the best reason to ALWAYS explicitly list out the fields you want to insert...

Ahh. Now I see what you are talking about. And yes it is a function of the ANSI SQL begin unable to compare a NULL to anything. I don't think...

Keven,

Even though I work at MS I'm just a developer in same as you when it comes to stuff like this.

You stated...

This looks to me like you are using a trusted connection string and IIS is not configured correctly as AJ has stated. Can you post your connection string so that we...

I would prefer to set up IIS so that it uses a trusted connection to SQL Server. Then when the user logs in have a user table that does the...