Viewing 15 posts - 46 through 60 (of 77 total)
uts.VTBFHAPO where RFHA=62 and BUKRS = 'US01'
error -Conversion failed when converting the varchar value 'ABAS 200' to data type int.
Please suggest
PLease share the data type info of the RFHA and...
September 1, 2011 at 1:01 am
Bhuvnesh (11/12/2008)
Below is the linked server query ,here i m passing the server and linked server name dynamically
The problem is that its giving error for very last line...
August 30, 2011 at 2:27 am
There is small chnage in the script :hehe:
select pr.prodduct_id,pr.product_name from Product pr join
( select producti_id,(select count(1) as [States Count] from Restriction where product_id=p.Product_id group by product_id ) from Product...
August 19, 2011 at 12:43 am
ashok.faridabad1984 (8/18/2011)
However solution is:-
select pr.prodduct_id,pr.product_name from Product pr join
( select producti_id,(select count(1) as [States Count] from Restriction where product_id=p.Product_id group by state_id )...
August 19, 2011 at 12:41 am
It seems a home work question :
However solution is:-
select pr.prodduct_id,pr.product_name from Product pr join
( select producti_id,(select count(1) as [States Count] from Restriction where product_id=p.Product_id group by state_id ) from...
August 18, 2011 at 11:27 pm
John Mitchell-245523 (8/11/2011)
s_osborne2 (8/11/2011)
Hi,Check this:
http://msdn.microsoft.com/en-us/library/ms186757.aspx
That'll probably do the trick for you.
Thanks,
Simon
What Ashok's asking is how to start the second job only on successful completion of the first. sp_start_job will...
August 12, 2011 at 1:02 am
Great ! your response is quite satisfactory. Thank You very much. My confusion was I created a user group on the local system and then added domain users in that...
August 2, 2011 at 7:14 am
I want to use above expression to the parameter of the store proc. WIll anyone help that would be great.
YOu can define a local variable inside the proc...
August 2, 2011 at 2:12 am
add the add group to the db_reader role across all the servers.
I find it the easiest way to do that.
Hi Can you please let us know how to add...
August 2, 2011 at 1:32 am
As per my understanding , You want to pass a variable to DFT and iterate DFT on the basis of that variable if i am right
you can define a...
July 4, 2011 at 2:44 am
Coolroof (7/3/2011)
Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated,...
July 3, 2011 at 11:07 pm
Wildcat (7/1/2011)
patla4u (7/1/2011)
1. Put a ForEach Loop Container
2. Put a File Systeam Task in the ForEach container.
3. Choose "Move file" as the operation in File System Task.
4. DONE
Can Any One...
July 3, 2011 at 10:59 pm
:-D, This is joke of the Day, We should also have a regular post of this kind....
This doest not match anywhere what is the exact requirement.
June 30, 2011 at 9:28 pm
Viewing 15 posts - 46 through 60 (of 77 total)