I figured out why I was getting the syntax error near @count. I needed to place a SET in front of it. Anyways, the query ran, but my logic is...

I also tried this code based off of an example I found here (http://itknowledgeexchange.techtarget.com/itanswers/bulk-update-in-sql-server-2005/), but I'm getting the same "incorrect syntax near '@d' message.

declare @count as int

declare @d...

I'm stuck on the looping part. Here's what I have so far:

declare @count as int

declare @stopcount as int

set @count = 1

select @stopcount = count(*) from tasks

while @count <> @stopcount

begin

UPDATE tasks

SET...

Okay, I tested and the code from my last post worked well. So, I was able to directly update the column to subtract 5 hours from the UTC time.

So, now...

Thanks for the responses. Is it possible to use the UPDATE statement to subtract 5 hours from the UTC time, directly on the [created date] column like this:

UPDATE table_name

SET [created...

The export wizard worked well for this application. I did save the SSIS package, but I am having trouble locating it. From your post I gather I use BIDS to...

You interpreted it correctly. I was hoping it would be something simple. I'll try using BEGIN and END statements. I am going to use it to update multiple fields (columns)...

Thanks for pointing me in the right direction - the UPSERT worked. However, I am struggling with one thing pertaining to the update part.

Basically, I did something like this...

if exists...

SSC Veteran -

I basically understand everything in the block of code below, except the last two lines. I understand that we are first doing a SELECT query in paranthesis, but...

Thanks for all the super fast responses. Unfortunately, there are a few things that I need clarification on. This might seem basic, but it appears that you are using correlation...

bitbucket -

It sounds like I might have posted to the wrong forum. Is that the case? I tried to access the article you referenced (http://www.sqlservercentral.com/articles/Best+Practices/61537/ ), but I...