Trigger the asp page from the End user app. The only catch here is that the end user has to always have network connectivity to that page.

1- Call a stored...

quote:

---

Let me explain what I'm trying to accomplish, it sounds like there is a better way to do this. I have an...

I have to agree with Chris. It doesn't make logical sense to call an ASP page that performs a SQL Query when you can just write a stored procedure and...

quote:

---

select empid

from emp

where empid = @empid.

---

Why not just do an Insert Into Table(EmpID) Values(@EmpID)

The...

Generally, in the past when I was checking my own work, I would write two or three sql statements to retrieve the same data back. If they all presented the...

quote:

---

...and why BI for the category??

---

Administration would probably be a more appropriate category.

In enterprise manager, from the design view of the DTS package, select package->save as from the menu and change the name of the server to a different server. The DTS...

quote:

---

As I suspected, tried with spcific columns but still the same error..............

---

I've had this error...

The problem is, when you use an inner join and then specify where t1.a='somevalue' you will only get back the values from both tables where t1.a shows up in the...

If using the cursor becomes too slow, you could always create a view on the fly passing your where clause and then run your query off of that view.

If there...

I would be inclined to agree with Preethi.

Set up a table that holds a sessionid or some other type of unique identifier and one column for each parameter.

The other option...

If you want to eliminate using a temp table couldn't you do something like this:

Select

CASE IsNull(T.Column1,'Null')

WHEN 'Null' THEN 'Do Something'

ELSE

END 'Example'

FROM

(

SELECT T1.Column1,T2.Column2,T3.Column3

FROM TABLE1 T1

INNER JOIN TABLE2 T2 ON T1.T1ID =...