Viewing 15 posts - 31 through 45 (of 99 total)
Thank you for your answers.
After testing disable/enable vs drop/create foreign keys I had the same performance.
Finally we prefered the 'drop/create'
Thank you
September 21, 2018 at 9:31 am
August 7, 2018 at 9:47 am
August 7, 2018 at 8:55 am
Hello everyone
I want to give you news of my project.
I was able to set up as many foreign keys as I could.
I now want to...
April 5, 2018 at 5:33 am
April 2, 2018 at 2:31 pm
Thks Phil for your help. 🙂
I have this solution too.
select requestid,
min(case when eventname = 'REVIEWED' then eventdate end) as eventdate,
...
December 4, 2016 at 2:18 pm
IF OBJECT_ID('tempdb..#test', 'U') IS NOT NULL
DROP TABLE #test;
CREATE TABLE #test
(
requestid INT,
eventdate DATETIME,
...
December 4, 2016 at 9:57 am
Hi Phil,
Thank you for your answer. This query is for a log application.
I have focused on 1 request ( requestid). But it is possible they are several requestid
This is...
December 4, 2016 at 9:55 am
No answer ??
I really need your help.
All suggestions are appreciated !!!
September 3, 2015 at 2:32 am
Viewing 15 posts - 31 through 45 (of 99 total)