We had a similar issue...

jonathanmreynolds (7/19/2008)

---

select

g.arrival as 'Arrival'

,g.departure as 'Departure'

...

Interesting, I didn't even think about the version of BOL I was using - but I...

jonathanmreynolds (7/18/2008)

---

As for your problem with multiple rows - that is going to be caused by the joins. In the following:

from transactions t

Inner Join...

,(select sum(t1.amount)

from transactions t1

...

jzurbo77 (7/18/2008)

---

In the middle of a large stored procedure I have a working SELECT (see SELECT 01 below) which at a couple of points uses CASE statement.

I need to expand...

Okay, I think this is what you are looking for - but I cannot be sure. I am not sure whether or not you need to tie transactions by...

Take a look at the following:

Select name

,create_date

,modify_date

...

Jose-cin (7/17/2008)

---

You also are going to get an error if you use the symbol " to indicate the existence of a string, the compile process assumes that the word between...

If your database is in full recovery model, the best way to truncate the log is to back it up - frequently.

If your database is in simple recovery model -...

Yes - I believe Standard only supports two nodes, but yes - it can be clustered.

Keith Knox (7/17/2008)

---

Thanks.. I was looking at linked servers as well. What I just did was create a bat file with several sqlcmd statements and that did the trick.

thanks...

I had to reformat this to get an idea of what is going on. Here is the reformatted query:

CREATE PROCEDURE usp_rptOpenTicketsByYard

AS

SELECT tblTickets.*

,tblTicketStatus.status

,tblTicketPriority.priority

,tblCallTypeSub.Description

,tblTicketCallTypes.CallType

,tblUsers.First_Name

,tblUsers.Last_Name

,tblYardInfo.YardName

,tblTickets.CreatedOn

,tblTickets.Yard

,tblTicketPriority.PriorityStatus

CASE

WHEN tbltickets.ProjectTicketOption = 0

THEN "Ticket"

ELSE "Project"

END

...

First thing you need to do is check the SPN record for that instance of SQL Server. If you do not have access to this, talk to the network...

Yes, you are right - ALL does not appear to be available for schema. So, you are going to have to list all of the permissions you want.

GRANT permission...