Search results

I was confused about the permissions and the roles i had to apply for the users i wanted to be able to execute a job.Finally i made a group on server and i added the jobs' users. I applied the roles and the permissions for that group and everything looks fine... Thank you for your post.

Hi all, How can different users, execute SSIS packages to SQL 2008 through MS Access; This is what I’ve done so far. I am asking for rour advice in case it can be done in a some other (better) way… 1.In MSDB database for the user I want, I have apply the roles: SQLAgentOperatorRole...

Banana, i will study your suggestions and i 'll be back..

Yes I have and it returns about 100000 rows really fast..

I post the function in case you notice something... Public Function UpdateSAPConfirmedQuants(xTable) Static M As Recordset, UpdateSAPConfirmedQuants_SQL Static Ret As Variant, z As Long, TotalRecs, xText Static curKG, curST, curWCtxt, preKG, preST, preWCtxt Static x, i, itxt...

ok banana.. i'll do it tomorrow when i get back to my office.. thanks again for your help..

thank's for your reply, when i say a) DAO-JET connection i am referring to a backend ms access database b) DAO-ODBC connection to a backend ms sql 2005 database now, in my front end database there is a command button that executes a ms-access function. In this function i make a select...

Hi all, I have imported my back-end Ms Access database to SQL Server. I noticed that when executing some actions through DAO-ODBC Connection, in some cases, is much slower than when was executing through DAO-JET Connection. Is this really can be happening or am I missing something..? At this...

I 've just read that a stored procedure cannot be executed from SQL Function, so i have to think of something else.. Thank you

Hi all, I am looking for info over web but I can't find anything related.. So I post my question here.. Can a stored procedure be called from an SQL Function and how..? Thank you

I am back again..:o Unfortunately the exec command can't be executed into a function. All i want to do is to convert an ms access function to sql function. I will post the MsAccess function so any advice is welcomed. The area marked with red color is the area that i am trying to convert but i...

Yes that is what i mean... Cause of my bad english, someone must be a diviner to see what i want to do... Thank you

Hi all, I want to define the collumns name from a variable. The code bellow returns me ‘KG’ but I want the value for the field ‘KG’. Can someone please help me..? thank you declare @unit_a nvarchar(3) set @unit_a='KG' SELECT @unit_a FROM table

Hi, I need to debug row to row a Sql-Query that calls a function and I don’t know how. I know that with Visual studio and with the step into function command I can execute the function giving the params I want but I wonder who can I debug row to row a function when it is called from a SQL...

It was stupid of me.. I had to declare as char(2)...:) Evrything is fine.. Sorry...

Can someone help me with this expression? I want the result to be 'cb' but it returns just 'c'. Declare @corb char set @corb='c'+'b' select @corb Thank you.

Hi all, I have a SQL view with the below statement.. SELECT * FROM PERF_Performance AS Perf OUTER Apply dbo.perf_calc(Perf.WCID, Perf.Material_Group, Perf.MRP_Controller, Perf.Description, Perf.Component_Flag, Perf. D, Perf.Length, Perf.Operators...

It finally worked... SELECT Perf.ID,Perf.WCID,Perf.Material_Group,Perf.MRP_Controller,Perf.Description,Perf.Component_Flag, Perf.D,Perf.Length,calc.Type,calc.Vtakinmin FROM PERF_Performance as Perf Outer Apply dbo.perf_calc(Perf.ID,Perf.WCID,Perf.Material_Group,Perf.MRP_Controller...

Can someone pls help me..? When i exec the statement SELECT Perf.ID,Perf.WCID,Perf.Material_Group,Perf.MRP_Controller,Perf.Description,Perf.Component_Flag, Perf.D,Perf.Length,calc.type FROM PERF_Performance Perf Left Outer Join dbo.perf_calc(108146,'10000679','ΕΤ3022','740', 'Cut m...

I have also try this SELECT ID,WCID, Material_Group, MRP_Controller, Description,(select * from dbo.perf_test(WCID,Material_Group,MRP_Controller,Description)) FROM PERF_Performance The problem I deal is that is working nicely for only one returned column from the function but the returned...