Viewing 15 posts - 4,216 through 4,230 (of 6,397 total)
Went to a different Makro this weekend and they had the three main Innis & Gunn's by the case load, so I picked up an original and a blonde, left...
July 23, 2012 at 3:24 am
Run SSCM on both nodes and change the port in the TCP/IP properties of the service.
A quick google shall tell you the steps http://support.microsoft.com/kb/823938
July 23, 2012 at 3:20 am
What do you want to acheive here?
If you have Enterprise Edition you can use a scale out deployment setup and create a host record in DNS for a particular URL...
July 23, 2012 at 2:34 am
What does the job do? Is it firing any triggers which could be sending mail as part of the job step or the remote job step?
July 23, 2012 at 2:24 am
Clicking "hide in tile view" does just that, it only hides them in the tile view, if the users click "details view" they will see everything which they can see.
They...
July 23, 2012 at 1:02 am
Wrap it up inside a sub select like follows
SELECT
SUM(count),
no_of_months_first_redeem
from
(
select count(*) as count, datediff(month,con_date, first_redeem) as no_of_months_first_redeem
from klr_table
where con_date>= '2007-04-01'
group by datediff(month,con_date, first_redeem)
union all
select count(*) as count , datediff(month,convert(datetime, '2007-04-01',...
July 20, 2012 at 7:02 am
Good spot Phil. I shall ammend.
July 20, 2012 at 5:49 am
Number of options depending on what edition of SQL you have depends what you can do.
CDC (Change data capture)
HashBytes on a MD5 hash, if source & target hash dont match...
July 20, 2012 at 5:35 am
Best asking that on a sharepoint forum not a SQL forum I think.
July 20, 2012 at 5:22 am
I'm out too.
Asked for that information a number of times on the different posts, even took the time on one post to actually create the consumable DDL and data so...
July 20, 2012 at 5:20 am
But we need something to work on and without the base data and what the base data should look like after the logic is applied we cannot do the work.
So...
July 20, 2012 at 4:49 am
This data
accountno transaction amount date
==========================================
A-123 Cr 4500 13-jan-08
E-23455 Cr 8000 13-hjuly-09 ===>actaul table
R-747 Dr 8900 02-apr-12
L-64646 Dr 9300 06-apr-12
Does not equal this data
a1223 chenn 5677 000 -950000(entire sum of 2008...
July 20, 2012 at 4:34 am
Table definition and sample data which fits your expected outcome?
July 20, 2012 at 4:26 am
How do you know its the same project as for as that data set is concerned everyone could be a different project or the same project
But based on the sample...
July 20, 2012 at 4:23 am
Viewing 15 posts - 4,216 through 4,230 (of 6,397 total)