Recent content by AmjiBhai

  1. A

    Syntax Error while running a stored procedue

    Yes. I dont need to update remote server....Records are being pulled from remote server and inserted into the local db.... I was lucky to resolve this issue by making the following change: Abraham ! thanks a lot for your precious time & help . BEGIN UPDATE Lists SET...
  2. A

    Syntax Error while running a stored procedue

    attached please find the screen shot.
  3. A

    Syntax Error while running a stored procedue

    I tried but unfortunately still no luck.... Strange thing is the insert command using the @server variable is working but Update/SET is failing... set @str = 'insert into Products select * from ['+@server+'].seregation.[dbo].[Products] P where convert(varchar,P.ProductID)+P.ProductName not in...
  4. A

    Excel Monthly Spread sheet.

    That means you have wrongly pasted the vba code .. Please make sure you insert a new module e. g module1 and shift the sub auto_open() to that new module....
  5. A

    Excel Monthly Spread sheet.

    You will need to enable the macros...
  6. A

    Syntax Error while running a stored procedue

    ALTER PROCEDURE [dbo].[ServerRefUpdate] @str varchar(999),@server varchar(50) AS BEGIN set @str = 'Update [dbo].[Lists] SET ASREFSER='' + @server + '' where isnull(ASREFSER,'')='+'''' exec ( @str ) Please help me resolve the following error message Msg 102, Level 15, State 1, Line 1...
  7. A

    Invalid Column Name Sql-Error :Executing a stored procedure

    I am executing a stored procedure .... the following command need to be rectified. set @str = "Update [dbo].[Lists] SET ASREFSER='"+@server+"' where isnull(ASREFSER,'')=''" exec ( @str ) Error Message as shown by SQL Server 2012 is as follows Invalid column name 'Update [dbo].[Lists] SET...
  8. A

    SQLServer 2012 Replication (using C#)

    I have three laptops (A,B,C) each having identical local DataBase (S1) My laptop is A and I connect remotely with B & C I want to replicate S1 at laptops B & C on laptop A ... I found this link http://www.nullskull.com/a/10474998/sql-server-replication-using-c.aspx... It sounds good match of...
  9. A

    Excel Monthly Spread sheet.

    Sub Auto_open() sht=format(now(),"MM-DD") sheets(sht).select End Sub
  10. A

    Run select query from VBA code where criteria comes from a multi select ListBox

    Dim SqlStr as String SqlStr="SELECT * FROM tblName WHERE fldname in (" & strwhere & ")" Dim dbcon As New ADODB.Connection Dim rst As New ADODB.Recordset constr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=ReportServer$SQLEXPRESSMASTER;Data...
  11. A

    Excel Monthly Spread sheet.

    Yes. its possible....At first, Please let me know what is your sheet naming convention....e.g 27-Nov-2019 or 11/27/19 or what?
  12. A

    JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER

    Just in case you haven't seen this earlier...
  13. A

    C# Query : Failed to populate DataTable

    You are absolutely right!
  14. A

    Excel Message box called if 1 of 3 options is entered.

    No Problem! It's my pleasure if I can be of any service to nice people like you.. Please let me have details of what this code is all about which will help bridge the communication gap... In order to understand your pdf file(the screen shot) I need clarifications what is each essential column's...
  15. A

    C# Query : Failed to populate DataTable

    Yes...I wanted to reconcile the two listings of stored procedures....The both database structures are identical. I was lucky to have backup of my old source code which was successfully picking data....Short while ago I ran that code and glad to see its still picking the data from sql server and...
Top