Viewing 15 posts - 10,816 through 10,830 (of 13,879 total)
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
As far as I know, you cannot create a JPEG file with multiple pages.
April 2, 2012 at 1:37 pm
I'm not sure exactly what those settings affect, but worth a try 🙂
April 2, 2012 at 2:33 am
Have a look in Tools / Options / Database Tools / Table and Database Designers / Column Options in BIDS.
April 2, 2012 at 2:27 am
Lynn Pettis (3/30/2012)
Phil Parkin (3/30/2012)
Jeff Moden (3/30/2012)
March 30, 2012 at 7:27 am
Koen Verbeeck (3/30/2012)
So I would...
March 30, 2012 at 7:10 am
Viewing 15 posts - 10,816 through 10,830 (of 13,879 total)