rsrvas (9/3/2015)

---

Hi All,

I have 2 tables as defined below. I want to calculate PS1time and Ps2 time.

Table 1

O_IDP_TYPEP_startdateP_enddate

ABCP8/24/2015 13:148/24/2015 13:41

ABCP8/24/2015 14:038/24/2015 15:31

ABCP8/25/2015 12:098/25/2015 13:25

XYZP8/28/2015 13:108/28/2015 21:44

Table 2

O_IDS_TYPES_startdateS_enddate

ABCS28/24/2015 13:148/24/2015 19:22

ABCS28/24/2015 19:228/30/2015...

Colony

TomThomson (9/3/2015)

---

Ed Wagner (9/3/2015)

---

I would definitely attend your presentation on DBCC Timewarp. However, given the topic, expect some serious heckling. 😉

Those who have never heard of it will sit...

Brand

Ed Wagner (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that...

Quick suggestion, don't use the Fn_split function, use DelimitedSplit8K [/url]instead

😎

sandhyak16 (9/3/2015)

---

Hi,

I am using FOR XML to generate the HTML and following is my query. I am using td { white-space:nowrap;} for the columns to used no wrap. But i...

mar.ko (9/2/2015)

---

I need to use the same SQL source code in more than one stored proc.

Is there a way to -include mysql.sql or something like that ?

How does everyone handle...

Capital Punishment

Steve Cornwell-278514 (9/2/2015)

---

It's a big shared environment with 9 other instances of SQL Server are running. Approximately 200 GB of physical memory remains unallocated at this time. No...

What else is running on this server apart from the SQL Server? Why such a meagre memory configuration if the server has 512Gb of RAM? Are you RDP'ing on to...

Munabhai (9/1/2015)

---

drop table #temp

CREATE TABLE #TEMP

(

date1 DATE,

date2 DATE

)

insert into #TEMP values

('2011-06-18','2011-06-29'),('2010-12-09','2010-12-15'),('2011-03-04','2011-03-16'),('2010-02-09','2010-07-08'),('2010-03-10','2010-03-31'),

('2010-03-31',null),('2014-08-01',null),(null,'2010-07-08'),('2010-07-08',null),(null,'2014-05-23'),

('2011-02-09','2011-02-02'),('2011-06-22','2011-06-14'),(null,null),(null,null)

SELECT date1, date2,

CASE

WHEN (ISNULL(date1, '1900-01-01') = '1900-01-01' AND ISNULL(date2, '1900-01-01') = '1900-01-01') THEN 0

WHEN ISNULL(date2, '1900-01-01')...

jharvey6 76850 (8/31/2015)

---

I have been tasksed to create a data table and stored procedure to extract a special formatted XML file that is an attachment with a standard XML envelope....

Ed Wagner (8/31/2015)

---

SQLRNNR (8/31/2015)

---

Brandie Tarvin (8/31/2015)

---

Ed Wagner (8/31/2015)

---

Sean Lange (8/31/2015)

---

Grant Fritchey (8/31/2015)

---

For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From...

For fun, here is an alternative

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @STR_DATE VARCHAR(6) = '083115';

SELECT CONVERT(DATETIME,STUFF(STUFF(@STR_DATE,3,0,'/'),6,0,'/'),1);

Output

2015-08-31 00:00:00.000