Viewing 15 posts - 1,066 through 1,080 (of 14,953 total)
asm1212 (8/6/2012)
I have tried using the MAX function, but it does not...
August 7, 2012 at 5:59 am
Why would instance2 (test instance, right?) need to increment with a positive number, ever? Positive numbers on it would be real data (from instance1). Set it for identity...
August 6, 2012 at 1:59 pm
Keep in mind that Steve may not have final say in whether that can be done or not. Volunteer-work for for-profit companies gets legally complicated. That's one reason...
August 6, 2012 at 1:53 pm
Okay. So what you'll need to do is break the data up by word, so you have the row ID (A, A1) and each "word" as a separate row....
August 6, 2012 at 1:42 pm
Are you familiar with aggregate functions (like MAX and MIN) in queries? You can use those in Views, just like any other query.
August 6, 2012 at 1:33 pm
If any component of the data isn't an exact match, an equality comparison will fail. I wrote that bit when I thought they were looking for whole-day-ranges (my 112...
August 6, 2012 at 1:31 pm
If odd/even won't work, you can have test data be set up with negative numbers and production with positive numbers.
August 6, 2012 at 1:29 pm
Maintaining unique identifiers across computers is pretty much what GUIDs were invented for.
Take a look at GUID and UNIQUEIDENTIFIER online. You'll find the relevant data easily enough.
August 6, 2012 at 1:13 pm
That makes sense.
That means a variable number of columns, from what I can see. That's fairly complex to code, unless XML is an option for the output.
Will the application...
August 6, 2012 at 12:51 pm
Restarting the SQL service is probably speeding things up by getting rid of poorly built execution plans from the cache. That might speed it up, for a while, but...
August 6, 2012 at 12:37 pm
On the date-math item, it's not so applicable to a delete date, but it is to others.
Since you may have to declare a non-null "end date" that has to be...
August 6, 2012 at 12:27 pm
Mike Dougherty-384281 (7/14/2012)
Jeff Moden (7/13/2012)
Mike Dougherty-384281 (7/13/2012)
Ola L Martins-329921 (7/13/2012)
...hence I never delete a-n-y-t-h-i-n-g from the tables. I use a switch "bit_deleted" and a view to get the not-deleted records...
consider...
August 6, 2012 at 12:20 pm
Do you know before-hand how many columns you'll have in the final output? If not, you'll need some sort of dynamic SQL to write the query for you. ...
August 6, 2012 at 12:08 pm
Jeff Moden (8/6/2012)
GSquared (8/6/2012)
August 6, 2012 at 12:05 pm
It looks to me like you're just repeating the contents of each row. "A B C" becomes "A B C A B C" (I just took out the repeating...
August 6, 2012 at 11:34 am
Viewing 15 posts - 1,066 through 1,080 (of 14,953 total)