Lynn,

Did you ever get this figured out? Here is a link to the command line install instructions and there is a parameter for INSTANCENAME, http://msdn.microsoft.com/en-us/library/ms144259(SQL.90).aspx

If you are managing/programming this system you should be able to figure out the solution based on the previous solution I provided. I suggest you get yourself a beginners...

I think this meets your needs:

[font="Courier New"]SELECT

   COUNT(QD.qid) AS postcount,

   PD.username,

   PD.laname,

   PD.fname,

   PD.mailid

FROM

   personal_details PD JOIN

   question_details QD ON

       PD.username = QD.username

WHERE

   EXISTS (SELECT 1 FROM account_details...

You don't need to delete. I was getting ready to write a similar trigger to Seth's. The first...

Must be based on seniority!:D

I suggest you read this article[/url] as there are some issues with your trigger as is. The biggest being that it will not handle a set-based insert or update.

When...

McAfee AV blocks the Send Mail task as spam by default. You could check that.

I think this does want you want:

[font="Courier New"]DECLARE @myTable TABLE

   (

   ID INT IDENTITY(1,1),

   IDEmp INT,

   Start DATETIME,

   Finish DATETIME

   )

INSERT @myTable (IDEmp, Start, Finish) VALUES (1, '2009-01-01 00:00', '2009-01-01...

Merry Christmas to all. Enjoy the day and hopefully no ones cell phone or pager goes off for work.

If the rectangles will be variable in size then there is no way to put a divider in the middle.

Jeff Moden (12/23/2008)

---

andrewd.smith (12/23/2008)

---

Here's a method of calculating the Nth working day in the future without using a CTE or tally table.

DECLARE @days int

SELECT @days = 10

DECLARE @inputDate datetime

SELECT @inputDate...

It sure is. I think a lot of resumes are like...

Do you want to insert that row for every customer in the customers table with a match already in PS_CUST_REGN_TYPE? If this is what you want I think this...

Try this code, please note how I took the data you provided and included it in a way that can be used by others as well:

[font="Courier New"]-- test table to...

Okay the issue with my code is that I am including Requested Date as one of the business days. The Between 5 and 7 basically says I need to...