Viewing 15 posts - 4,651 through 4,665 (of 14,953 total)
Turn the adjacency hierarchy into a standard many-to-many (joining the primary table back to itself), with a date-effective range in the join table.
When you build the CTE, you just have...
March 10, 2011 at 9:22 am
Jeff Moden (3/10/2011)
GSquared (3/10/2011)
March 10, 2011 at 9:19 am
Jeff Moden (3/10/2011)
GSquared (3/10/2011)
March 10, 2011 at 9:18 am
Jeff Moden (3/10/2011)
Wesley Brown (3/10/2011)
March 10, 2011 at 7:52 am
You need Alter Object permissions to truncate, because of what it does to Identity columns and all that.
You might be better off skipping that step entirely. You can include...
March 10, 2011 at 7:14 am
I did this in SQL 2008. Used your table create and populate script, then:
;with Prizes as
(select *, ROW_NUMBER() over (partition by ProductName, Unit order by Value desc) as Row
from...
March 10, 2011 at 7:07 am
Yes. You just need to change the Like statement to include the Letter column as many times as you're looking for, and then change the Replace statement the same...
March 10, 2011 at 6:55 am
You'd have to rework the way you're calling the data in order to get that to work.
March 10, 2011 at 6:51 am
alen teplitsky (3/9/2011)
GSquared (3/9/2011)
alen teplitsky (3/9/2011)
March 10, 2011 at 6:48 am
I've used a variation on this solution for sorting before, and found that it works best if you pad numerical values with leading zeroes to a fixed length, before sorting...
March 10, 2011 at 6:41 am
Removing data from a database won't make the files shrink. You have to actually tell it to shrink them to get that to happen.
Keep in mind that shrinking database...
March 9, 2011 at 2:34 pm
Since you already have the letters (in your Numbers table), you don't need the CTE at all.
Change:
WHILE @@rowcount > 0
with Letters(Letter)
...
March 9, 2011 at 2:32 pm
Ghanta (3/9/2011)
they want mode as well as subsets...
March 9, 2011 at 1:46 pm
I would need to see the actual code you're using before I could tell you what to do to fix a syntax error.
March 9, 2011 at 1:44 pm
There are advantages over a delimited list beyond just avoiding having to first concatenate the list together and then shred it back apart again.
First, the table variable has a defined...
March 9, 2011 at 1:42 pm
Viewing 15 posts - 4,651 through 4,665 (of 14,953 total)