I have not worked with Quick books but I have seen a few third party SSIS connection objects that allows you to connect to the QB data. For example, [CozyRoc][1] [1]: http://www.cozyroc.com/ssis/quickbooks-connection...

It looks to me that the problem has to do with your date settings. The date values you have are all in M/D/Y format. However, I suspect your date settings on the SQL server instance could be different. If that is the case, you can fix the problem by ...

In most cases, converting a cursor based solution to a SET based solution will make it significantly faster. So may be it is helpful if you can briefly describe what you are trying to do so that some one on this forum can suggest an alternate way of get...

I would say that this table is not well designed. To answer your question, one way accomplish this is given below. It shows the time (in minutes) each product has taken to move from Welding to Painting. This can be enhanced to include further requiremen...

I can think of the following options. 1. Use a linked server query. It would require you to create a linked server and join tables. For example, if you have created a linked server to server2, you can access the table as server2.dbname.schema.tablena...

Sudeep has written a wonderful introduction to SSIS in the [first chapter of his SSIS Tutorial][1]. I would recommend you read that to get a basic idea of what it is. [1]: http://beyondrelational.com/modules/12/tutorials/24/tutorials/7709/gettin...

If you are on SQL Server 2008/2008, you can do this by using `ROW_NUMBER()` function to generate a sequence number and then a self join to to access the previous/next rows. In SQL Server 2012, this has become much easier with the `LEAD()` and `LAG()...

What do you mean by "add two columns to every record"? What kind of file is that? Is that an EXCEL file or some other format?...

I would not recommend doing it this way. I would suggest the following. 1. Create a stored procedure by specifying each parameters explicitly (such as `PROCEDURE DoSomething (@Name VARCHAR(10), @Age INT)` etc) 2. Have a proper INSERT statement in ...

I just noticed that the PHP tutorial has just started. Check out [this][1]. [1]: http://beyondrelational.com/modules/12/tutorials/667/tutorials/15362/getting-started-with-php-part-1-overview.aspx...