Viewing 15 posts - 226 through 240 (of 402 total)
so please spare me the 'Post your SQL' spankings
Not a good way to ask for help or advice!! 😉
Just my two cents but I really don't like nesting views in...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 28, 2012 at 7:58 am
You can use these in your WHERE clause to change what is returned:
SELECT
DAY(DATEADD(dd,1,GETDATE())) --Tomorrow
SELECT
CAST(DATEADD(DAY , 7-DATEPART(WEEKDAY,GETDATE()),GETDATE()) AS DATE) --Last Day of the Week
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
May 28, 2012 at 7:48 am
so if time is now 12:31, you want to see ID 2 and 4?
So based on your data above what would you like to be returned as Anthony asked?
Are you...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 28, 2012 at 7:34 am
If you just want to show records that are due use GETDATE()
SELECT *
FROM YourTable
WHERE
DueDate > GETDATE()
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
May 28, 2012 at 5:37 am
Hi
Does this help?
CREATE TABLE #SAMPLE
(
SOURCE_FILE_ID INT,
CYCLE_ID INT,
TASK_ID INT ,
TASK_STATE_DESC VARCHAR(100)
)
INSERT INTO #SAMPLE
SELECT 22,1,1,'Valid' UNION ALL
SELECT 22,1,2,'Error' UNION ALL
SELECT 22,1,3,'Error' UNION ALL
SELECT 22,1,4,'Setup Fail' UNION ALL
SELECT 22,1,5,'Setup Fail' UNION ALL
SELECT...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 28, 2012 at 5:03 am
anthony.green (5/28/2012)
Not only do I have my 70-450 exam in the morning, in the afternoon I also find out what sex...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 28, 2012 at 2:29 am
Not sure sorry as I've not used 2005
I can only suggest giving it a try and see if it produces the desired result?
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
May 24, 2012 at 2:46 am
Do you mean is SSRS?
If so yes.
In VS look at the bottom right of the screen where your column groups are displayed, click on the small down arrow to...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 24, 2012 at 2:17 am
Hi
You can do all of this using SSIS packages
This Stairway may help you
http://www.sqlservercentral.com/stairway/72494/
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
May 23, 2012 at 8:08 am
Hi
You are trying to JOIN on a table that you havent defined yet:
from GLDEFRLS
INNER JOIN accropts AC
ON AC.AccAccrOption = EM.EacAccrOption
You are joining AC.AccAccrOption on EM.EacAccrOption but 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
May 17, 2012 at 9:53 am
I may be misunderstanding but in the query designer enter:
Exec YouRStoredProcedure (@Param1, @Param2)
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
May 17, 2012 at 7:57 am
pawana.paul (5/11/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
May 11, 2012 at 9:56 am
Personally I would go with SSIS as it was created for this kind of work.
There are many advantages of using SSIS to name but a few:
- Good error handling possibilities
-...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 11, 2012 at 9:02 am
What are you trying to achieve - what results are you expecting?
Could you post some sample data?
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
May 11, 2012 at 8:54 am
I can go home now, right?
Yep off you pop then 😀
Glad to help 🙂
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
May 9, 2012 at 9:14 am
Viewing 15 posts - 226 through 240 (of 402 total)