reliableitservice (6/11/2012)

---

Thank you all for your responses and I thought my post was going to be kind of complicated after I had posted.

Here, I attached something that could make this...

yanivkahana10 (6/10/2012)

---

Hi,

I Have 2 table :

The first Contain's : Username , Password, firstname etc'...

I need to build an after update\insert Trigger that will contain 10 lastest username password.

I'm Thinking...

I am a bit confused. The title of your post sounds like you are working with Oracle. Then you talk about what sounds like sql server. Then you say MySQL...

Our net nanny says that is a potentially damaging site.

Stefan Krzywicki (6/8/2012)

---

Ugh, just found out we're switching to security that requires you to change your password every 90 days. Nice that we're switching to that now that security experts...

Are seriously trying to explain to Jeff Moden how deletes work in SQL Server?

Jeff I am surprised you didn't comment on...

With dynamic sql.

If you want some real help post some ddl, sample data and desired output.

Look at what you have posted and ask yourself if you think you provided anywhere near enough information. We are volunteers...

Well as I said previously you should consider moving your data to a stored procedure and the calling...

Well the explanation is a bit sketchy but let's use the data you posted in your post. I used your function to create a temp table.

create table #HoursMin

(

ID int identity,

HM...

Can you post some ddl for this table so we know what datatypes you are working with?

Sounds to me like global temp tables is not the best approach here. How do you handle multiple users getting different reports at the same time?

To directly answer your question,...

Looking at this again I suspect the OP is doing pass through queries from...

Hi and welcome to SSC! Your post does not have anywhere near enough information for anybody to help. From your description it sounds like you should look at MERGE. http://msdn.microsoft.com/en-us/library/bb510625.aspx

If...

AndrewSQLDBA (6/7/2012)

---

I did find that changing the Windows tooltip color, that is changes the background color of any NULL value in SSMS. A long way around, but I am using...