Author: SSWUG Research

Community

Selective Joining of Tables

by Navin Kumar – Assume there are three tables of interest: T1, T2 and T3. Depending on the value of a local variable VAR, you want to join two tables out of the three. The requirement is: If value of VAR is ‘X’ then join T1 and T2; otherwise, join T1 and T3. The value of VAR is determined at […]

Community

Dynamic time sequence query

By Dusan Djuric – Suppose you need to see a full (10 minutes, half-hour, one hour, etc) time map for a given date with user_objects changes counter. And you need to do this in one SELECT statement, with no additional tables, views, packages, procedures, or functions. Is it possible? Yes, it is! Here

Community

SQL Server CE 1.1 SP1 Updated

Microsoft has updated Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) version 1.1 Service Pack 1 (SP1) to include support for Windows CE .NET devices. SQL Server CE 1.0 users must upgrade to SQL Server CE 1.1 before applying this service pack. Read SQL Server CE 1.1 SP1 Readme.txt Addi

Community

Converting Access Data into XML

The following applications can help you convert Access data into XML format: Access 2002, ADO 2.5, and SQLXML. Access 2002 (part of Microsoft Office XP) enables you to query or save a table in XML format. You might be able to automate this process. ADO 2.5 and later enables you to open the data into