Along with the IDENTITY_INSERT command you need to specify a column list

LIKE

INSERT INTO tblDistributors (Column1, Column2, ...etc)

Rats Should've typed faster 😀

I haven't gotten through that book yet (been writing too many essays for school) 🙂

I'll have to get back into it and see what it says.

Thanks for the info.

Mark

I guess I don't know if these need to be two seperate jobs, but if not one option would be to combine all of the tasks of both into one,...

Eric

I guess there are mixed opinions of this out there, because another DBA told me this was the preferred method and it seems to work well for me.

That said though...

I guess I can't say for sure what impact that will have on the server, but I do know that when I tried to run a trace to look for...

Look at sp_start_job in Books Online. You should just be able to run the secondary job as part of the primary.

Here is another way that does include your desired result.

DECLARE @TempTable TABLE (Number int,

                          Value  int,

                          Location varchar(100),

                          [Order] int)

SET NOCOUNT ON

INSERT INTO @TempTable

SELECT 4444, 25, 'Room A', 2

UNION ALL...

It could still be done in set based logic.  If the calling app sends in the page number it wants and the page size, the following query logic can be...

Never mind.  I see where it can account for when your birthday is.  I did find that it doesn't seem to get down to the day level though.  You can play...

Well it produces the right results, but I would question why you'd use a calculation based on the number of days when you could just use yy instead.

Set @AgeAtWildParty =...

If you have one you should see it in the same project as the Crystal report.

When you created the Crystal Report, how did you establish the link to the stored...

My guess is that the XSD (dataset file) is out of sync with the new proc.  You should be able to access the XSD file and add the new parameter...

Noel,

I was just trying to make sure that if there was no corresponding 'H' in the table, that it wouldn't return one.

Mark

This should give you what you're looking for.  I wasn't able to test it so beware of Typo's

   SELECT A.code

        , CASE WHEN B.type IS NULL

               THEN H.type

               ELSE B.type

         ...

I agree with Tim.  Why not do something like...

@NAME NVARCHAR(250) = '',

@EMAIL VARCHAR(100) = '',

@PHONE VARCHAR(15) =  ''

SELECT *

  FROM Users

 WHERE (@Name  = '' OR Name  = @Name)

   AND (@Email...