Viewing 15 posts - 1,531 through 1,545 (of 8,731 total)
February 28, 2017 at 12:22 pm
February 28, 2017 at 11:31 am
Here's an option. Note that this is untested as I don't have anything to test on.
SELECT
FAC.[Facility_Name],
FAC.[Facility_Type],
FAC.[Status],
LIC.License_Expiration_Date,
...
February 27, 2017 at 1:06 pm
February 27, 2017 at 10:59 am
You might want to check an inline table-valued function.
--Create some sample data and data structure
CREATE TABLE MYORDER(
ORDERID int,
CODEFROM varchar(10),
CODETO...
February 24, 2017 at 1:29 pm
Is this a little backwards or is it just me?
Staples has an online coupon...
February 24, 2017 at 12:52 pm
February 24, 2017 at 10:19 am
What do you expect us to do with that? The only thing I can offer is to format the code, but not much more.
select distinct
February 24, 2017 at 9:36 am
What do you want to do with the extra values? Discard them or group them?
February 24, 2017 at 6:34 am
Reported as spam
February 23, 2017 at 7:22 am
February 22, 2017 at 7:59 am
Are you sure that you're using the correct value from @[System::StartTime] ?
Why do you have the negative mark instead of fixing the DATEDIFF parameters?
DECLARE...
February 22, 2017 at 7:39 am
Viewing 15 posts - 1,531 through 1,545 (of 8,731 total)