Awesome thanks

Perfect thanks.

And now I have that sorted I realise there is a fundamental flaw in my logic.

What I'm trying to do here is get the years/months returned as 3.3 for...

• This reply was modified 3 years, 8 months ago by  Jay@Work.

ok it is solved and posted here for any interest.

Seems it comes down to my inexperience with cursors. I'd normally avoid them due to the bad press but at times...

I have a count variable incrementing and printing out. I have a log for every catch and every try. Nothing is unexpected except the number of items (rows) created in...

I'm not seeing errors and have logging action in all the catch and try blocks but only errors that occur at the top level are being logged.

I'm guessing that those...

Thanks but my OP was asking abut the debugging feature in VS and if anyone had run into the same errors

Thanks I have 20+ years experience. The individual bits run fine.

I have 67 rows go into a cursor (yeah yeah I know) and it only creates 31 rows. Everytime!

The stored...

With VS running as admin and with your credentials passed with the connection string it does it no problem (at least should).

Profiler won't help me as the SP runs fine...

Perfect thanks anthony.green and anand929

Apologies for the delay in replying... priorities shifted!

ok so now I can go down the preferred route. I have contacted the vendors whose DBs live on the sql server and...

This works prefectly thanks!

declare @ram_id varchar(50),
@tsql nvarchar(1000)
set @tsql = 'select @ram_id = service_ref from OPENQUERY([remoteserver],''select Service_Ref from [remotedb].[dbo].[Service_Request] where service_request_number = ''''2'''''')'
--PRINT @tsql;
	
exec sp_executesql @tsql, N'@ram_id varchar(50)...

Almost there but....

This is the result of PRINT @tsql followed by the error

select @id = service_ref from OPENQUERY([remoteserver],'select Service_Ref from [remotedb].[dbo].[Service_Request] where service_request_number = '2'')

Msg 102, Level 15, State 1,...

Re: MessageBox.

Great tip, thankyou! I was debugging purely to see the value of a variable for each loop. I had no idea the IDE could present message boxes. It was...

Long story short... values come from a SQL task and are passed to a for each container as an ADO resultset.

Seems the paths are working after all and it was...

Sorry, ignore that. Despite me not doing anything it has decided it does not want to error anymore, doesn't need me to include any additional DLLs and is quite happy...