Using MS SQL Server

CHECKSUM to determine record changes
I've searched the forum for uses of CHECKSUM and havent found a satisfactory answer. I need to know when a row changes and I dont care what it was or is, I just need to know it changed. Detail: Hourly I select rows where the record as a create date or change date of the last 3 days. I am only interested when the ... 23 Apr 2008 12:31

Using findstr on SQL 2005 ERRORLOG file
On Feb 28, 11:12 am, Teresa Masino <teresa.mas...(a)peninsula.org> wrote: We have set up a couple of SQL Server 2005 systems and I have found that the format of the ERRORLOG files and the SQL Agent's log files are Unicode or some format that findstr cannot parse properly.  "find" parses them fine, but it doe... 21 Apr 2008 18:58

How to find records with length greater than 17
how do i write sql statment to find records with name greater than 17 characters. ... 23 Apr 2008 12:31

first minimum date in the column for each distinct column a value
Hi , i want to select the first minimum date in the column d for each distinct column a value. how i can do that in a sql query. xyztable Column a Column b Column c Column d 6014350 -10 2008-02-22 00:00:00 2008-02-12 00:00:00 6014350 4 2008-02-22 00:00:00 2008-02-26 00:00:00 6014472 -... 21 Apr 2008 14:56

The Sql ranking OVERture
A lot of sql users have a hard time reconciling the idea that a table is by definition an unordered set and the ordering involved in the sql server 2005 ranking functions. This article attempts to fill in the missing pieces of explanation that sql seems to have OVERlooked. The article takes the view that knowledge... 23 Apr 2008 18:57

how to create my own primary key which auto-increment
Hi, I'm a newbie in sql server. I want to create a primary key that should be auto incremented. for example: C0001, C0002, C0003, C0004 etc here are the attributes I have for the table cust_id, cust_name, cust_address etc ... 18 Apr 2008 14:14

select parent records that do not have a particular child
Hi, I've got a many-many relationship between people and locations: Persons {personid, namefirst, accountid} Locations {locationid, locationname, accountid} // many-many join table PersonLocation {personid, locationid} I want to find all the people who belong to a particular account, who are not associat... 18 Apr 2008 19:02

sp_prepexec syscomments?
Hi I'm sure lots of people have asked this before, but I can't find any threads so: Assuming you haven't had your profiler open for long enough is there any way of getting to the procedure code that was prepared with sp_prepexec in query analyser? If not why not? (I'm sure theres a good reason but I'd like ... 18 Apr 2008 06:48

Get rows whose sum matches a value
This should be simple, but I can't work it out without cursors. I have a table with quantity field. I want to get all first rows whose sum of quantity matches defined value. No Quantity ============= 1 50 2 50 3 80 4 80 5 80 6 50 If defined value is, lets say, 18... 20 Apr 2008 05:47

HELP WITH SELECT STATEMENT PLEASE
Hello Group I having problems creating a result set. The challenge is I have 3 tables: A customer table, A charge table and a payment table..... The result set needs to show all payments and what detail lines were paid down by each payment. Both the detail line table and payment table can contain positive and ne... 18 Apr 2008 10:14