Viewing 15 posts - 271 through 285 (of 402 total)
The first step I would take is to sit down with the Business and the users and establish exactly what they want / need. This will help you establish what...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 26, 2012 at 7:51 am
Just one thing that jumped out at me:
Current architectural setup: We have a reporting database environment set up with 5-8 databases or components. This is highly normalized relational data set...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 26, 2012 at 7:08 am
Mark Fitzgerald-331224 (4/26/2012)
kishore.sqlbi (4/25/2012)
Name email ...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 26, 2012 at 3:21 am
Hi
In what way is it not working what are you trying to achieve?
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 25, 2012 at 7:25 am
Your welcome 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 25, 2012 at 6:57 am
Hi
Its very difficult to help without table structures and test data however you could try something like the following:
SELECT *
FROM
(
ProductCode
,Date
,Value
,ROW_NUMBER() OVER (PARTITION BY ProductCode ORDER BY Value DESC) AS RowNum
FROM
Product
)...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 25, 2012 at 4:56 am
opc.three (4/24/2012)
sql_ques (4/24/2012)
When I export SSRS report (2008 report server) to excel the formatting is not the same as in report server. The rows are merged and collapsed. Is there...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 25, 2012 at 2:42 am
So if I understand correctly you have a date parameter and for example if you select 01-03-2012 - 31-03-2012 the chart displays correctly however if you select 01-01-2011 - 31-12-2011...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 25, 2012 at 2:36 am
GilaMonster (4/18/2012)
ravi@sql (4/18/2012)
Nested loop-- If the left side table having less number of...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 18, 2012 at 5:16 am
Sorry I don't understand what you need, why is it wrong, what are you expecting to see?
If you can provide DDL's, sample data, expected results and a better explanation this...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 18, 2012 at 4:29 am
Hi
I would certainly split them into 2 separate Dim's.
It used to also be agreed that all date and times should be converted to join onto the relevant Dim's however if...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 17, 2012 at 5:54 am
I'll throw you a bone on the first question:
why a table can have one primerykey
Think about it a primary key ensures a row is unique...
Aside from that google...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 6, 2012 at 4:53 am
Phil Parkin (4/6/2012)
Are you saying that it works when you run it manually but not when it is run as a scheduled job?
I got the impression that no rows were...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 6, 2012 at 4:13 am
In SSMS right click on the database and script database as. You then just need to select the objects you would like to include in the generated script.
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 6, 2012 at 2:56 am
If you stick a data viewer between the OLEDB source and conversion and between conversion and destination, then you can check to see if any rows are going through the...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 6, 2012 at 2:52 am
Viewing 15 posts - 271 through 285 (of 402 total)