Recent content by kavin

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))