Archive | SQL

ASP.NET Machine Generated Code

I just started working with a new client in Port Charlotte. They have had a website built by a company in Tampa and how now parted company with that company, so to speak. So I pick up this system and start to go through the coding and it’s build etc, trying to get up to […]

Continue Reading 0

The Joys Of XML

I’m currently working on a project that requires posting and reading response online using XML. I’m not talking about web services here, it’s a plain old POST of an XML file, response is returned as copious amounts of XML, read that and build a web form based on the contents (yawn), have website user make […]

Continue Reading 0

SQL Server NOT IN Clause

I’m currently working on a project where we are importing data transactions on a daily basis and need to compare the imported file with the current file. One of my favorite SQL clauses is the NOT IN clause, which I have used many times to do comparison type queries. Quite often, this powerful clause will […]

Continue Reading 0

SQL Reporting Web Services

I’ve had to use the SQL Server Reporting Services Web Services for a number of projects recently. Just to recap, if you don’t want to or can’t use the url based report access feature, you can render reports using a call to the reportService web service. Here’s the code that will do that for you; […]

Continue Reading 0

SQL Server Reporting Services

I’m looking at a new project for an existing client that will incorporate SQL Server Reporting Services. I did a project some time ago for another client using reporting services and its a very cool product. About time we had a decent tool for deploying reports over the web from Microsoft. Anyway, I’m converting about […]

Continue Reading 1

SQL Server 2000 – TSQL

I posted a while ago about a client of mine that has a custom built system with SQL Server 2000 on the back-end. Well, I was working on it today and thought I might post a little TSQL code here for your viewing pleasure… CREATE PROC stpDropDownEmployees_MGR (@FirstRowText nvarchar(50) = ‘—ALL ACCOUNTS—‘ ) AS SELECT […]

Continue Reading 0

SQL Server 2000

I’ve been working as a professional developer since 1991 (yikes!). I started out developing databases using Microsoft Access 1.1 and quickly moved to SQL Server on the backend. One of the cool things about SQL Server is the power of Transact SQL. I’m a Visual Basic programmer and don’t profess to be an expert in […]

Continue Reading 0

ASP.NET & SQL Server 2000 – New Client

One of my newest clients is a debt collection agency and they have developed an intranet system for managing their business. I have just taken over the day-to-day management of the system, providing code updates & modifications. This is one of those scenarios where you kind of hope that you will be able to get […]

Continue Reading 0