Viewing 9 posts - 1 through 9 (of 9 total)
Msg 402, Level 16, State 1, Line 11
The data types text and varchar are incompatible in the greater than operator.
I am getting above error when i am trying below Query.
SELECT...
August 29, 2024 at 5:05 pm
I want resolution for above Question, Need to replace datalength and query should not return data ,
that is the expectation Please share me the alternative Query
August 29, 2024 at 4:27 pm
Case statements in Group by Clause taking more CPU, Could you Please let us know how can we optimize above Query.
GROUP BY selected_sfs.sfName
-- ,service_form_id
-- ,open_date
-- ,opened
-- ,hnjh_generated_sfs
-- ,closed_date
-- ,closed
,c.agingDays
,documents.document_id
,selected_sfs.contactor
,selected_sfs.lob
,doc_event_orig_actor.creator_full_name
,selected_sfs.originator_full_name
,qic.queue_name
,qic.work_item_status
-- ,ag2_document_uid
--...
July 9, 2024 at 1:40 pm
I am looking for With out Union all how to achieve same Query o/p. Any helps highly Appreciated.
June 20, 2024 at 2:27 pm
Input is Varchar(max) String column in Table.
I Need to replace all Special character in the input column with "".
(input, "\{\*?\\[^{}]+}|[{}]|\\\n?[A-Za-z]+\n?(?:-?\d+)?[ ]?", "")
October 16, 2023 at 3:29 pm
Hi In My Case as well Query is running in 1 Min, But TimeProcessing to taking 48 Min,
Could you Please let us know how to Reduce TimeProcessing,
In My Report I...
October 12, 2023 at 8:18 pm
Thanks for the Response!
I will implement your suggestions.
after Upgradation we got above error (PREV Post) is below solutions will help us to resolve error.
Please Guide me on this.
If...
October 1, 2023 at 4:02 pm
Thanks for the replay.
I have one more issue.
I want to insert new style in that html.
can you guys please guide me on the same.
March 6, 2014 at 6:26 am
Viewing 9 posts - 1 through 9 (of 9 total)