Programming SQL

Insert missing records
I have a process that gets customer activity based upon a shipdate. I get the 3 previous months worth on data. I use the first month extract as a driver to the other 2 previous months. The problem I have is I need a record for each month and each type no matter if they had activity in a particular month or not.... 19 Jul 2008 20:09

deletion cause transacation log to grow
SQL Express 2005 I delete the 31st day of data from my customers Production data to keep the database at a manageble size. I run the query below. Delete From ProductionData Where ProdWorkDate < '6/19/2008' I noticed that he transactioni log was growing out of control. I did not think it was coming... 21 Jul 2008 20:17

Inject numbers frmo 1-etc for a column
I'm trying to do this in SQL 2005. I have a table with no unique identifier and I need to add this now. Say I have Table1 and I created a column called ColA. There are already 7000+ records in this table and I want to inject a number value in ColA from 1-what ever. I'm guessing this is going to be an update... 21 Jul 2008 16:10

There is insufficient system memory to run this query - system.web
Hi, I have a big troupble with one MS SQL server. There is 4GB RAM and using is about 2GB RAM. I need registr .NET assembly system.web bec I need use httputilizie to encode some special chars (e.g. space to ). But when I try to registr assembly, I have this error : There is insufficient system memory to run... 19 Jul 2008 14:00

Best way to send a result query via e-mail?
Hi all What is the best way in order to send an SQL query via e-mail? What can I do in sql server side? or programatically? (VB or C#) Thanks in advanced. dj... 22 Jul 2008 02:26

Your win 10,000$ in my groups Pls register your name and address in below of the website http://www.geocities.com/cathrina39
Your win 10,000$ in my groups Pls register your name and address in below of the website http://www.geocities.com/cathrina39 ... 19 Jul 2008 02:46

SNL Sql
For those that aren't familiar with SNL it's 'Saturday Nite Live'. It's a tv show that parodies celebrities, politicans, social behavior etc. It's humor with a stinger, it's supposed to make you laugh at that which is just too silly to be taken seriously:) The smiley's say it all. select 0/0 -- :( select 1 ... 21 Jul 2008 12:02

Multiple queries with one connection
Here is my SQL query in my Classic ASP page. Once I get my recordset, I want to loop thru it. I have that working. But once I grab the first row, I need to start another sql query grabbing data from another table based on the result from row 1. I just need to know how to OPEN the second recordset with the same conn... 19 Jul 2008 17:05

Does anybody know of any good books on ASP.NET Membership and the Login controls?
Does anybody know of any good books that are specifically on ASP.NET Membership and the Login controls? Thanks. -- Nathan Sokalski njsokalski(a)hotmail.com http://www.nathansokalski.com/ ... 21 Jul 2008 13:04

Procedure with date range and optional parameters, what's most efficient?
A much more complex version of this stored procedure has been working ok for me but I'm not sure it's well formed. In particular, the date range poses an issue when a study date range starts getting larger. Most of the time the range requested is today through 7 days ago. Sometimes the range is expanded to ca... 22 Jul 2008 23:59