Actually, the OPs query is not a CROSS JOIN. It is an ANSI-89 style inner join. Why it is returning too many rows may have more to do...

skpani (8/22/2013)

---

I have configured DB Mirroring with automatic fail over.My users are connected to Server_A .My Partner is Server_B and witness is Server_C.As we know that whenever a fail over...

Here what I see that is wrong with your process.

1. Your function will return multiple rows with each invocation of the function

2. Your stored procedure is designed to enter a...

I see where you start an explicit transaction (BEGIN TRANSACTION), but I don't see where you commit or rollback the transaction(s) (COMMIT or ROLLBACK).

If you start an explicit transaction you...

Making it easier for others to check out the...

LinksUp (8/13/2013)

---

After re-reading the requirements, I can...

kgeeel240 (8/14/2013)

---

What i mean is to get my date from 2011

for example if i say skDte >= Getdate() i don't have to go back to my code and change it...

LinksUp (8/12/2013)

---

polkadot (8/12/2013)

---

I want records for datetimes between 01/01/2000 (after midnight) through 01/03/2000 (through midnight). Is the following predicate the correct one to use?

WHERE orderdate BETWEEN '01/01/2000 00:00:00:000 AND...

Based on the very vague details provided this is the in-line table valued function I would use:

CREATE FUNCTION dbo.ClientProductPrice (

@ClientNo INT,

@ItemCode INT,

...

If you read the BooksOnline entry for sp_executesql, you will notice that it can take an nvarchar(max) variable for both the dynamic sql query and for the definition of variables.

http://msdn.microsoft.com/en-US/library/ms188001(v=sql.100).aspx

I have been around, just not as much. Not a lot time when you spend most of your time working or sleeping, every day.

Things out here in Afghanistan are...

SQLDCH (8/6/2013)

---

Welcome back, Lynn, glad to see you're able to get online.

I'll check the no-shows today at lunch and send emails accordingly.

Draft day will be on Monday, September 2 at...

roryp 96873 (8/5/2013)

---

I think you get a pass for...

Okay, I made sure to sign up just now. Been a bit busy with coming to Afghanistan and all.

tim_harkin (7/31/2013)

---

Yes, but with...