A Covering Index should be constructed with the Most unique (meaning highest selectivity) column first, followed by next most unique, down to the least unique.

Yes Using the Convert around...

You can "stack" information on more than one row, but it makes the report harder to read.

Right click on the Detail row indicatior on the left side of the table...

declare @var1 decimal(9,5)

set @Var1= 10000

Results

Server: Msg 8115, Level 16, State 8, Line 7

Arithmetic overflow error converting numeric to data type numeric.

Your likely trying to stuff a number into another number...

Yeah, what do you mean a series of statements?

what are you trying to accomplish?

In dts on the file property there is an option "First Row has column Names" this will only skip the first row.

If you use BCP then you can specify which...

First I would go through the effort of creating a datetime column with the date and time mixed as you should. It will be much more efficient.

this is clearly a...

What is the error?

perhaps the field that is supposed to be int, contains blanks, or alpha characters.

No,

But is this a case of the printers speed is too slow, Reporting services is not transferring data quickly enough to the printer?

Once the page is rendered it is...

I have this issue some times too. In enterprise manager in the database under users the user us not shown, but when you try to add it states user exists.

Use...

Try this tutorial.

http://www.codeproject.com/dotnet/DynamicReport.asp

Or use a matrix control instead of a table control.

I agree with Aaron, you have a data modeling issue here,

this query works but it requires the records to be inserted in the correct order which is not a...

I don;t have your schema to test, but Ib elieve its this

Convert(varchar(25),(CAST (@PREV_MONTH AS VARCHAR(11)) + '-'+ CAST (@CURR_MONTH AS VARCHAR(11))))

This derived field is not a column in your dataset...

Your where clause is not correct.

you cannot have different where clauses inside a case statement.

I cannot dicifer what your trying to do but it looks the same.

To me it looks...

Sure it does In enterprise manager, Select your backup file, Then click the Options tab.

In the Restore Database Files As, change the path to your files as the new server...

To connect excel pivot table to cube.

In excel go to data, Import external data, Import data.

the you have to either create an odc, or use an existing one, an odc...