How you define your partition is partly if not fully influenced by business logic. If a sale has a 30 day return period then you can create each partition in...

Create the dimension tables. What if you want to know what stores generated no sales in some particular time frame?

With the ODD numbers, how is 7,5,3 related. Did you miss 7 is related to five?

thanks

So you are adding back records to the student table that you think should be there. Could it be the students table was archived somewhere else and the history table...

If your goal is just to keep the two tables in sync you could just use transactional replication from the source to the subscriber (whichever server is which). if they...

You could add a checksum column on to apply to the columns wher you think the changes may occur. This will identify your row Id's that are out of sync....

Check the default language of the login accessing the data for your report. British English and English will interpret '08-01-2013' in different ways.

Where you trying to move the data using a linked server connection? You can map the SQL logins in this way using ( I don't mean the Windows logins).

Use a bit of caution, this may affect other views and stored procedures that use this column. They may, for instance, be...

If working with a large data set, the convert function in the where clause will slow things down as compared to having a datetime column. It may be beneficial to...

In your query you are casting as decimal(18,2). Are your numbers always going to be whole numbers?

The following example

select PATINDEX('%[^0-9]%', '1234234.20')

does not return zero.

Just though I should ask.. Is wzunzip installed on your system or the server you are trying to have run your process?

Yeah, he could be implying cascading parameters. It is just not clear (beyond a reasonable doubt) from the post itself.

In SSRS 2005 I notice stored procedures in the dataset...

+1

Glad its working out, thanks.