Programming SQL

sunday is my week ending day
Hi All, When I use DATEDIFF(week, '6/1/2010', '6/6/2010') the answer I expect should be 0 because I consider Sunday my week ending day. The answer I get is 1 which is incorrect in my situation. How would I adjust for this? Thanks, rodchar ... 1 Jun 2010 14:12

Forming a date
I need to have an INSERT statement put the begain and end dates of each quarter of a year into date columns, e.g. 1-1-2010, 3-31-2010, etc. I have the following but is giving an error. Can someone help? Thanks. INSERT INTO BranchDates ..... SELECT CAST('1/1/' + YEAR(GETDATE()) AS Date) ,CAST('3/3... 1 Jun 2010 03:16

How write this sql query
Dear friends, I have a table as bellow family-id ChildName 1 jack 1 susan 1 john 2 smith 2 jack i want to see and insert them to other table as id name1 name2 name3 name4 1 jack susan john <null> 2 smith jack <null> <null> something like pivot but fields name are fixed and values distributed ... 31 May 2010 22:57

insert into syntax error
Hello. Excuse if I posted this in the wrong area but wasn't sure if it would go here or an asp.net group since this is involving a webapp. I have an insert statement that give me a syntax error near Where type error. The insert is not a long one, which is shown below. INSERT INTO tblChangeRequest (IsChild... 31 May 2010 11:58

Add Primary Key enforced with Existing Unique Index: How To
Thanks Gert, I wrote a query to do this, but was hoping to avoid the build. Oracle can do this, so I thought SQL Server might be able to as well. It's good to know for sure, so thanks for the info. Thanks, Bill On May 29, 3:06 pm, Gert-Jan Strik <sorrytoomuchspamalre...(a)xs4all.nl> wrote: Bill, ... 30 May 2010 16:31

Add Primary Key enforced with Existing Unique Index: How To
Got a bunch of tables from an exernal app that don't have Primary Keys defined, but they do have unique indexes. I need to add a primary key for replication. I would like to add a primary key to these tables, but I want to say "Don't make a new index to enforce the primary key, just use the existing unique inde... 29 May 2010 19:02

Query Question - Friend - Friend - Friend - Friend ... relationshi
On Thu, 27 May 2010 17:06:14 -0700 (PDT), --CELKO-- <jcelko212(a)earthlink.net> wrote: What was the silly, totally non-relational "index_id" about? Do you know what a key is in RDBMS? Where would it exist outside of physical storage? How would you validate or verify it? Good question, reminds me, I a... 4 Jun 2010 02:43

CURSOR_STATUS question
I was having trouble with this earlier, thought I solved it but then trouble again. I want to create the following: DECLARE crBadAdjs INSENSITIVE CURSOR FOR..... But I need to test it for CURSOR_STATUS which I don't seem to be able to do with INSENSITIVE because I don't know if it's local or global.. I... 28 May 2010 09:20

Possible to do a partial join - for partially matching join fi
Thanks. This sort of works. I will have to experiment with it a little bit to get it to isolate all the rows I need. It does isolate a few of the rows. "Plamen Ratchev" wrote: Try: SELECT <columns> FROM A JOIN B ON A.company LIKE B.company + '%'; -- Plamen Ratchev http://w... 27 May 2010 18:11

Threading in CLR procedure
Hi all I am having some trouble with threading in a CLR procedure. Here is the scenario: On a SQL Server 2008 instance I have build a CLR procedure written in C#. The procedure works fine. Now I have added multithreading functionality and there are some problems: - As longest there are no exception, all works ... 27 May 2010 17:05