EdVassie (12/7/2016)

---

As already said, the DDL and plan is really needed to give the best answer.

However, the index suggested by Luis is guaranteed to require a clustered index lookup to...

War

ZZartin (12/7/2016)

---

The logic shouldn't be too complicated add your normal filter in the where clause for the start and end dates which it sounds like you already have then add...

I'm not sure about this approach. If the datetime column can have...

Here's an option that can help.

IF OBJECT_ID('dbo.DateTimeTable') IS NOT NULL

DROP TABLE dbo.DateTimeTable;

CREATE TABLE dbo.DateTimeTable( MyDatetime datetime);

CREATE CLUSTERED INDEX CI_MyDatetime ON dbo.DateTimeTable(MyDatetime);

INSERT INTO dbo.DateTimeTable

SELECT TOP 10000 CAST(...

Post DDL for tables and indexes involved. Also post the actual execution plan. In a previous post, I shared an article on how to get all that.

That's probably generated by an ORM.

Follow the indications on this article for further advice.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

If you don't have an index on hcs.AdminObservation(TherapyAdmin_ID) the only option is to use the clustered index.

The following index might help your query, but will also create overhead on writes....

Found

Lana

swarun999 (12/5/2016)

---

create procedure spgetuserdetails

(

@UserId nvarchar(255),

@Password nvarchar(255)

)

as

begin

declare @count int

select @count = count(*) from UsersTable where UserId = @UserId and [Password] = @Password

if(@count = 0)

begin

Print...

sharon-472085 (12/5/2016)

---

hi ,

first thank you 🙂

second i do it for test some of tables with float data that i need to convert to

char. ( dont look for logic...

That's pretty basic. What have you tried? What problem are you facing?

If this isn't homework, I'd be really concerned if you're handling passwords on plain text.

Eventhough, I appreciate your intentions to "educate the noobs". I would suggest that you stop bashing them when you can't even test your code before posting it. The code is...