Viewing 15 posts - 8,086 through 8,100 (of 8,731 total)
ChrisM@Work (6/6/2013)
Mark-101232 (6/6/2013)
... and identical solutions too!Must be correct then!
I'm not sure they're correct. If a row has factor 0.20 then it will be in both ranges.
The OP must either...
June 6, 2013 at 8:46 am
I have to be honest and say that I haven't used it before, but as understood by the documentation, it checks which columns where updated according to their position in...
June 5, 2013 at 5:35 pm
Dird (6/5/2013)
Luis Cazares (6/5/2013)
The "Numbers" or "Tally" Table: What it is and how it replaces a loop.
The problem with that is you'd have to create the table separately, when you...
June 5, 2013 at 5:19 pm
Steven Willis (6/5/2013)
Programming can usually be taught but teaching character, now that's not an employer's job even if it was possible.
You'll be surprised, but programming isn't something you can...
June 5, 2013 at 4:17 pm
Dird (6/5/2013)
Sean Lange (6/5/2013)
sk them how they would solve the standard Fizz Buzz problem in t-sql with no loops and no cursors.
Using recursion? or would you class it as a...
June 5, 2013 at 3:32 pm
By the way, are you sure you need "IF (COLUMNS_UPDATED() & 14) > 0" or you just copied from somewhere else?
June 5, 2013 at 2:32 pm
You're on the right track. Just as you got the old values from the pseudo-table DELETED, you can get the new values from the pseudo-table INSERTED.;-)
June 5, 2013 at 2:29 pm
You could ask for a query with a LEFT JOIN that need a filter on the right table, knowing that you would look for the condition to be specified on...
June 5, 2013 at 1:10 pm
DiverKas (6/5/2013)
Merge all your tables into one table with no constraint, with an additional column indicating the source database/table it came from....
June 5, 2013 at 12:50 pm
But you have to check all of your dependant tables to update the values. An option is to check your Foreign Keys are specified as ON UPDATE CASCADE.
It's hard to...
June 5, 2013 at 12:29 pm
What came to my mind is that 2 users tried to insert a row at similar times and both got the same ID from the VB function.
Why don't you have...
June 5, 2013 at 12:15 pm
That sounds like a lot of work to do when you think about it.
You should either add a Client ID to each table to preserve uniqueness when merging all the...
June 5, 2013 at 11:34 am
If I understood correctly, you need to pivot your data. A great way is to use CROSS TABS[/url]
With your data pivoted, you can concatenate the columns as you need them.
--I...
June 5, 2013 at 9:42 am
Maybe some code like this
SELECT FirstName, LastName
FROM(
SELECT FirstName,
ROW_NUMBER() OVER(ORDER BY FirstName) rn
FROM( SELECT DISTINCT FirstName FROM MyTable)x) a
JOIN (
SELECT LastName,
ROW_NUMBER() OVER(ORDER BY LastName DESC) rn
FROM( SELECT DISTINCT LastName FROM MyTable)y...
June 4, 2013 at 6:14 pm
How about using names from AdventureWorks DB?
June 4, 2013 at 6:02 pm
Viewing 15 posts - 8,086 through 8,100 (of 8,731 total)