Programming SQL

Creating SQL logins
I need to create sql login based on the query result from a result. (for example, select memberid from membership where create_dt=getdate(). The SQL login will have a default password as summer. How can I do it? Thanks, QJlee ... 11 Jul 2008 08:54

Unsupported work around
according to http://www.sqljunkies.com/WebLog/mz1313/archive/2007/02/16/28256.aspx Go to Registry and change to 0 (zero) value of the following key: HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover\AutoRecover Enabled ... 9 Jul 2008 20:56

select groups of numbers where num between 1 and 10, between1
Rich, If the column type of [value] is [int], this needs fewer lines of code still: SELECT value/10000 AS group_nbr, COUNT(*) FROM T GROUP BY group_nbr; Subtracting the remainder is unnecessary, since integer division by definition ignores the remainder. This query should return the same result as Celko... 9 Jul 2008 20:56

web interface tool
SQL 2008 rc0 I want to give a remote business partner access to my data on my home network. I would prefer to NOT open port 1433 on my firewall, for obvious reasons. Does anyone know if any type of web interface tool exists, preferably that uses SSL or at least some type of security? I need to be able to ... 11 Jul 2008 05:50

select groups of numbers where num between 1 and 10, between 1
The 17000 numbers do happen to be unique, but that is inconsequential for my purposes. Your query is amazing! You totally nailed what I needed! and only a few lines of code! Thank you very much for your help. Thank you to all the repliers for the suggestions. "--CELKO--" wrote: I have a lis... 10 Jul 2008 12:23

Inserting Default Values when an input parameter is NULL
Has anyone found a solution in SQL Server 2005 for inserting default constraint values into a table when an input parameter is NULL? In SQL you can do the following: INSERT tbl ( col1, col2, col3 ) VALUES ( @Col1, @Col2, DEFAULT ) ....but I don't see much of a point to this ... 11 Jul 2008 21:16

select groups of numbers where num between 1 and 10, between 11 a
>> I have a list of 17,000 numbers starting with min(value) = 10,000 and max(value) = 60,000. << Are they unique or not? Are they integers? You did not bother with any DDL, so we have no idea. Why did you put an IDENTITY column on the DDL? Why did you use a temp table? How can I group these numbers/value... 9 Jul 2008 18:53

select groups of numbers where num between 1 and 10, between
Thank you all for your replies. I will have to study each of the methods - I forgot to mention that I am still on sql Server 2000, although I appreciate the 2005 sample as we will eventually be stepping up to sql Server 2005. It seems that my query is a little more complicated than I was hoping for, but I wil... 9 Jul 2008 18:53

Inserting Default values
I have a situation where currently: INSERT INTO [TBL A] SELECT col1, col2, col3, col4, col5 From [TAB B] WHERE CTN_ID = 5 I added a column 6 created_date to TAB A with default as GETDATE()...and the above statement in a stored proc fails with "Insert Error: Column name or ... 9 Jul 2008 19:54

Follow-up question
I have the following situation: INSERT INTO [TABLE A] SELECT col1, col2, col3, col4, col5 From TABLE B WHERE CTN_ID = 10 I added a date column to the table A (now has 6 columns) and I want the sysdate to be defaulted...But the above statement fails with "Insert Error: Colu... 10 Jul 2008 14:28