2014-10-16 (first published: 2014-09-11)
1,186 reads
RECURSIVE
Display Complex Hierarchical Data with Server-Side Pagination
This article presents an approach to perform server-side pagination and display complex hierarchical data in Reporting Services.
2011-12-22
8,275 reads
Time Travel Needed!
Okay girls and boys I need to pull a rabbit out of the hat! We have been asked to help a team using .... 6.5 with a serious problem. Yes I said 6.5. It seems that the are using an old product that can only run against 6.5. Here is the problem. The database, according […]
2004-05-14
RE: Changing Column Names in a Store Prosedure
First in my proc each column in the table that I want to select I have named as Mx where x is either 1,2,3,4,5 - for example M6. Then created this stored procedure to move backwards from the starting column of course a slight change can make it move forward as wellCREATE procedure myselect @smonth int […]
2004-04-10
RE: Select Top w/ variable?
Hm, Jonathan, that reminds me of those quizes on TV where you have to tell your name, and if you're right, win $1,000.
2004-03-11
RE: Unicode in SQL Server
AFAIK only NCHAR, NVARCHAR and NTEXT can support unicode data. The collation is something different. You might want to read BOL Unicode data type -> Using unicode data Among other it states quote: All Unicode data uses the same Unicode code page. Collations do not control the code page used for Unicode columns, only attributes […]
2003-12-05
RE: Index Wizard and Memory
It didn't show any room for improvement? Did you try going with thurough and setting the number of statements to check up? Also you may want to make sure that the db you ran it against when it failed all those times does not have any statistics droppings.
2003-09-17
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers