Viewing 15 posts - 271 through 285 (of 326 total)
Also, what's the connection info in the bottom right of the query window ??
[Note : for a new query, two options are available , one is with current conn. and...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 19, 2012 at 7:35 pm
you had it opened brand new
or the specific query window was opened as connected to prod ?
when you open a query window , specific to an instance; it...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 19, 2012 at 7:30 pm
dwain.c (8/17/2012)
The OUTPUT clause is a SQL 2005 feature:
http://msdn.microsoft.com/en-us/library/ms177564(v=sql.90).aspx
thanks dwain for correcting ...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 17, 2012 at 8:46 am
check out msdn for new additions in the 2008 ;the datatypes , filegroups , new keywords (MERGE,OUTPUT etc..)
for 2005 to 2008 you are good to go , for 2000 to...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 17, 2012 at 2:11 am
I have faced a similar but not exact issue. In this the job used to fail on weekends. The job was with two different providers that works with last day...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 10, 2012 at 9:34 am
Turn on the package logging ; there you can find multiple logging points. You can check package logging on msdn.
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 10, 2012 at 9:18 am
SQLKnowItAll (8/9/2012)
-on 8/1/2012 files being imported by backend job
-on 8/2/2012-8/3/2012 user make tons of change to the data via front end
-on 8/4/2012 updated files being imported
if we reverse back to...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 10, 2012 at 7:40 am
why are you doing this ?
I mean, the +1 , and then inserting to another table...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 9, 2012 at 8:15 am
Lokesh Vij (8/8/2012)
Answer choice 1 and 3 are same....whats the difference???? :w00t:
I saw third first 🙂
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 8, 2012 at 10:13 pm
create table #address(a varchar(50),b int)
insert into #address values ('pat',1),('giyo',2)
insert into #address values ('pat',1),('giyo',2)
select * from #address
this should do the work
with cte as (
select *,row_number() over(partition by a order by...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 8, 2012 at 8:56 am
did I miss something ?
I guess i didn't get the question ...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 8, 2012 at 8:45 am
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 8, 2012 at 8:42 am
After yesterday's question , It was a feel good . 😛
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 8, 2012 at 5:37 am
rVadim (8/7/2012)[hrThen another way is to implement this as a "File Management" solution.
1. Don't discard files after loading, instead save them to a predefined archive location.
2. Create a table that...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 7, 2012 at 2:49 am
haiao2000 (8/6/2012)
but that has another issue of its own if bad feeds are received, then the rollback may need to be done immediately.Regards,
when you say bad feeds ,...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm:
August 6, 2012 at 10:55 pm
Viewing 15 posts - 271 through 285 (of 326 total)