Recent content by krotha

It worked. Thanks a lot for you help.

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...

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.

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...

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.

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

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.

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.

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

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...

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...

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...

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...

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...

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