Re-write the called sp as a function, then modify the select statement to

SELECT ID, dbo.fn_YourFunction(ID) ...

Why do you need the data in the exact textual format that you inserted it with?

SQL returns the values 2.5000, 10.0000, 20.0000, 2.0500, 9.6300, 69.9863 as a representation of...

Thanks for the suggestion. I can delete the files easily enough, through a script or even SQL. I was looking to see if anyone else had come across and had...

Mark,

in SSMS, when you create a Maintenance Plan, you are creating an SSIS package (i'm not clear on whether it's a true SSIS package, or just an SSIS-like package, maybe...

Well written article, for a pointless technique. Sorry Lee, but I have to agree with Joe (except I'd date it in the 1980's, rather than 1950's). With HDD and memory as...

Steve,

no it isnt. It's actually a Profit and Loss report. Due to formatting requirements, I have to include sub-total lines that dont fall into the Accounting hierarchy (broadly speaking the...

Kirk Hasselden's book from SAMS is excellent. Name : "Microsoft SQL Server 2005 Integratin Services", ISBN: 0-672-32781-3.

Good level of detail without assuming that you know it all before you pick...

You're not thick. I believe MS thought it would be fun to see how many DBA's they could confuse by dropping the one-file-per-object and drop-and-create-in-the-same-script options in the initial release of...

Steve,

thanks. I'm actually looking to count the total number of people employed during a given month, so it's the "total value for all records that fall in that date range"...

Try this from SQL Junkies. It's written for SQL 2000, but works as well on SQL 2005.

http://www.sqljunkies.com/howto/b9f7f302-964a-4825-9246-6143a8681900.scuk

-S.

Have you checked for Triggers on the problem tables that would stop the inserts / updates? And have you checked table / column level permissions for the tables?

Dont forget that the new round of DBA certifications are targeted towards SQL 2005, the MCDBA is a SQL 2000 certification.