Eirikur Eiriksson (5/7/2014)

---

Sean Lange (5/7/2014)

---

Eirikur Eiriksson (5/7/2014)

---

george sibbald (5/7/2014)

---

river1 (5/7/2014)

---

Hi,

I would like to know in with date did a SQL Server 2005 instance was installed on a server.

Can I know...

Yeah that is exactly what my first post does. 😉

You could just use convert on GETDATE() to accomplish this. 😉

select CONVERT(varchar, getdate(), 112)

Here is another way.

select CONVERT(varchar, dateadd(mm, datediff(mm, 0, GETDATE()), 0), 112)

table: ut_Password

columns:

playerid (FK, int, not null)

password (nchar(10), not null)

PasswordDate (datetime)

I understand about what I should do, but I could not take it inspiring example, if a similar script ready I...

No offense intended but it isn't a problem. It is border line criminal. It is just...

Why can't more than one user have the same password? So what happens if a different user enters somebody else's...

Can you share your solution so that others may benefit from your hard work? People will find this thread in the future and will be...

This site is dedicated to SQL Server. There is an Oracle section. You might find some luck there. You may find that you have better...

computer24hr (5/7/2014)

---

hey,

I have a table of users including: UserName, Password (comuted col), FirstName, LastName, Address and other details....

I have to keep 10 Recent passwords , so I created another table...

gbritton1 (5/7/2014)

---

Sean Lange (5/7/2014)

---

gbritton1 (5/7/2014)

---

Sean Lange (5/7/2014)

---

How about this?

SELECT [Columns]

FROM Test1 T1

INNER JOIN Test2 T2 ON T1.ID = T2.ID

WHERE CASE @p_flag

WHEN 1 THEN moveFlag = 26

ELSE moveFlag > 26 OR...

I lost my memory long ago...thank {insert your supreme being here} for BOL. 😀

Eirikur Eiriksson (5/7/2014)

---

george sibbald (5/7/2014)

---

from glenn...

Agreed with the previous poster. There does not appear to be any issue here. The aliases in here are the same in each query and reference different objects but these...

gbritton1 (5/7/2014)

---

Sean Lange (5/7/2014)

---

How about this?

SELECT [Columns]

FROM Test1 T1

INNER JOIN Test2 T2 ON T1.ID = T2.ID

WHERE CASE @p_flag

WHEN 1 THEN moveFlag = 26

ELSE moveFlag > 26 OR moveFlag < 26

END...