Viewing 15 posts - 46 through 60 (of 402 total)
No Probs 🙂
==========================================================================================================================
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 10, 2013 at 4:44 am
prb88 (5/9/2013)
no of operations
1
2
5
7
when i need it to result like this:
Consultant name No. of operations
Dr Smith ...
==========================================================================================================================
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, 2013 at 4:47 am
Looks like you need to put your minimum part as a sub query if other columns are involved that you can't group by.
If this is what the OP is looking...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 20, 2013 at 10:18 am
if i go woth your suggestion then i need to group it by the other non aggregated columns, if i group it my results will go wrong, so i am...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 20, 2013 at 10:09 am
Sql Server will scan the table differently for the query's with and without the hints which is why you may be getting a different sort order..
The only way to guarantee...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 20, 2013 at 9:59 am
Cross Post
http://www.sqlservercentral.com/Forums/Topic1422113-391-1.aspx
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 20, 2013 at 9:08 am
Hi
Is there any reason you cant use:
SELECT
MIN(ST.BG_DTTM) 'Minim'
FROM
tablename ST
Cheers
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
February 20, 2013 at 9:06 am
Hi
Another way without the UNION
Create table #x1
(
iSchoolCode int,
iSchoolYearCode int,
dtCalendarDate datetime,
iCalendarDayId int
)
insert into #x1 values (301,2012,'2012-08-10 00:00:00.000',NULL)
insert into #x1 values (301,2012,'2012-08-11 00:00:00.000',NULL)
insert into #x1 values (301,2012,'2012-08-12 00:00:00.000',NULL)
insert into #x1 values (301,2012,'2012-08-13...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 20, 2013 at 2:41 am
Hi
i am curious when to use script task where other components in ssis can't do the job
Well there is your answer! 😉
One example would be to obtain the error message...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 19, 2013 at 4:26 am
Are you sure that having a single flat file containing mixed data would be an acceptable solution
Depends Phil, the tables may have no relationship but may contain data that does...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 18, 2013 at 9:16 am
sunder.mekala (2/18/2013)
i have requirement where i have take data from different tables of sql server db, but here the important thing is tables doesnt have any relationship among them,...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 18, 2013 at 9:04 am
Bhuvnesh (2/18/2013)
Andy Hyslop (2/15/2013)
could test your ETL's by dropping all of your indexes and re-creating and determining the impact so see which is more efficient
Does it cost intensive 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
February 18, 2013 at 3:21 am
I believe other engines implement cursors quite differently, with much better performance
In Oracle they are considered by many to be best practice..
I just detest the interface...!
Thanks for the code Paul
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
February 15, 2013 at 5:27 am
Jason-299789 (2/15/2013)
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 15, 2013 at 5:01 am
I'll probably have every DW expert in the world yell at me because it violates status quo naming
Consider this a "Yelling" Jeff 😉
That, not withstanding, the key for everyone, whether...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 13, 2013 at 8:49 am
Viewing 15 posts - 46 through 60 (of 402 total)