I havently really posting much to SQLServerCentral, whether it be my lack of DB knowledge (super low level, maggot-sized, junior dba), or my higher interest in the topic presented by...

Thanks for the advice!

I am going to try some of the free webinars from Pragmatic Works. I learn more effectively through demos and hands-on.

Also, I will start to participate...

This was exactly what I needed! Your sytax and comments were very clear, and this will definitely help me in the future.

I have never used a CTE before, but after...

I am a junior developer, so my answer may not be great, because I too am still learning (hence posting under SQL Server Newbies). I hope this helps.

Assuming @EventList is...

SOLVED!!!!!!!!

Even though I am now just replying to my own replies, I have found the solution and it operates correctly!!

I was even able to shorten it (removing the nested cursor).

The...

So I am receiving some errors when running the cursor. Can anyone provide some insight on this? The cursor and errors are below. The error states that it cannot find...

Here is what i came up with.

Thoughts? suggestions? corrections?

DECLARE @id nvarchar(255)

DECLARE @updatecommand nvarchar(255)

DECLARE @id2 nvarchar(255)

DECLARE @updatecommand2 nvarchar(255)

DECLARE tableCursor CURSOR FOR

SELECT TABLE_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME NOT LIKE '%aspnet%'

ORDER...

Here it is.

However, something is not right at SET @updatecommand = N'UPPER(' + @id + ')'

DECLARE @id nvarchar(255)

DECLARE @updatecommand nvarchar(255)

DECLARE columnCursor CURSOR FOR ...

after looking through lowell's reply I thought of that (information schema columns)!

I am working on a cursor that will utilize it and will post for suggestions and comments in a...

Sorry, I am a junior developer and still learning both SQL code and application code. It has been passed down to me as a task to perform this in sql...