Viewing 15 posts - 6,391 through 6,405 (of 13,877 total)
Repeatedly asking the same question is not going to speed up replies.
November 4, 2016 at 8:16 am
sindhupavani123 (11/4/2016)
I have the following data with client account decision and status
Clientfields value
111Decisionaccept
111Statusdeposited
112decisionaccept
113Decisionaccept
114Decisionaccept
114Statuscontract
115DecisionConditional Accept
115Statusdeposited
116DecisionConditional Accept
117DecisionConditional Accept
118Statuscontract
118DecisionConditional Accept
I would like to get
records...
November 4, 2016 at 5:54 am
hegdesuchi (11/3/2016)
Hi,When we update/insert any table how do we know which other tables are effected in sql server?
If we are using SQL profiler how do we set it up?
The...
November 3, 2016 at 4:06 pm
sgmunson (11/3/2016)
philand3 (11/2/2016)
experts,how to exclude the negative value in this OT calculation,
<<removed posted query for brevity>>
This is in the category of double-posting... and hoping for an answer that doesn't disagree...
November 3, 2016 at 6:38 am
whenriksen (10/31/2016)
Phil Parkin (10/30/2016)
The volumes I am dealing with are much lower than yours and...
November 3, 2016 at 5:50 am
philand3 (11/2/2016)
how to exclude the negative value in this OT calculation,
,CalcPart AS
(
SELECT
department,subdepartment,dutyhours,person_num, event_date, in_time, out_time, minutes,day,friday,saturday,
ROW_NUMBER() OVER (PARTITION BY event_date, person_num ORDER BY in_time) AS daypart
FROM Prep
)
,tmpResult as
(...
November 3, 2016 at 5:44 am
rjaye03 (11/2/2016)
November 2, 2016 at 1:58 pm
matej_grabnar (11/2/2016)
I have no...
November 2, 2016 at 8:30 am
hoseam (11/2/2016)
declare @t datetime = '2016-11-02 07:22:26.320'
SELECT LEFT(CAST(REPLACE(CONVERT(VARCHAR, @t, 108), ':', '') AS INT), 6)
which gives me INT value of 72226, and I want it to include the...
November 2, 2016 at 6:33 am
GA_SQL (11/2/2016)
need a script or an idea to create script when my db is full by 75% i want add some space to the db
Is that because you have set...
November 2, 2016 at 6:18 am
GA_SQL (11/2/2016)
here i done some script for finding free space
select
s.FILEID AS...
November 2, 2016 at 5:47 am
matej_grabnar (11/2/2016)
Queries are executing...
November 2, 2016 at 5:46 am
Telling us that something is "not working" is most unhelpful. Please elucidate.
November 1, 2016 at 1:52 pm
BOR15K (11/1/2016)
Luis Cazares (11/1/2016)
If you have 9 million rows, int can handle them perfectly. Unless you have a random sequence
Sadly you're right - every new customer starts from 2 to...
November 1, 2016 at 10:57 am
SQL!$@w$0ME (11/1/2016)
.net v 3.5, 4.5, 4.6, 4.6.1?
Also do I need to install the below?
Important Note:...
November 1, 2016 at 10:49 am
Viewing 15 posts - 6,391 through 6,405 (of 13,877 total)