Viewing 15 posts - 10,801 through 10,815 (of 13,872 total)
OK - do you have SSIS installed on both servers? Merely executing the command line is not sufficient.
April 10, 2012 at 9:02 am
Here's a CTE example:
with Table_A as (select 10844 x_No, 2 Rank2, 18178 sysno, 1 Rank1
union select 10844, 4, 27529, 2
union select 10845, 1, 22994, null
union select 10845, 3, 22129, null...
April 10, 2012 at 8:29 am
DBAgal (4/10/2012)
April 10, 2012 at 8:04 am
EasyBoy (4/10/2012)
preetham gowda (4/10/2012)
I did try converting Char to Varchar but getting the...
April 10, 2012 at 5:15 am
njdevils39 (4/9/2012)
By the way, I also do not work yet or get paid. I am an unpaid intern learning to advance my programming knowledge.
You're receiving high-quality, free assistance and advice...
April 9, 2012 at 12:48 pm
subha V (4/9/2012)
Im running my package using a command file.When im executing the package manually by clicking the command file,its running fine.
But when im trying to run the package via...
April 9, 2012 at 8:46 am
mdkmohan (4/8/2012)
I just need to disable sql jobs during holidays.
I found few ways for doing that but I don't know which is more efficient and generalized method.
Kindly provide your suggestion...
April 8, 2012 at 9:23 am
sivag (4/7/2012)
April 7, 2012 at 2:48 am
bharatgi (4/6/2012)
the key field is a concatenate of LocalID + DSeen + POD
Hmm, clearly not, as you have duplicates 🙂
I'm therefore guessing that this table does not have a PK,...
April 6, 2012 at 6:15 am
Google some FOR XML PATH queries and you'll crack this soon enough.
April 6, 2012 at 6:09 am
bharatgi (4/6/2012)
thanks - but how do i display both duplicate records in the same query?
Do you have a unique key on this table?
April 6, 2012 at 6:07 am
Try this:
select
[SLA]
,[PCCode]
,[PrCode]
,[LocalID]
,[DateOfBirth]
,[Number]
,[ATariff]
,[DSeen]
,[MPI]
,[Service]
,[POD]
,[Device]
,[ActivityDate]
,[SeenDate]
,[DateActivity]
,[Period]
, Count(*) [Count]
FROM [PROV].[dbo].[DA]
group by
[SLA]
,[PCCode]
,[PrCode]
,[LocalID]
,[DateOfBirth]
,[Number]
,[ATariff]
,[DSeen]
,[MPI]
,[Service]
,[POD]
,[Device]
,[ActivityDate]
,[SeenDate]
,[DateActivity]
,[Period]
having count(*) > 1
April 6, 2012 at 5:50 am
Andy Hyslop (4/6/2012)
Phil Parkin (4/6/2012)
Are you saying that it works when you run it manually but not when it is run as a scheduled job?
I got the impression that no...
April 6, 2012 at 4:16 am
So what? You're in a 2005 forum.
If I told you that my car was 'not working', would you know how to fix it?
April 6, 2012 at 3:53 am
Are you saying that it works when you run it manually but not when it is run as a scheduled job?
April 6, 2012 at 3:44 am
Viewing 15 posts - 10,801 through 10,815 (of 13,872 total)