Search results for query: *

I have Crsyal 8.5 and recently I installed version 9. Then I learnt that version 9 will not let you save in earlier version. So, I uninstalled 9. Now I only have version 8.5 on my machine. But when I design the report from scratch I copied some titles and few other stuff from another report...

Yes I do care which row. The identity should be greater. Is there a function called "First

Yes there is an identity column which we call objid and this is unique for every row.

Ok...may by I didn't publish my question right. Here is how the table is OfficeName address x1 abcd x2 efgh x3 1234 x4 5678 x5 ijkl x5 mnop now how do I get only one address for all rows. Some offices have more than one address but all...

Hi Experts... I have a table with the following structure OfficeName Address x1 x1a1 x1 x1a2 x2 x2a1 x3 x3a1 x4 x4a1 x5 x5a1 x5 x5a2 x6 x6a1 Now you can see...

Hi Folks, How do I set up ODBC connection pool for SQL Server 7.0. Thanks

Thanks a lot.

Hi Folks, How do I get just the date portion of a field which has both date and time. thanx

A report that was designed in legal size landscape mode is displaying in letter size landscape mode when displayed through the Smart Viewers for ActiveX or HTML.

what I meant was reports designed in Legal size Landscape Mode Display as letter sizer Over the Web..

I have developed a report and when I run it and preview the data all seems well. When we run the report from a browser, the page size goes from legal to a letter size and all my columns in the report are cutting off. Can anybody tell me how I can fix this...would really appreciate your help...

Thank you very much.

I have a stored procedure which will output a list of values. How do I write that to a file. thankx

I have a text field whose length is more than 8000. I need to do some manipulation with this field but since varchar can only hold upto 8000 how do I parse this text field into chunks of varchar 8000 Please let me know if my question is not clear. Thanks sam

Thank you very much. You are a genius.. I used this and it works like a charm.. Select OccursNo= (Len(convert(varchar(8000), case_history)) - len(replace(convert(varchar(8000), case_history),'Phone Log', ''))) / len('Phone Log') from table_case where id_number = '10075'

Declare @str varchar(8000), @substr varchar(10) Set @str = (select case_history from table_case where id_number = '10075') Set @substr = 'Phone' Select OccursNo=(Len(@str)-len(replace(@str,@substr,'')))/len(@substr) This is what I tried and I am getting this error "The text, ntext, and...

Actually my string is a varchar field in a table and I need to find out how many times a word repeats itself in this string field.

Hi Folks, I need to find out how many times a string repeats within another string. For Instance, I have this string "How much wood could a woodchuck chuck if woodchuck could chuck wood" and I need to find out how many times the word wood appears within this string... Please help...