Viewing 15 posts - 106 through 120 (of 402 total)
Hi
Add another parameter something like @DisplayYesterday
then in your dataset:
IF @DisplayYesterday = 1
SELECT UserId, Class, SumInvoiceValue, SumCostPrice, Margin, Invoice_Date
FROM View_telesales
WHERE (Invoice_Date > = DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) AND Invoice_Date <=...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
September 7, 2012 at 5:17 am
Lynn Pettis (9/5/2012)
Andy Hyslop (9/5/2012)
CELKO (9/5/2012)
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
September 5, 2012 at 10:31 am
CELKO (9/5/2012)
Your DDL is not...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
September 5, 2012 at 9:47 am
No-one at all got any ideas on this? :blink:
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
September 3, 2012 at 2:11 am
Do you mean something like this:
SELECT
CASE
WHEN DATEDIFF('m', firstseen, getdate()) = 0 then 'AUG'
WHEN DATEDIFF('m', firstseen, getdate()) = 1 then 'JULY'
WHEN DATEDIFF('m', firstseen, getdate()) = 2 then 'JUN'
WHEN DATEDIFF('m', firstseen,...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 31, 2012 at 4:59 am
I don't fully understand what you mean, but I think you want something like this, more info would be good (a stab in the dark!)
SELECT Lnno FROM Temp_Check
WHERE det_trantype =...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 31, 2012 at 3:43 am
All swings and roundabouts but there is always the COALESCE function...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 30, 2012 at 2:32 am
Ahh sorry I forgot that SSRS parameter would not allow the edit.
There is one option I can think off but I don't think your going to like it (maybe someone...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 29, 2012 at 2:02 am
Probably better ways of doing, sure someone will improve on this!
WITH MED
AS
(
SELECT
*
,LEFT(obsv_cd,7) Med
FROM
#JeffTest
WHERE
obsv_cd_name <> 'Status'
AND RIGHT(obsv_cd,4) = 'Name'
)
,
STAT
AS
(
SELECT
*
,LEFT(obsv_cd,7) Med
FROM
#JeffTest
WHERE
obsv_cd_name = 'Status'
AND RIGHT(obsv_cd,6) = 'Status'
)
SELECT
M.obsv_cd
,M.dsply_val AS 'MedName'
,S.dsply_val...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 28, 2012 at 9:24 am
Hi
Do you mean something like this:
WITH MED
AS
(
SELECT
*
,LEFT(obsv_cd,7) Med
FROM
#JeffTest
WHERE
obsv_cd_name <> 'Status'
)
,
STAT
AS
(
SELECT
*
,LEFT(obsv_cd,7) Med
FROM
#JeffTest
WHERE
obsv_cd_name = 'Status'
)
SELECT
M.obsv_cd
,M.dsply_val AS 'MedName'
,S.dsply_val AS 'MedStatus'
FROM MED AS M
INNER JOIN STAT AS...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 28, 2012 at 8:50 am
If you are using a SQL statement as your dataset wrap the column(s) in an ISNULL() or a COALESCE()
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 28, 2012 at 2:33 am
Yep thats possible
Use the above and pass your first parameter (yesterday, last week ect) into your @StartDate and @EndDate param's (the ones you will use in your dataset)
Users will be...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 28, 2012 at 2:21 am
Hi
Assuming your parameters are derived from queries you can use cascading parameters.
Create your first Param for Yesterday, last week ect and pass the results from this SQL into your...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 24, 2012 at 3:44 am
May be misunderstanding as you've not given much to work with.
Do you mean you want to display the SELECT results in one string?
SELECT ServerName + ' ' + dbname ...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 23, 2012 at 8:55 am
There is no requirement to record history, basically a UPSERT/MERGE (upload record if exist, insert if it does not).
OK so in this case you actually don't need surrogate keys, since...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 22, 2012 at 3:49 pm
Viewing 15 posts - 106 through 120 (of 402 total)