Search results for query: *

this can be possible only by making dyanamic stored procs runtime (i.e. store the stored proc in table and make temporary stored proc run time by getting there data from tables) But this would be very time consuming process. so i would suggest to compile all 70 procs in all the four database.

i m not very much sure. but that would be for readonly session.

can you please explain more?

yes pbackstrom is correct. You can define you own sequence in mapping (in Informatica Designer) using Mapping --> Target Load option. Here you can set the sequence. While Truncate target will work only once at starting of the work flow. So dont worry about that. It will not truncate everytime.

Hi Jon You dont worry about the max() while using transaction. If you have transaction open, your application will take care about it. but only thing need to know that u must have getting max() + 1 just above the insert statement. kavin

hi jon In MS-access @@identity does not work, for that, u have to query the tables as follows: step 1 : Insert record in Title table step 2: get the max(titleID) from table step 3: insert record in Post table using that max(titleID) this all should be in a transaction. But in case of SQL, u...

Is ur T.[Date] is Date + Time field, If so then it is problem?

this kind of errors can not handle by SQL server can only be handle throgh client side using Try & Catch.

I m not sure about ur problem but can u use linked server instead of Openquery, as i have found sometimes Openquery behavior is undetermistic.

I think using EXISTS in such scenario will not be helpful but U can make the 12 + 3 to like 12AB + 3 kind as it is varchar..so can u lots of permutation combination.

As Far as my knowledge there is no such modify date upto SQL 2000.

I Hope this will solve ur problem: Do some kind of changes as u like.. I cud be done in One query but for performance wise better to use multiple with temp tables. For Generating serial number U have to use Temp tables OR Cursors, But Yukon (SQL 2005) have such fascility I suppose. Happy...

select firstn,count(*) as TotalCount from #t1 group by firstn order by firstn

select sum(total) as TotalSale,convert(varchar(20),datepart(hh,logontime)) + ' - ' + convert(varchar(2),(datepart(hh,logontime)+1)) as Hour from #TestTable group by convert(varchar(20),datepart(hh,logontime)) + ' - ' + convert(varchar(2),(datepart(hh,logontime)+1)) Regards Pavan Kumar

select sum(total) as TotalSale,convert(varchar(20),datepart(hh,logontime)) + ' - ' + convert(varchar(2),(datepart(hh,logontime)+1)) as Hour from #TestTable group by convert(varchar(20),datepart(hh,logontime)) + ' - ' + convert(varchar(2),(datepart(hh,logontime)+1))

I want to Sort for PartnerID 8867 which is child of 8804->8756-->7765. i.e. It should come for 8804 (Andre Morton ) -->8867 A-I Communications (4) Not same level entry

create table #temp1(depth int ,lft int,rgt int,partnerId int, PartnerName varchar(500),partnerID_parent int ) insert into #temp1 values(1,1,2282,7765,'VIA One Technologies (51)',7765) insert into #temp1 values(2,2,3,460,'Telecolumbia',7765) insert into #temp1 values(2,4,1029,5220,'Mobile123...

in continuation: The above query will show the records as follows: (if say I pass "Ira") Mac -->Peeter (sorted on ID) -->Harry (sorted on ID) -->Tison (sorted on ID) ---->Andrew (sorted on name) ---->David (sorted on name) ------->Hudson (sorted on name) ------->Ira (sorted on name)...

thanx for the query.. but this only upto 2nd level.. how we can solve if we need to deep levels i.e. Level 8 (lets say) also we want to maintain the Level 1 with order by "ID" and rest levels with "PartnerName

In Trees , the nodes are always arrange in left and right manner. the same is maintained here in database table. these fields represent the same left & rigtht.