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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by krotha

  1. krotha

    Passing Parameters to Dynamic SQL

    It worked. Thanks a lot for you help.
  2. krotha

    Passing Parameters to Dynamic SQL

    I am trying to pass the values from the parameters to a dynamic sql and I get syntax error.I have many parameters like this and need to build a query depends on parameters passed, any help is appreciated. CREATE PROCEDURE Test.Search ( IN P_number varchar (50)) DYNAMIC RESULT SETS 1 P1...
  3. krotha

    Visio to DB2

    I created database design in Microsoft Visio Professional 2003 and wanted to migrate entire schema into DB2, how shall I do it. Any help is appreciated.
  4. krotha

    Convert Rows into Columns

    I want to convert rows into columns. Can anyone help me writing the query. I have table like this: Trype Index Value Id A 1 19223 13758834.01 A 2 Account Type1 13758834.01 A 3 USD 13758834.01 A 4 2% 13758834.01 A 5 13758834.01 A 6 13758834.01 A 7 1000482 13758834.01 A 8 19223 13758834.01 A 1...
  5. krotha

    Load XML Files

    I have few XML files to be loaded in SQL Server 2005. Do I have to use Integrated Services to load these or do I have to write a VB code? Thanks for any help.
  6. krotha

    MS Access to DB2

    Thaks guys. DTS worked ok. Next time I will post in appropriate forum.
  7. krotha

    MS Access to DB2

    I have about 100 MSAccess tables which needs to migrate to DB2. What is the best way to do it. I migrate to SQLServer 2000 sucessfully, but my goal is DB2. Any help is appreciated.
  8. krotha

    SQL Server Goes Down

    My Sql server 2000 database goes down very frequently, when goes down I have to restart the entire server. I tried to stop and restart service, but never stops.
  9. krotha

    Convert Oracle Reports

    How to convert Oracle Reports(6i) to SQL Server Reporting Services Reports. Is there any tool available?
  10. krotha

    ntext saving problem

    I am calling stored procedure from my .net application to save a record into a table. I got following error message. Our server is Windows 2003 server and SQL Server is SP4. My stored procedure takes ntext as a input parameter and program is sending an XML string through the input parameter...
  11. krotha

    Performance of the procedure

    I have a procedure it takes long time to run this procedure alter procedure test as declare @Id int,@Type char(10),@total_created int,@total_orders_created int,@total_completed int,@log_total int,@log_aging int declare c1 cursor for select Id,Type from temp1 open c1 fetch next from c1 into...
  12. krotha

    Case Statement

    I have query like this select t.Id,case when t.type ='19' then 'A1' when t.type ='22' then 'A2' else 'A3' End Actual_Type,count(t.type) record_count from temp t group by Id,t.type Gives me results like this ID Actual_type record_count 1 'A1' 1 1 'A3' 1 But I want...
  13. krotha

    SP4 Problem

    I installed SP4 successfully one of my development server. But My application gives error while saving into the table. The error is: Table data couldn't be saved. Error in table.save. A severe error occurred on the current command. Also, I checked in the event viewer the error says: An error...
  14. krotha

    Temporary column is not sorting

    Thanks amrita418 for your responses but I still get the same results select top 5 t.field1, case when t.f2='a' then 1 else 0 end 'flag' from table t order by flag asc which gives me 1 0 2 0 3 0 4 1 5 1 select top 2 t.field1, case when t.f2='a' then 1 else 0 end 'flag' from table t order...
  15. krotha

    Temporary column is not sorting

    There was a from tablename clause, when I rewrite I forgot to add. I didn't get error. select top 5 t.field1, flag = case when f2='a' then 1 else 0 end from table t order by flag asc
See more

Part and Inventory Search

Back
Top