What part is being stubborn. ASP or proc. Are you getting any errors?

Is the data being passed correctly?

Debug by displaying the values of the parameters after they have been...

Ah my error methinks. Remove this code from the beginning of your proc,

select @EmpID = e.EmpID,@DeptID = d.DeptID

from tblEmp e

inner join tblDept d on d.deptid = e.deptid

where e.fullname = @fullName

IF...

Hey, got into this a bit late but what a great thread. Must admit I am the same as Jeremy Sequel Server and S Q L statments. I love using...

Maybe I confused you. Basically to use your proc you need to derive EmpID and DeptID. All I was suggesting was since you already populate the drop downs from a...

Don't know. Might depend on what you are doing, just retrieval or more. Maybe you could try both and post your findings.

Maybe others could post their thoughts!

One advantage is that...

How about

select t.c1,t.c2

from test t

inner join (

select c1, count(*) as num

from test

group by c1

having count(*) > 1) as a on a.c1 = t.c1

left outer join (

select c1,...

A view might be better

on SERVER_A

use AnotherDB

GO

create view SomeTableView as

SELECT * FROM

Server_Remote.SomeDB.dbo.SomeTable

GO

on SERVER_B etc

SELECT * FROM

Server_A.AnotherDB.dbo.SomeTableView

Based on the form and assuming the Employee and Department are generated from a database table I would change the drop downs to include the id's and pass the return...

No need to apologize, it's easy to understand your own systems and problems but trying to explain them to someone else!!

That's in the lap of the gods

Nice one cql. Your choice of tardis appropriate here

Not sure surreal, looks too pretty and structured for surreal, maybe cubist!

Hi simflex,

You sure know how to turn someone's brain to mush with your questions.

You say tkbr0wn's solution is what you are looking for but it doesn't work! In your first...

SELECT

h.sdept_key,

h.fin_form_key,

w.day_key,

w.fin_week_key,

w.fin_week_comm,

w.fin_month_key,

w.fin_month_no,

w.fin_year_key,

st.store_key,

sum(isnull(sw.retail_value,0)),

sum(isnull(sw.local_value,0))

FROM

day_hier_keys h

inner join database.dbo.sclass_struct sc

on sc.sdept_key = h.sdept_key

cross join day_store_keys st

cross join day_keys w

left outer join day_tmp sw

on sw.store_key = st.store_key...

Hey try this surreal solution. I doubt perfomance would justify it.

SELECT ((CASE WHEN CHARINDEX('h',elapsedtime)>0 THEN CAST(LEFT(elapsedtime,CHARINDEX('h',elapsedtime)-1) AS int) ELSE 0 END) * 3600)+

((CASE WHEN CHARINDEX('m',elapsedtime)>0 THEN CAST(SUBSTRING(elapsedtime,(CASE WHEN CHARINDEX('h',elapsedtime)>0 THEN...

Good info Andy and neccessary tidy up, have fallen foul of this before. Now, before I create a database on a server from a backup and I know that the...

Unfortunately not. The use of GO splits queries into batches and a proc can only be one batch. BOL states that 'A table cannot be altered and then the new...