bismsit.29 (3/3/2016)

---

Hi All

I want to assign one unique id to each row in a table and the range is from 1 to 99999. there will be a flag for active...

Take a look at sp_whoisactive by Adam Machanic.

You can run CLRs compiled and under .Net framework 2.0 on a SQL 2014 instance.

Building on Amos' solution... Note that you don't need "ELSE NULL" in a CASE statement. Returning NULL is the default behavior when an ELSE is not specified.

DECLARE @table1 TABLE...

Without handling it in the main report I think you're out of luck. You can't have drop-down parameters for sub-reports.

If you are using SQL Serve and wanted to handle the string manipulation inside a dataset you could do something like this:

-- your data

DECLARE @strings TABLE (s varchar(100));

INSERT @strings VALUES('PT=45.7=02/07/2002'),...

raven066 (3/3/2016)

---

HI All,

Recently i was thinking about Oracle, beacuse right now I'm MS SQL DBA/DEVELOPER.

Some people said that oracle is future, and i'm little bit confused.

Can Senior members in...

SQLRNNR (3/2/2016)

---

Alan.B (3/1/2016)

---

Ed Wagner (3/1/2016)

---

Alan.B (3/1/2016)

---

jasona.work (3/1/2016)

---

Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

Hmm, using DD makes it seem so far away, lets try...

Sean Lange (3/2/2016)

---

Steve Jones - SSC Editor (3/2/2016)

---

Alan.B (3/1/2016)

---

Ed Wagner (3/1/2016)

---

Alan.B (3/1/2016)

---

jasona.work (3/1/2016)

---

Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

Hmm, using DD makes it...

Ed Wagner (3/1/2016)

---

Alan.B (3/1/2016)

---

jasona.work (3/1/2016)

---

Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

Hmm, using DD makes it seem so far away, lets try WEEK...

That's a...

jasona.work (3/1/2016)

---

Ah, using SQL Server DATEDIFF to figure out how many days until my vacation...

Hmm, using DD makes it seem so far away, lets try WEEK...

That's a little better...

How about...

If you go into SSMS, Server/Instance properties that's where you can set the minimum and maximum memory settings. If the minimum memory setting is ~89% of your memory that would...

Stix83 (3/1/2016)

---

select statement:

select a.Owner_Id,

b.Name as KPI,

B.Record_Type,

B.Resource_Id,

C.Display_Name,

count(A.Owner_Id) as Max

from amgr_appointments A

right outer join AMGR_Resources B on A.Owner_Id = b.Resource_Id

right outer JOIN ADMN_User_Details AS C ON A.Creator_Id=C.User_Id

where b.Resource_Id in ('R25B2864CB6', 'R2691D72523', 'R25B2868972','R25B2868EE0','R39D1B39765',...

Brandie Tarvin (3/1/2016)

---

As part of some classes I've been taking lately, I had to do record some video presentations. I'd love some feedback on my latest, if none of you...

I don't get what MTD is or exactly what you are trying to do.

If you are looking for a default parameter value of the first day of the month and...