You really need to show us more and you really need to try and do this yourself first. We have no problems helping you with it but we really...

sudheerapps436 (5/20/2014)

---

Hi, I haven used stored procedure in sql server to get the data using LADP Query,I am getting errors.Could you guide on this.

ALTER PROCEDURE Sample_GetDetails(@len nvarchar(max),@OutNTID VARCHAR(300) OUTPUT)

AS

BEGIN

Declare @name...

If you look at the execution plan of a query using the BETWEEN operator you will see that it is converted to a >= and <=.

Any one else see this?

http://www.eweek.com/developer/how-java-api-legal-ruling-could-change-coding-forever.html?kc=EWKNLEAU05202014STR2&dni=127035848&rni=23946789

That would work out to about 2 hours of assistance each month.

Consultants aren't cheap.

Well, I hope you got what you wanted. I still can't quite figure out how you get your expected results from your sample data as your code really isn't...

Ramakrishna-148487 (5/18/2014)

---

my procedure contains three four temporary tables and using without creation of table structure

for ex:

Select * into #td from transsactions

Transactions tables contains huge data. Like that i...

Jeff Moden (5/18/2014)

---

While that's convenient,...

Before I explore any alternatives can you explain how your code works to create the given results based on the sample data?

I'm not sure what you are actually trying to...

LutzM (5/18/2014)

---

Lynn Pettis (5/18/2014)

---

...

Depending on how many rows and columns are in the lookup table, a table scan of the lookup table may not be an issue. If we...

Definitely not enough information to help. First thing I would do is read the second article I have linked in my signature block regarding performance issues. It will...

Actually, you run that select statement in any database as @@VERSION returns the information regarding the SQL Server instance, not the database...

Constraints (or other database objects) don't change on their own. Someone has to run DDL either through SSMS or SQLCMD, or another third party tool that can modify database...

LutzM (5/18/2014)

---

This will force the query to perform a table scan...

Well, didn't take that long.

DECLARE @Mtbl AS TABLE (id INT,Rid INT, DATA VARCHAR(10))

DECLARE @Ctbl AS TABLE (id INT,Rid INT,Tdata VARCHAR(10))

INSERT INTO @Mtbl

VALUES

(1,1,'test'),(1,2,'test'),(1,3,'test'),

(2,1,'test'),(2,2,'test'),(2,3,'test'),

(3,1,'test'),(3,2,'test'),(3,3,'test'),(3,4,'test'),

(4,1,'test'),(4,2,'test'),(4,3,'test'),(4,4,'test');

INSERT INTO @Ctbl

VALUES

(1,1,'Data1'),(1,2,'Data2'),

(3,1,'Data3'),(3,4,'Data4');

/****************Result would be like this **************************/

DECLARE @Rtbl...