SQL Newbie....
In my table, I am having a field 'A' as bit field type. I am populating the data to the Table. Eventually I got to make a report for, How many times that A field's value is changing from 0 to 1. I know I can do it by cursors but its taking long time to process becoz of huge data..Is there any easy solution for this.....
In my table, I am having a field 'A' as bit field type. I am populating the data to the Table. Eventually I got to make a report for, How many times that A field's value is changing from 0 to 1. I know I can do it by cursors but its taking long time to process becoz of huge data..Is there any easy solution for this.....