bswhipp

Forum Replies Created

Viewing 15 posts - 46 through 60 (of 78 total)

RE: Test environment SQL 2016. Need to down grade to 2014 or 2012 for testing purposes.

DesNorton - Tuesday, January 16, 2018 10:34 AM
Why use the prod server?
Rather do a side-by-side install on the test server, and then...

January 16, 2018 at 10:59 am

#1976021
RE: Test environment SQL 2016. Need to down grade to 2014 or 2012 for testing purposes.

Evgeny - Monday, January 15, 2018 2:57 PM
Unfortunately there is no options to restore a backup from a newer version of...

January 16, 2018 at 7:29 am

#1975983
RE: Row inserts for groups of rows (Totals for groups of like data).

Jeff Moden - Friday, January 12, 2018 7:06 AM
bswhipp - Friday, January 12, 2018 5:30 AM

January 12, 2018 at 7:25 am

#1975711
RE: Row inserts for groups of rows (Totals for groups of like data).

Jeff Moden - Thursday, January 11, 2018 9:41 PM
bswhipp - Thursday, January 11, 2018 12:46 PM

January 12, 2018 at 5:30 am

#1975701
RE: Row inserts for groups of rows (Totals for groups of like data).

Jeffrey Williams 3188 - Thursday, January 11, 2018 12:34 PM
I scanned through this...so maybe I missed something, but I think the OP...

January 11, 2018 at 12:46 pm

#1975601
RE: Row inserts for groups of rows (Totals for groups of like data).

drew.allen - Thursday, January 11, 2018 8:26 AM
As I mentioned, there are two sources of NULLs. You could use the brute force...

January 11, 2018 at 8:39 am

#1975523
RE: Row inserts for groups of rows (Totals for groups of like data).

Jeff Moden - Wednesday, January 10, 2018 4:48 PM
bswhipp - Wednesday, January 3, 2018 6:22 AM

January 11, 2018 at 5:49 am

#1975481
RE: Row inserts for groups of rows (Totals for groups of like data).

drew.allen - Wednesday, January 10, 2018 11:39 AM
bswhipp - Wednesday, January 10, 2018 11:25 AM

January 10, 2018 at 11:53 am

#1975357
RE: Row inserts for groups of rows (Totals for groups of like data).

bswhipp - Wednesday, January 10, 2018 9:13 AM
bswhipp - Tuesday, January 9, 2018 12:12 PM

January 10, 2018 at 11:25 am

#1975352
RE: Row inserts for groups of rows (Totals for groups of like data).

bswhipp - Tuesday, January 9, 2018 12:12 PM
drew.allen - Tuesday, January 9, 2018 8:14 AM

January 10, 2018 at 9:13 am

#1975314
RE: Row inserts for groups of rows (Totals for groups of like data).

drew.allen - Tuesday, January 9, 2018 8:14 AM
subramaniam.chandrasekar - Monday, January 8, 2018 10:47 PM

January 9, 2018 at 12:12 pm

#1975146
RE: Row inserts for groups of rows (Totals for groups of like data).

bswhipp - Thursday, January 4, 2018 7:19 AM
bswhipp - Thursday, January 4, 2018 5:57 AM

January 4, 2018 at 7:23 am

#1974449
RE: Row inserts for groups of rows (Totals for groups of like data).

bswhipp - Thursday, January 4, 2018 5:57 AM
drew.allen - Wednesday, January 3, 2018 9:06 AM

January 4, 2018 at 7:19 am

#1974446
RE: Row inserts for groups of rows (Totals for groups of like data).

drew.allen - Wednesday, January 3, 2018 9:06 AM
SELECT fvendno, fcompany, POItemKey, PORelsdate, SUM(totstdcost) AS TotStdCost
FROM #mytable
GROUP BY fvendno, fcompany, GROUPING...

January 4, 2018 at 5:57 am

#1974431
RE: Row inserts for groups of rows (Totals for groups of like data).

drew.allen - Tuesday, January 2, 2018 1:25 PM
Yes. Use GROUPING SETS. If you want a more complete answer, post sample data and...

January 3, 2018 at 6:22 am

#1974206

Viewing 15 posts - 46 through 60 (of 78 total)