Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sqlmann

    Want to send mail to group of people

    Hi I want to send notification mail to all the member for a particular state Ex : Table b State Member Member id Role TX Z Z@xyz.com Mgr TX a abb@xyz.com Mgr TX b bc@xyz.com S.Mgr TX c...
  2. sqlmann

    SSIS Exporting a 16 Digit Number into Excel

    Please try to export this number string value
  3. sqlmann

    Passing mutile integer value to stored procedure as string

    Thank you very much
  4. sqlmann

    Passing mutile integer value to stored procedure as string

    Hi I Want to pass multiple integer value to stored procedure. so i thought i can pass it as string value like '10,20,30' to procedure. Select * from customer where cusid in(@custlist). But it's not possile variable value in paramter. Error as --- Msg 245, Level 16, State 1, Line 3...
  5. sqlmann

    Loading Excel into Access

    Tried to load excel data into access database using access modules. Tried the follwing steps to load Step 1: OPen excel using ADODB provider _working fine without any issue Step 2 : Store the value into recordset -Like "Select * from [PDF file$](Excl sheet name) Step 3: Read each record and...
  6. sqlmann

    DEBUG PROBLEM

    I disabled the proxy setting on my internet explorer. It's working fine Tools -> Internet Options-> Connection Tabe > Disabed theproxy --- But I don't know why its giving error earlier
  7. sqlmann

    DEBUG PROBLEM

    I have developed a Web application using database project template in VS 2005. When i execute my application,login page has to be displayed. Instead of this as soon i click on debug,it is redirecting to cfauth.com and prompting for credentials. Unable to debug my application. Please,help me as...
  8. sqlmann

    <b> Error while try to execute using SQL Jobs </b>

    Thank you very much. I will try using configurations
  9. sqlmann

    <b> Error while try to execute using SQL Jobs </b>

    Created one IIS Package, which will extract data from db2 to SQL server It working fine when we excute it spearatly. Tried to create jobs shedule ran this IIS package for every 3hours. When we try to run the excute the step it thorws error as ' An OLE DB record is available. Source...
  10. sqlmann

    [b] Compare 2 siff database (DB2 and SQL server)[/b]

    Thx for quick reply In the source (DB2) has more than 100,000 records.Every day minimum 1000 new records will be added into db2. I have to extract the recods based on the ids (Id details are available in SQL sever) and more over to create link serer will not posssible (Due to security policy...
  11. sqlmann

    [b] Compare 2 siff database (DB2 and SQL server)[/b]

    I have to extract data from Db2 to SQL server. Source table Query ------------------ Select * from <db2-table> where group_id in ( Select group id from Sql server table) --------------------- How to do this using SSIS
  12. sqlmann

    calculating cumulative totals

    Can you please explan with some example ?
  13. sqlmann

    [b] Need to invrease the size of decimal [/b]

    I want change the decimal to 9.. Please tell me the below code will fix this 1. .. CREATE TABLE PRGM01_PGIDGEN_TMP like PRGM01_PGIDGEN; i. INSERT into VFW.PRGM01_PGIDGEN_TMP SELECT * FROM...
  14. sqlmann

    [b] Need to invrease the size of decimal [/b]

    Sorry i forgot tell the version v.08
  15. sqlmann

    [b] Need to invrease the size of decimal [/b]

    the below schema, the length of the column N_MAXPERIODID - Decimal (7) should be increased to 9 DROP TABLE PRGM01_PGIDGEN; CREATE TABLE PRGM01_PGIDGEN ( C_PROGRAMCODE VARCHAR(10) NOT NULL, N_MAXLOCNID DECIMAL(4) NULL, N_MAXJOBCODEID DECIMAL(3) NULL, N_MAXCCID...

Part and Inventory Search

Back
Top