this may help...

http://www.sqlservercentral.com/Forums/Topic199758-8-1.aspx#bm199774

SELECT LTRIM(employeeid) AS employeeID, employeename

FROM dbo.[Table]

WHERE (LTRIM(employeeid) '')

will...

Where are these logs coming from?

Is there any way that you or the developer can "improve" the log files by including a delimiter?

Building on Matt's earlier example I can overcome...

Here is an informative article on ROW_NUMBER()

http://www.sqlservercentral.com/articles/T-SQL/66512/

jbarker4682 (8/12/2009)

I'm...

now many columns and rows are in the tables you wish to compare?

Hi...

I have a similar scenario...whereby I import from Progress 9.1E (our production system) into SQL (our reporting system)... I use the MAX(IDNO) from the SQL table as the variable in...

hmmm...

http://codingforums.com/showthread.php?p=849545

“Caveat Emptor”

I am sure that there are many people in this forum who have, without question, accepted advice from the printed page, an article on the web or that...

Hi you have posted this in the SS2K5 forum but you have a TIME datatype...I dont think this was introduced until SQL 2008...

If I run this on 2K5 I get...

You have another active thread here:

http://www.sqlservercentral.com/Forums/Topic768074-148-1.aspx

is this referring to the same process you are trying to develop in this thread?

roundel1900 (8/11/2009)

I don't...

can we see the new code ?

In Control Flow create an "Execute SQL Task" ...In the task editor set the SQL Statement to TRUNCATE TABLE "yourtable"

run this before your dataflow task

SELECT col1, col2, col3, col4, col5

FROM datatable AS tt

...