Eirikur Eiriksson (5/11/2014)

---

Hi David and Lynn,

thank you both for the input, I appreciate it.

Firstly, this is a valuable discussion and would merit a thread on its own.

Thanks to columnar...

David Burrows (5/11/2014)

---

Lynn Pettis (5/11/2014)

---

Eirikur Eiriksson (5/7/2014)

---

rhythmk (5/7/2014)

---

Can you please elaborate with more...

I should look at putting together some kind of presentation(s) while I am out here in Beautiful Brown Afghanistan. I would like to give presenting at a local UG...

Eirikur Eiriksson (5/7/2014)

---

rhythmk (5/7/2014)

---

Can you please elaborate with more clarity as I am...

Just to add to what Jeff said. Since this is for a class we would like to see you doing the work and using this forum to show what...

Here is a quick explanation using comments. Expect a much more detailed explanation from Jeff, but hopefully this helps get you closer to understanding what it does and how....

eligiable (5/4/2014)

---

Lynn Pettis! The 2nd Query is just for reference, that what I'm trying to get into the results. My main Table is tblGen_Users and UserID is PK, I've tried...

eligiable (5/4/2014)

---

I've following query which display the result as required, but I need to get the missing Primary Key Values which are not available in the result:

SELECTA.SignedByUserID, B.FullName, COUNT(A.OutletID) AS...

LutzM (5/3/2014)

---

Lynn, I'd like to disagree regarding "no reopening a previous tab".

There are tools out there (e.g. RedGate's SQL Prompt -> advert intented 😉 ) that'll allow you to save,...

If, while closing a tab, you do not save the sql code contained in the tab it is lost. There is no reopening a previous tab to retrieve what...

Instead of all the conversions you could use the scalar function msdb.dbo.agent_datetime.

For example:

declare @rundate int, @runtime int;

set @rundate = 20140502;

set @runtime = 512;

select msdb.dbo.agent_datetime(@rundate,@runtime);

Zohaib Anwar (4/30/2014)

---

What I really need is a way to ensure that the query runs fast all the time, today it seems to be running fast on my machine. I...

Aram Koukia (12/9/2013)

---

I think for the NULL values you can set the default value for the column to 0 in the column definition, so when the data is not provided,...

mindaugas 67490 (4/30/2014)

---

Helllo,

Can somebody help me? I have a table with 5000 rows history about working and retired time.

It is the serveral rows from table(User, StartDate, EndDate):

User1 2011-05-09...

SQLKnowItAll (2/18/2014)

---

We are looking for a very knowledgeable mid-level DBA for a company in Westchester, IL. Knowledgeable means strong t-sql, knowledge of DMVs, Extended Events, and knowledge of Systems (Kerberos,...