When I was a newbie doing development (mid 90's), it was made very clear to me that you do NOT put inline SQL in your code - PERIOD. What...

Wow.... that's great! I will bag the sp_executesql (perhaps it will be applicable in a future effort) and go with the XML datatype (something I've not had a chance...

Yep, that was my fear Jack.

Thanks again to all. This site is the best.

Lisa

Thank you Jack and GSquared. I will try what you suggested GSquared. Is my Example 3 a bad idea? Should I just avoid that path? If...

You could also use information_schema.columns (something I learned about on this site). Using blatent plagerism of Mr. Matt Miller's response:

Declare @myTable sysname

declare @columnnames as varchar(max)

Select @mytable='YourTableName',

...

Good heavens! That was so simple it's embarrassing! Nothing like trying to kill an ant with a sledgehammer!

Thank you PW!

(I was just so anxious to use that darn...

I am a web developer using Visual Studio .NET. I know this is not the tool you mentioned, but I thought it might be worth mentioning that in your...

How about this:

-- Create a dummy proc

create procedure GetYears as

select 1, 2005, '10/1/2005'

union

select 2, 2006, '10/1/2006'

...

Let me take a shot at this.  If I understand your question correctly, you want to show the total projects in the database.  But your query is filtering for a...

I read your question a little differently.  Hope I'm not coming out of left field here.  Just this week, I needed to find a value in a database - not...

This may help get you going in the right direction.  I recently learned this handy trick thanks to this site.

-- Create a source table with IDs missing

--...

Here is a very good article with sample code that was referenced in another post about heirarchical data:

http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm

Our datacenter is in another state so if there is any hiccup in my VPN connection, I get this error.  Usually everything is back up quickly and I can run...

Two extremely valid points I'd like to emphasize:

Joe Middleton mentioned the "rising level of mediocrity in today's workplace".  How very true.  The people I sit near spend seemingly half their...

I feel so lucky to have found this career.  I got a degree in Business Administration with an emphasis in Marketing and took a job out of college...