Viewing 15 posts - 1 through 15 (of 20 total)
Lynn Pettis (1/21/2009)
January 21, 2009 at 3:10 pm
Jeffrey Williams (1/21/2009)
SELECT ParentID FROM Child;
You are returning at least one row where the ParentID is NULL. ...
January 21, 2009 at 2:46 pm
Yes that does work and is a fine workaround.
I want to understand why this does not work as it should work correctly and the fact that it...
January 21, 2009 at 1:57 pm
Nice, pulling out the table is a big improvement. In looking at that, I was thinking about doing more than just adding one. So I created an addition...
December 8, 2008 at 1:47 pm
Here is a stab at this issue as a function. If you pad the input with your zero symbol, you will get padded output, but it will grow the...
December 5, 2008 at 10:10 am
What do folks think about adding directly to a datetime and allowing implicit conversions to take place?
CREATE FUNCTION dbo.DateRange( @start DATETIME, @length INT )
RETURNS @range TABLE...
February 6, 2008 at 10:26 am
In looking at the problem, I thought to extend it to extracting all of the numbers in a string, not just the first. Then you could choose to deal...
February 4, 2008 at 1:02 pm
I have found using STUFF to create the output to be a little bit faster. I am assuming that it is due to traditional string concantination issues...
May 28, 2007 at 4:15 pm
This is expensive, and depending on how much data you have there are better solutions...
MAX(Borrower_1) AS Borrower_1,
May 21, 2007 at 10:06 am
we are asked to make a report that show all the students with
if the student has a score='a' then sex must be 'f' .
if the student has a score='b'...
April 25, 2007 at 11:02 am
I agree that authoring a single select per CustomerID in the key file is wasteful and there is no need for the vbs script in this case. This...
March 1, 2007 at 9:04 am
Just to toss my hat in the ring...
create procedure dbo.usp_permutate
@charset nvarchar(256) = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
set nocount on
-- a set of all values in the charset
create table #set ( k int, v nchar(1)...
November 6, 2006 at 9:35 am
The question is one of membership, and the IN clause seems to be a very clear way to pose that question. After proper indexing, it yields the same query...
August 23, 2006 at 9:23 am
I love functions... below is the function declaration but first the insert statment
INSERT INTO dbo.Invoice ( Invoice_id, Customer_name, Invoice_amount )
VALUES ( dbo.fn_NextKey(05), 'ACME Corp.', 12345.67 )
This technique also works...
May 17, 2006 at 10:29 am
Perhaps you need more naming information for the procedure. The call will make assumptions based on the current server/database that you are connected to, so if the procedure is...
May 17, 2006 at 9:44 am