You may also consider certification as one way to demonstrate knowledge and give you a slight edge.

Besides the many books out there I would recommend BOL (Books Online) for SQL 2005 as well: http://msdn.microsoft.com/en-us/library/ms130214(v=sql.90).aspx

It's a great resource with plenty of examples to work with...

I've seen this error a few times and usually the Log Shipping catches up. I've also seen some cases where it has stopped working all together and in that case...

I wouldn’t create a separate table for LastCall and I would reduce the redundant fields. You could take tblNewNumbers and call it Contacts and add a ContactId IDENTITY column that...

I would also add going to user groups and doing some networking. You can also search meetup.com for groups related to the field you are interested in that are in...

I’m not sure exactly what you are trying to accomplish but if you are looking for a script to automatically populate dates into a table I created and example below....

Another approach could be to alter the definition of the current table that holds the email addresses and add an Id column to store the Primary Key Id field from...

If you don't have access to the code but have access to the SQL Server you can use the SQL Server Profiler to create a Trace and see what SQL...

Another way to do the replace is REPLACE(field, CHAR(34), 'feet')

You mentioned it never gets to the ELSE portion of the code. It sounds like you want output for each row...

Hi Amigo,

It is possible to work with a stored procedure as a dataset by using OPENROWSET but you first must enable ad hoc distributed queries:

sp_configure 'show advanced options', 1

reconfigure

go

sp_configure...