Recent content by AmjiBhai

  1. A

    C# Skype silent connection

    Hi I want to know is there any support which I can get from experts for the following project which I foresee it's coming soon on my table.. The project requires csharp windows form based application designing It will pickup teachers Skype ID email address from a table in SqlServer It...
  2. A

    Barcoding in pharmaceutical manufacturing environment

    Can anyone of you suggest a forum related to pharmaceutical manufacturing good practice standards... I want to discuss do's & donts of barcoder operations #MysteriousDeletionOfABatchFromDatabase #barcodingPractices #PharmaceuticalManufacturing
  3. A

    Excel What does E represent in Microsoft Excel??

    When this happens to me I Select the cell then click comma button from the number format ribbon.... Then do whatever adjustment I need to do.
  4. A

    Excel Subtract text after the third space and before the fourth (from between spaces)

    Some expert from linkedin has reacted in celebration of my input...thanks
  5. A

    Excel Formula

    Please make some 300k opening balance visible
  6. A

    Excel Subtract text after the third space and before the fourth (from between spaces)

    assuming the text is in cell c6....the formula is =IF(ISERR(FIND(" ",C6,FIND(" ",C6,FIND(" ",C6,1)+1)+1)),"3rd space missing",MID(C6,FIND(" ",C6,FIND(" ",C6,1)+1)+1,(FIND(" ",C6,FIND(" ",C6,FIND(" ",C6,1)+1)+1))-FIND(" ",C6,FIND(" ",C6,1)+1)-1))
  7. 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...
  8. A

    Syntax Error while running a stored procedue

    attached please find the screen shot.
  9. 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 ['[email protected]+'].seregation.[dbo].[Products] P where convert(varchar,P.ProductID)+P.ProductName not in...
  10. 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....
  11. A

    Excel Monthly Spread sheet.

    You will need to enable the macros...
  12. 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...
  13. 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='"[email protected]+"' where isnull(ASREFSER,'')=''" exec ( @str ) Error Message as shown by SQL Server 2012 is as follows Invalid column name 'Update [dbo].[Lists] SET...
  14. 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...
Top