Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT @StudentScore VALUES ('A',85),...
2012-06-11
35 reads
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...
2012-06-11
321 reads
http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx
2012-05-17
5 reads
http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx
2012-05-16
218 reads
If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly introduced in SQL Server 2012. You might have...
2012-05-03
83 reads
If you are tired of implementing query paging solution in old classic style than try query hints OFFSET & FETCH newly...
2012-05-03
540 reads
What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.
It is also known as Sharding.
There can be multiple federations in a database.
It is...
2012-04-25
333 reads
What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.It is also known as...
2012-04-25
838 reads
SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single...
2012-04-20
50 reads
SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to...
2012-04-19
464 reads
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
I have established a Service Broker configuration based on Eitan Blumin's excellent example. Advanced...
Comments posted to this topic are about the item Validating Password Expiration
Hello, I have a situation. I am trying to show each distinct...
Ask SSC