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!

Search results for query: *

  • Users: rajpree
  • Content: Threads
  • Order by date
  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

    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...
  7. 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...
  8. 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...
  9. rajpree

    Crosstab Column Format Issue

    Can some help with Crosstab! I have following problem. My CrossTab: Port Test 11/30/2004 10/29/2004 2/28/2005 1/31/2005 ABC 10 20 30 40 Diversity score 20 30 40 60 Problems: 1. how can I use can Grow funtion becuase I have...
  10. rajpree

    CrossTab - Problem

    Hello, I am trying to create CrossTab. And we got following requirements from the business. This is my cross tab should look like: Port_desc Result 1/31/2005 12/31/2004 11/30/2004 Test1 Pass 100% 20% 30% Test2 Fail 87% 30% 60% But my table is designed like this...

Part and Inventory Search

Back
Top