Category Archives: database

Use SQL to insert a label in front of a DataBound list

Posted on 06/09/2010 by Eric Fickes

Here’s a clever little solution I would like to add to the book of ‘get it done’.  While this particular example uses ASP.NET controls, this concept really applies to any language that supports DataBinding to a control. The base concept … Continue reading →

Posted in .net, database, SQL, tips and tricks | Tagged , , , , , | Leave a comment

What if you want to PIVOT against a text column?

Posted on 04/30/2010 by Eric Fickes

If you’ve ever worked with or researched SQL Server’s PIVOT function, you probably noticed most of the samples pivot against an id column.  Typically an int column like EmployeeID, or StoreID.  That’s fine and dandy, but what happens when you … Continue reading →

Posted in database, microsoft, SQL, tips and tricks, tsql | Tagged , , , , , , , | 2 Comments

Incorrect syntax near the keyword ‘table’ in TSQL

Posted on 04/07/2010 by Eric Fickes

Ran into something little that I know I’m going to forget if I don’t write down. It appears that when using a TABLE variable in tsql ( SQL Server 2005 ), you must DECLARE that variable on it’s own line, … Continue reading →

Posted in database, microsoft, SQL, tsql | Tagged , , , , , | 4 Comments

How to TWEET from a SQL CLR Stored Procedure

Posted on 03/03/2010 by Eric Fickes

Here’s another SQL Server 2005 geek out moment, a CLR SPROC that tweets to Twitter. Big shoutout to Danny Battison for sharing the C# code to post to Twitter. This is what got me started on the C# side of … Continue reading →

Posted in .net, C#, database, microsoft, SQL, tips and tricks, tsql, twitter | Tagged , , , , , , , , , , | 12 Comments