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 rajpree

  1. rajpree

    SQL 2005 Upgrade changes to IIS server.

    We are doing SQL 2005 upgrade , is there any drivers we need to install on IIS server due to upgrade? I was looking for Microsoft Document but I am not able to find any document. Any help? Thanks, Raj.
  2. rajpree

    using Not Exists in dynamic sql server

    I not sure why I am getting error with following dynamic sql : IF @unique_identifier = 1 AND (EXISTS(SELECT * FROM table1 WHERE field_value = @field_value AND field_id = @field_id) OR EXISTS (SELECT * FROM table2 WHERE field_value = @field_value AND...
  3. rajpree

    use literal string with NOT EXISTS

    Hi, I want to use literal string with NOT EXISTS for example: SET @select = 'SELECT TOP 1 * FROM ' + @table + ' WHERE issue_id =' +convert(varchar(10),@field_id) In @select I am constructing sql string and I want to use in NOT EXISTS(exec(@select)) but it is giving problem, any advise...
  4. rajpree

    Y axis scale change in Crystal Charts.

    Hi, I am working with charts in crystal XI. I need to define Y axis scale minimum value 2000 and maximum value leave blank and have data decide the maximum value. How can I approach this problem? Does any one have any solution...? thanks..
  5. rajpree

    presenting columns as rows in sql server

    I have data in columns ,need to present column data in rows. I am usin SQL2000. So I can't user Pivot tables. Following is the table structure. ID amount type amount_written 1 1000 A 500 2 5000 B 200 I need to present data following way: 1 A 1000 W 500 2 B...
  6. rajpree

    Repeat image on multiple pages

    Page header is not repeating in all pages. I created formula "Fake Page Header" added WhileReadingRecords; " " in the formula. Created group using Fake Page Header formula and placed all headers in the "Fake Page Group header" section, now headers are repeating in all pages but end of the page...
  7. rajpree

    Dynamic creation of Temp table

    Hi, I want create temp table on the fly but I am having following problem. Please advise if any one has an new ideas. following sql is working fine, I want to explan want I am looking for: begin create table #temp1 (issue_id int, issue_name varchar(50), pass_thru_filter int, ps_issue_id int...
  8. rajpree

    Coditional Formating lines.

    LB, Thanks a lot. it works fine with extra changes.
  9. rajpree

    Coditional Formating lines.

    Sorry some reason it did not show lines in between data. I did copy and past from word. Basically I want to get lines after AAB 8000 record and After AAB 6000 record. Conditional Formatting lines. I am using Crystal 9. I want to show line for every 4 records, which I am able to get using...
  10. rajpree

    Coditional Formating lines.

    Conditional Formatting lines. I am using Crystal 9. I want to show line for every 4 records, which I am able to get using this formula “recordnumber mod 4 > 0” but also I want show lines based on the Sec_type too. I have order by sec_type This is my data: Sec_Type amount AAB 1000 AAB...
  11. rajpree

    String or binary data would be truncated. Never seen this problem.

    Yes, I am sure one more interesting point is same insert statement one of my co worker is running and she is able to run without any errors.
  12. rajpree

    String or binary data would be truncated. Never seen this problem.

    Sorry for that : I mean rename table. My table: test (t1 char(4), t2 char(4) ) Insert statement: insert into test (t1, t2) values ('RR','BB')
  13. rajpree

    String or binary data would be truncated. Never seen this problem.

    I using SQL Query Analyzer and this is SQL Server 2000. Hopes this helps.
  14. rajpree

    String or binary data would be truncated. Never seen this problem.

    I am getting following error. I under stand this error message. But in my case I am not able identify the problem. String or binary data would be truncated. The statement has been terminated. My table: test (t1 char(4), t2 char(4) ) Insert statement: insert into rpt_rating_distribution_map...
  15. rajpree

    CrossTab - Problem

    Hi Peter, Yes, absolutely correct my data looks exactly as you described. Only r_date & result_val columns I can use in crosstab, but how I can I implement port_desc & result column as well in Cross tab? Hope I gave you enough info.
See more

Part and Inventory Search

Back
Top