RE: Reporting Services Programming Guideline
I like these books: Microsoft Reporting Services in Action by Teo Lachev Hitchhiker's Guide to SQL Server 2000 Reporting Services by Blackburn/Vaughn
2005-01-25
C#
DB Design question
Hi everybody I would appreciate some help with the following design problem: The application is about documents with paragraphs. The documents are in a table, and each document consists of various paragraphs, which are also kept in a table. If a document is created using paragraphs 1, 13, 27 & 54, it is easy to […]
2005-01-25
2005-01-24
RE: Query Date Range Against Date Range
You have staff who are contracted (with date ranges) You have jobs (with date ranges) and you want see if any staff can fulfill any jobsQuestions Where is the relationship between staff and jobs? (or is that the contracted date range) How do you determine whether the member of staff is qualified to do the […]
2005-01-20
RE: DBCC dbreindex causing Database growth.
I hit a situation similar to this a ways back--tried to reindex the database, and it triggered a database autogrow that failed due to lack of space. The exact details are fuzzy just now, but basically what's going on is that, when a table is being worked over, a second copy is being made (of […]
2005-01-12
RE: Could not complete cursor operation 16958
Yup....post the code so that we can examine it.....and get rid of the cursor.If you don't know why I'm advocating the latter route....search here for 'good performance' and 'cursor'.....the 2 phrases rarely go together!99.99% of SQL actions can be done without cursors....with a (noticable)performance boost 99.99% of the time.....
2005-01-05
2 reads
RE: common Problem with case...when ?
If you can identify a particular column that will cause a negative result then simply multiply your entire formula bysign(sign(MyNegativeColumn)+1)The sign function returns-1 for negatives0 for 0+1 for positives.This means that the additional clause returns0 for negative numbers1 for any value >=0If you can't pin down the cause of the negatives then go with Frank's […]
2004-12-03
Cannot import Paradox file from the Server ???
keep getting on Error messages on my package: (running on Windows Server 2000 SP4 & MS-SQL 2000 SP3)Context:Error calling open rowset on the provider... Error Source: Microsoft OLE DB Provider for ODBC Drivers funny... but it works fine from my Workstation (XP pro SP-1)any suggestion guys ?? thx for the attention
2004-11-28
29 reads
RE: setting a variable based on query in dynamic SQL?
This and many more informations on dynamic sql you can find here:http://www.sommarskog.se/dynamic_sql.html
2004-11-25
RE: ADO doesnt connect without network
I tried to disable the firewall, but it did not work the same!
2004-11-19
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