The semi-colon at the start of his query is actually bad when demonstrating the method used for creating a CTE. It's there to terminate the previous statement but is often...

rhd110 (3/1/2012)

---

Hi,

Using the command prompt we use

1. Open Run window

2. Type SQLCMD enter

3. Type USE TestDB enter

4. Type GO enter

5. EXEC dbo.sp_InsertTempValue 101

6. Type GO enter

The following steps insert values...

LutzM (2/29/2012)

---

I would use an auxiliary table to hold the call information:

CREATE TABLE calls

(

callid INT IDENTITY(1,1),

appId INT,

callTime DATETIME,

...

I am waiting on the sample input, but I am pretty sure that it will be...

Hey Celko, when you consult with a client who has applications built around a database (assuming you actually work and don't just talk theory), do you tell them to rebuild...

rocky (2/23/2012)

---

3 jobs are configured to send notification to account W; 3 configured to send noti to account X; 3 configured to send noti to account Y. when all...

Ok, let me ask you this... Why do you think account X is default versus account Y? How did you figure that out?

rlswisher (2/23/2012)

---

Your example does not do what I was referring to. In the original post V2,

From Table A

Left Join B on ID = ID

Where A.Col = x

and B.Col...

Go to your default SQL Server Log folder (...\MSSQL\log\) and look at the error log file.

rlswisher (2/23/2012)

---

As a left join, you are returning all rows from Table A, but only those in Table B that match (given the specified critera).

In your alternative, by removing the...

Did you recently delete any folders? ...\MSSQL\DATA or ...\MSSQL\LOG

These folders need to be in the configured place. You should see an error that says Cannot open specified folder...

Ok, now you have to go to the event viewer and see why it is not starting. Or, go to SQL Server Configuration Manager and try to start it from...

Maybe so, but I have 2 profiles on my server and both...

If MSSQLSERVER is stopped, then the database engine is not running. MSSQLSERVER must be running in order to start SQLSERVERAGENT service.

A 1068 error means one or more of the required services is not running... So... Which services are stopped?