Viewing 15 posts - 481 through 495 (of 1,079 total)
on the package property's, set ON FAILURE report SUCCESS..
see attachment.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 2:02 am
GilaMonster (12/20/2011)
Dev (12/20/2011)
Henrico Bekker (12/20/2011)
some help here....what am i missing from his side?http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
Change compatibility level of your database to make your code bulletproof.
ALTER DATABASE Testing SET COMPATIBILITY_LEVEL =...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 1:55 am
Koen Verbeeck (12/20/2011)
Henrico Bekker (12/20/2011)
I am not a very fast reader as it would take too long to read a book.
Absolutely zero and no offence to Koen, but...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 1:52 am
I only inserted a few of his records, not all, so the value of COUNT is irrelevant here.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 1:49 am
Lynn, he wants the datetime displayed as DATE only...
read my previous posts...which doesnt seem to work on his installation..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 1:45 am
some help here....what am i missing from his side?
http://www.sqlservercentral.com/Forums/Topic1224192-1292-1.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 1:18 am
I am not a very fast reader as it would take too long to read a book.
Absolutely zero and no offence to Koen, but being able to read...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 1:12 am
ok replace then:
select (left(convert(varchar, VISIT_DATE, 120),10)) AS 'date', count(VISIT_DATE) as count
from XXOH_AMT
GROUP BY Visit_Date
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 1:09 am
are you casting your datetime format to date?
I run 2008 R2 and results:
date count
...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 1:01 am
Dev (12/20/2011)
Considering last three post, I would like to correct my initial suggestion. Please hire a technology independent consultant (like me). SSC is biased for SQL Server. 😀
what...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 12:59 am
somewhat incomplete, just painting the background here...
INSERT INTO XXOH_AMT ( VISIT_DATE, PATIENT_ID,Amount ) VALUES
('07/01/2011 12:00:00 AM','2275', '20') ,
('07/01/2011 12:00:00 AM','2275', '30') ,
('07/01/2011 12:00:00 AM','2275', '40') ,
('07/01/2011 12:00:00 AM','2298', '40')...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 12:44 am
Have to agree with Dev, get a multi skilled, experienced Consultant to advise on your companies needs.
There is never a "yes" or "no" answer upfront, they have to evaluate and...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 20, 2011 at 12:32 am
Good one, thanks
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 19, 2011 at 9:47 pm
anthony.green (12/15/2011)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 15, 2011 at 4:10 am
frankcastle509 (12/15/2011)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 15, 2011 at 4:06 am
Viewing 15 posts - 481 through 495 (of 1,079 total)