我有以下1000行的查询staffdiscountstartdate,datediff(day,groupstartdate,staffdiscountstartdate),order by staffdiscountstartdate descselect a.employeeid,b.employeeid
from tblEmployees a,tblCard
我有三个表,Employee、TestingA和TestingB,其中employeeID是TestingA和TestingB中的外键 [employeeID] [int] IDENTITY(9500,1) NOT NULL,select e.employeeId from Employee e -- If @Type = 'Te