Edited to change char(10)  which is a line feed to char(32) which is a space. Sorry guys been awhile since I have used ASCII codes to format text. BTW char(10)...

Hi the problem seems to be in the design of your database. In T-SQL you can not assume any relationship based on the order that data is entered. Could you...

Michael are the JD you coverting being passed as an 7 digit number or as a decimal? ie 2443711 or 2443711.8125 The decimal portion equals parts of a day. Assuming you have...

Hi  I am a little confused you said that the string will contain both regular(ASCII) spaces and UNICODE double width spaces? If the String is stored in UNICode then...

Rob the Truth table in T-SQL when using the AND operator is not the same as the Truth table C uses. Could this be the...

Rob could you give me an example of checking for zero where you generate an error.

Thanks Mike

Bersileus thanks for the test. Very interesting way of checking, now why did I not think of that. And the results are ta ta T-SQL...

Hi the declaration of parameters takes place in the create statement.

CREATE PROCEDURE au_info

   @lastname varchar(40),

   @firstname varchar(20)

AS ......

You can then call the procedure using

EXECUTE au_info 'Dull', 'Ann'

--...

If you cut and paste my code you will have to insert a ) at the end of the second select statement. Love those expressions

David try this

HTH Mike

IF Object_ID('TempDB..#Parent')>0

 DROP TABLE #Parent

IF Object_ID('TempDB..#Child') > 0

 DROP TABLE #Child

CREATE TABLE #Parent

(

 Pk int,

 OtherStuff VarChar(20)

)

CREATE TABLE #Child

(

 FKParent int

)

DECLARE @Count int

Set @Count = 0

While @Count <10

Begin

Set @Count = @Count +...

Rob I' not dyslexic (typing d for b) I just can't type it's those fat fingers of mine the same ones that typed 2 for 20. Now they are typing n...

Hi Iostdba I am getting an error when trying to run your code posted on 5/9/05. Testing your first code Gives dates ranging from 2004-06-21 to 2005-01-03 Are these the...

Ron you are the man it works like a charm. The easy fix was my changing my code from Top 2 to top 20 (which is what I though it...

Replaces Previous Post

Ron Thanks that is real close. Using my previous posed dat and when scheduling for a 1 hour appointment returns 10:40 and 10:50 which gets us to lunch...

Rob I just hate it when my computer eats my stuff. been there done that . If you don't preview the post it seems...