I think the OP would need to include 'No Rebate in Effect' too...

This is a forum for Microsoft SQL Server not MySQL. You're more likely to get answers posting on a MySQL forum.

Regards

Lempster

...or what Gail posted! 😉

Your @count variable is only declared, never initialized or set to a value hence the null. You can use @@ROWCOUNT to return the number of rows affected by a statement,...

If you've configured a SQL Agent job to run every 10 minutes then that's exactly what it will do - run every 10 minutes. You can change the SSIS package...

If you are bcp'ing data out using a query then the syntax is as follows (assuming you want to bcp out all the data in a table):

bcp "SELECT * FROM...

I'm assuming that the grain of your Fact table is at the individual Sale level, right?

There are a number of methods you could use to cater for the attributes of...

GilaMonster (9/11/2014)

---

cafescott (9/11/2014)

---

Based on your earlier comment I'm going to research Transactional Replication as it seems the best way to copy a production DB two or three times a day...

I don't...

You can find out information about query plans from sys.dm_exec_query_stats, but if you want to find long-running queries, queries that consume a lot of CPU or queries that involve a...

I think you might be better off...

polkadot (9/5/2014)

---

Grant, thanks for feedback on second part of question. I dug around for more info and found I can find a query's plan handle and remove it with...

Are you using the default Transaction Isolation Level of READ COMMITTED or have you changed it?

Regards

Lempster

Have you tried running each child package in a separate job? That may help you pinpoint the problem.

Regards

Lempster

No, the SCD transformation in SSIS only handles Type 1 and Type 2 SCDs...but I wouldn't use it at all because it performs poorly in terms of speed. Better to...