By returning as a recordset I meant:

CREATE PROCEDURE sp_test

     @paramater1 varchar(10)    , @parameter2 varchar(100))

AS

SET NOCOUNT ON

INSERT INTO tblName (value1, value2) VALUES (@paramater1 , @parameter2 )

SET NOCOUNT OFF

SELECT SCOPE_IDENTITY() Identity

GO

Then you capture...

Personally, I've found returning the output as a recordset makes it much easier to return the value to DTS.  Output parameters have always needed stupid work-arounds like the one you...

Good article...It's nice to see some C# code for a change.  this works well for small amounts of data (like lookup lists), as storing to much data in memory can...

No problem, glad you help.  There are definitely some simple "best practices" to follow, but you are right that there is lot of ignorance regarding these.  And people still argue...

I don't know how or if these guys answered your question, but....

"Am I on the right track? Will I need another 20 LEFT Joins for each code in the tables?...

Great follow up, Steve, thanks!  And good work on the forum.

For an awesome article on open source and Brazil, check out this Wired article (it's free!

I don't believe that this is possible with SQL2K.  Per BOL, "A table used in a snapshot or transactional publication can have a maximum of 255 columns and a maximum...

Or, the simple answer is not to delete your worktables, but use "truncate" instead.

cl

Nice one, Joe...I actually had to run this before I understood what you were doing.  A very subtle use of charindex.

create table Temp_DAY (dt varchar(20))

Insert Temp_DAY values ('Monday')

Insert Temp_DAY values ('Tuesday')

Insert Temp_DAY values...

Yeah, listen to Remi on this one...

But, if you stubbornly decide to do this the wrong way, here's how:

declare @TableName sysname

select @TableName = 'Table_' + convert(varchar(12), getdate(), 112)

if object_ID(@TableName) is not...

There's actually a script by Ed Cardin featured in today's email:

http://www.sqlservercentral.com/scripts/contributions/1310.asp

This is definitely a valid option, and provides a way of specifying whether a day is a holiday or...

Yeah, that's a dilly of a pickle.  The only thing I could suggest is a data transformation between the call to the database and sending the data to the presentation...

Ah, an int not a varchar...should have read carefully.  And Frank and Mr. Robertson already answered with good solutions anyway.  The UDF threw me off...

cl

Ah!  No...sorry, not that I'm aware of...not automatically.

Basically, you're requiring two things, the client app needs full names, and you want a small xml file.  The problem is these requirements...

I personally use identity columns a lot, as integers perform much better than char or varchar columns, especially when joining tables.  However, this can cause performance problems when looking a value up by...