Thanks for your reply. I was missing the charactor N before the uniocde string assignment which yielded results in ???. My assignement statement s...
Hello, While executing the below T-SQL code, it yields not results [the search word is a unicode text]. After exploring i realized that the Unicode...
Hello, Thanks for your reply. I am looking for the continuity of days grouped by quantity. If there are 15 date continues and if the quantity is...
Thanks for your reply. It gives me the results grouped by weeks. But it breaks when i have one gap on the same week.DECLARE @tab TABLE ( dt...
Thanks for both of your reply. May be the question was confusing, but if expected result should be in two rows like this. Row 1: 1/jan/2008 -...
Hello, Can anyone please tell me how can i group date ranges? I have a table named T1 with the following values DATE QTY 1/jan/2008 25...
Separate names with a comma.
