Thanks Marks,

1: Any other possibility without CTE?

2: What if maximum date GAP required in each year? so that year will be a sort of group key and within each group...

here i am talking about user sessions and more specially sessions from SSMS, which people forgot to close and those remains there until they either close their SSMS OR restart...

Simple and quick.

Thanks Paul.

SELECT TOP 1 WITH TIES

SBBACLOAN

,[SBNAME1]

,[SBBRSSN]

,[SBNAME2]

,[SBCOBRSSN]

,APPRVLDTE

FROM [WarehouseStaging].[dbo].[AS400_ALSSLBACOUTP0] (nolock)

WHERE APPRVLDTE is not null and APPRVLDTE <> '0001-01-01'

ORDER BY row_number() over(partition by

SBBACLOAN

,[SBNAME1]

,[SBBRSSN]

order by APPRVLDTE desc)

I would say, simply add "USE master" on top of your code in the job and it must work, provided your db options are correct as mentioned above.

if this is...

Do you need script OR diagram?

Thanks GSquared and drew,

By checking the #temp table using RIGHT(), i can see the actual prepared string is complete, however, SSMS is not showing that entirely.

One more thing to note,...

I am trying the following

select 'EXEC sp_executesql @p1='+cast(xml_col as varchar(max)) OR convert(nvarchar(max), xml_col)

from xml_table

varchar, nvarchar are giving the same effect. Also tried cast and convert and of no use.

Getting the...

Hi Jeff,

Yes 8192 is the limit.

I want to read very long xmls from a table and concatenate in with a string to make dynamic SQL and later execute that.

Now is...

NO. varchar(max) and Nvarchar(max) are giving the same results.

if XML allow 2GB data then why its stopping at some specific number of characters.

This must be some limitation in settings.

Does someone...

Thanks Jeffrey,

So ISO standard is the strongest reason of choosing this format i.e. "YYYYMMDD HHMMSS" which is widely adopted by most DBAs/Developers and easily understandable in most of DBMS including...

OK will we get any advantage in query performance if we write condition in select like this 2011-09-23 11:12:13

OR

can be any dis-advantage if we write like 23/sep/2011 111213?

"YYYY-MM-DD HH:MM:SS "...

Sorry if my question was not clear, as it was not about datatype date, time, datetime etc. However, question was about storage and retrieval of datetime values and which format...

Thanks Revenant,

But i want SSRS feature comparison by Version, if someone has seen somewhere.

Thanks.

Nice question. Thanks.