Viewing 15 posts - 1,231 through 1,245 (of 4,820 total)
This is what I came up with, but I suspect it's effectively just a combination of original code and Lynn's....CREATE TABLE #Devices (
DeviceUid uniqueidentifier NOT NULL PRIMARY KEY...
May 23, 2018 at 1:09 pm
May 23, 2018 at 12:13 pm
May 23, 2018 at 11:54 am
May 22, 2018 at 10:48 am
If once you do that LEFT JOIN, you get more records than you started with, then you must have multiple rows in the LEFT JOINed table that match any given...
May 22, 2018 at 10:32 am
When trying to run that scripts,getting some permission error messages,need to fix that now.
is there...
May 22, 2018 at 10:11 am
May 22, 2018 at 10:07 am
Basically, matching only on the last 4 isn't going to give you a correct result, as two people can easily have the last 4 of their SSN be the same. ...
May 22, 2018 at 9:47 am
Question is, are the values in the database "per unit time", or in some way cumulative? It's important to understand exactly what one row in the database table actually represents. ...
May 22, 2018 at 9:36 am
May 22, 2018 at 9:26 am
May 22, 2018 at 9:09 am
We are having an application(VC++ windows service) ,which connects to SQL server through DB-Library(sqldb.h).This is...
May 21, 2018 at 10:53 am
May 21, 2018 at 9:34 am
And here's the rest of the code that handles the last Sunday in both March and October, with a test rig to produce results for the entire period from date...
May 21, 2018 at 9:30 am
Viewing 15 posts - 1,231 through 1,245 (of 4,820 total)