What I decided to use was a simple .net script, using SqlBulkCopy. This worked out pretty well and faster then other things I tried.

Figured out the problem. It seems as though, this error is thrown whenever there is something wrong with the insert statement or any sql statement that we are trying...

Sorry, just found that CHECKSUM is actually built into sql server. I never realized this.

Overall, how does everyone feel about using CHECKSUM over comparing each and every...

This feed is coming from one of our vendors, and they send the FULL data load on each run. We have seen in the past that data has changed...

What do you mean by an Import Wizard? Do you mean an ssis package that will run like an import wizard?

Pretty much if the row is not in the...

I tested this out using a SSIS package and it worked and did not create as much transaction logs and or tembdb did not grow as big either.

This approach just...

What kind of reports do you need? Please be more specific. What type of data are you trying to extract out?

What kind of flexibility do you need with...

And also, when I did this is the development machine, the machine was in simple recovery mode.

You can do it this way:

SELECT TOP 100 PERCENT

customer_id,

invoice_no,

invoice_date,

(select top 1 t.customer_name from p21_view_customer t where t.customer_id = p21_view_invoice_hdr.customer_id) as 'customer_name'

FROM dbo.p21_view_invoice_hdr

WHERE (invoice_no IN (SELECT MAX(invoice_no) AS last_invoice...

Jeff was correct most of the way, this way you can get all the results back:

where col1 = isnull(@variable,col1) or (@variable is null and col1 is null)

I believe that should...

So lets say, someone is running a query and I am about to rename the table...what would happen here? The query is still not finished and its a long...

http://sqlblog.com/blogs/hugo_kornelis/archive/2007/09/30/what-if-null-if-null-is-null-null-null-is-null.aspx

Thats a good site and will try to explain the answer to you.

I know thats not possible, but I don't know the reason for it.

So to get around that you can do this:

declare @name1 varchar(60), @count1 int, @server1 varchar(60), @sqlstmt varchar(1000)

select @server1...

http://blogs.msdn.com/sqlclr/archive/2005/06/29/regex.aspx

Go there.

Well the reason I want to do this is, the table is created on a daily basis dynamically, new columns can be added/some columns can be removed. This is...