Melanie Peterson (4/12/2013)

---

It's late on a Friday. Someone on another forum just pointed out to me that I wasn't doing a SELECT on my temp table after I built it....

parikiti (4/12/2013)

---

The two Tables are on the same server.Table B is used as Dynamic storage to change values depending on the requirement..i can create a variable in the stored procedure...

hmbmeister (4/12/2013)

---

Ok. Thank you. I was hoping for some cool way at the database level to do it. The text search of webpages takes a long time...

It would be advisable to use the ANSI-92 style joins instead of the much older comma separated list. Your query would look like this.

SELECT p.name as [User], r.name as [Role]

FROM...

Can you post...

Why not just search the website directories for the name of the stored proc? Unless you have done something to the connection string, or pass a value to a stored...

Hi and welcome to the forums. It is nearly impossible to offer much help based on the extremely limited amount of information you provided. We don't know your systems, data...

Look at the example Lowell posted. About all you need to do is change it from a delete trigger...

IF statements control the flow of logic in a script or stored procedure. Case expressions are used to conditionally retrieve values based on conditions within a query.

I can't really tell...

So what is the question here??? We see some table names and a couple queries. There is no explanation of what you need help with. We can help but we...

ard5karthick (4/12/2013)

---

Hi All,

I have two Columns in my Table Status A and Status B.

I want to create a Default Constraint for column Status B based on the Value...

abhas (4/12/2013)

---

Hi All,

Please help me on below scenario.

I am having application where user selects startdate and enddate from his application(front end). but if he selects Startdate is 2013/01/01 and EndDate...

Melanie Peterson (4/11/2013)

---

Ah! I knew why I was getting the error message, but using TOP never occurred to me. However, I think there's still something wrong. With the new query:

insert...

Turning ANSI_WARNINGS off is dealing with the symptom not the problem. You need to make the code stop dividing by 0. You didn't post the code so we can't make...

Your query is failing because there are more than 1 row in LitHoldDetails where LitholdID = d.LitholdID and LitHoldDetailsID <> e.LitHoldDetailsID. Since this is dev data I assume you don't...