Query sample

SELECT TOP 10 * FROM Sales.HOWLI_LOAD

WHERE SQL_POST_DATE BETWEEN '2011-10-15 00:00:00.000' AND '2011-10-19 00:00:00.000'

This is just the SSMS version of it. But in fact I use a query where the...

This is what you are looking for

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/extracting-numbers-with-sql-server

Hope that helps

Thanks for sharing your solution Lindsay..Cheers!! 🙂

I agree with what LutzM is saying. But at the same time, if the process of changing the numbers is not visible to anyone, you should still be ok (ok...

Now I see what you are trying to achieve. So here's the scenario (from what I understood)

Once you get the CSV, you are going to replace the column (CC# Original)...

You can create Cube partitions and partition them by months. So if you need to delete for 10-2010 then you can delete that partition. You will again need to perform...

In order for LocalA to talk to LocalB or vis-a-vis you need to add the linked servers first. Read

http://msdn.microsoft.com/en-us/library/ms190479.aspx to find out more about how you can do it. Alternatively,...

If you dont have 2008 installed on your machine, then separate out the insert/update logic. But if you have 2008, Merge is the best option.

Your approach appears to be good. Although when I think of the hassles of the substitution process then the minute intricacies start appearing. My very first questions are

1) What is...

This might sound a bit naive, but are you running both the queries in the same window/tab? If you are, then I suspect that there are no rows being pushed...

You will need an OLEDB command for sure if you are trying to update the records. If not, it will by default keep adding new records. Do you have an...

Without delving into all the details you provided, I think the solution has to be very simple.

I came across the same situation where I had to import data from...

Koolme,

As far as I can remember, SCD transformation is more of a wizard that adds certain transformations once you configure it completely. Do you have any date time columns in...

Create a DreamSpark account and download the Developer edition (which according to me comes for free through DreamSpark). Install the complete package. Should be good.

Try using the Ranking functions available. They are always a great help. I wouldnt provide the exact answer but here is a small snippet

with CTE(

your select from the base table,

RANK...