Viewing 15 posts - 721 through 735 (of 2,452 total)
Empidd1shiftd1shifttyped2shiftd2shifttype d3shiftd3shifttype d4shiftd4shifttype d5shiftd5shifttype
21902 4 2 4 2 4 1 1 1 1
is this expected output to be in separate columns for each result...or is it just one single column?
if...
May 11, 2016 at 6:41 am
ganapathy.arvindan (5/11/2016)
CREATE TABLE dbo.ShiftScheduler(FromDate DATETIME,Shift INT,ShiftType INT ,Emp_Code VARCHAR(50))CREATE TABLE dbo.Emploee(FromDate DATETIME,Shift INT,ShiftType INT ,empid VARCHAR(50))
INSERT INTO dbo.Emploee values('1/1/2015','1/4/2015',1,1,3321)
INSERT INTO dbo.Emploee values('1/7/2015 ','1/8/2015 ',1,1,3321)
INSERT INTO dbo.ShiftScheduler VALUES('1/5/2015','1/6/2015',2,4,3321)
INSERT INTO dbo.ShiftScheduler VALUES('1/9/2015','1/10/2015',2,4,3321)
did...
May 11, 2016 at 3:04 am
your sample data set up doesnt work......plus I would suggest you extend it to include all possible variants ,
CREATE TABLE dbo.ShiftScheduler(FromDate DATETIME,Shift INT,ShiftType INT ,Emp_Code VARCHAR(50))
CREATE TABLE dbo.Employee(FromDate DATETIME,Shift...
May 11, 2016 at 2:23 am
Luis Cazares (5/10/2016)
Lynn Pettis (5/10/2016)
Eirikur Eiriksson (5/10/2016)
Michael L John (5/10/2016)
Lynn Pettis (5/10/2016)
May 10, 2016 at 2:03 pm
hlsc1983 (5/10/2016)
Studentid int as foreign key ,
Subjectid int as foreign key,
Grade int,
Gradetype int as foreign key,
Grade_pk int as primary ke
A subject can...
May 10, 2016 at 5:39 am
SELECT
m.MEMBERID,
MAX(CASE WHEN s.SESSIONID = 1 and m.MEMBERID > 0 THEN 'x' ELSE '-' END) as [01/01/2016-GROUP A],
MAX(CASE WHEN...
May 10, 2016 at 3:37 am
one way is...Gooogle for others....this doesnt auto magically know about your own national holidays / work holidays ....yadda yadda
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
SET @StartDate = '20160501'
SET @EndDate = GETDATE()
SELECT
...
May 9, 2016 at 8:40 am
kat35601 (5/9/2016)
what Workday number is today in the month today is may 9th but the workday number is 6I need away to get the workday number using getdate()
what code...
May 9, 2016 at 8:25 am
Hi Sergiy
I have looked at your trigger and I am not seeing any benefits at all.....perhaps when you have time you can run thro the following set up and suggest...
May 9, 2016 at 8:18 am
Sergiy (5/9/2016)
J Livingston SQL (5/8/2016)
ok.The original code was found on the web http://www.nigelrivett.net/SQLTriggers/AuditTrailTrigger.html
can you please provide sample to code to explain what you mean?
Many thanks
Sorry, did not have much time...
May 9, 2016 at 5:18 am
Jeff Moden (5/8/2016)
J Livingston SQL (5/8/2016)
Sergiy (5/8/2016)
J Livingston SQL (5/6/2016)
R.P.Rozema (5/6/2016)
mock up some example table and generate a significant volume of test data into it
some test data......and yeah the...
May 8, 2016 at 3:01 pm
HappyGeek (5/8/2016)
Revenant (5/7/2016)
TomThomson (5/7/2016)
crookj (5/6/2016)
DonlSimpson (5/6/2016)
Ray K (5/6/2016)
Ed Wagner (5/6/2016)
MultiplicationDivision
Integration
Amalgamation
Incorporation
[Corporate] tax
Income
Lack of
May 8, 2016 at 10:40 am
Sergiy (5/8/2016)
J Livingston SQL (5/6/2016)
R.P.Rozema (5/6/2016)
mock up some example table and generate a significant volume of test data into itsome test data......and yeah the generic audit is slow.
It's only...
May 8, 2016 at 8:26 am
ok....so what do you want to see when it has been 'let' for two months and then after two month is vacated (Void)?
do you still want 'CFWD' or something else
May 8, 2016 at 8:09 am
Rod did you run the test script I posted?
1 Million row table
-- update 6 columns on 100 000 rows
--run 10 iterations of update with trigger on
--then disable trigger and repeat
May 8, 2016 at 7:27 am
Viewing 15 posts - 721 through 735 (of 2,452 total)