Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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.

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')

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

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

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.

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

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

Hello, I am trying to create CrossTab. And we got following requirements from the business. I have problem using first two columns in the cross tab. 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%...