Viewing 15 posts - 2,401 through 2,415 (of 14,953 total)
I'd query each account number, and then cross apply to get the date with the most records for each.
December 29, 2011 at 1:40 pm
Evil Kraig F (12/29/2011)
GSquared (12/29/2011)
I don't think WriteText/UpdateText work on the (max) datatypes. They do work on Image, but you're right that it's unusual to do so.
True, good catch....
December 29, 2011 at 1:13 pm
I don't think WriteText/UpdateText work on the (max) datatypes. They do work on Image, but you're right that it's unusual to do so.
December 29, 2011 at 1:08 pm
krishusavalia (12/29/2011)
Thanks for your response.But How Can I pass the values of temp table to the store procedure?
How many values are you looking at and what SQL Server version? ...
December 29, 2011 at 12:29 pm
Brian.cs (12/29/2011)
GSquared (12/29/2011)
patrickmcginnis59 (12/29/2011)
Brian.cs (12/29/2011)
RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms should...
December 29, 2011 at 12:08 pm
Brandie Tarvin (12/29/2011)
GSquared (12/29/2011)
Brandie Tarvin (12/29/2011)
December 29, 2011 at 11:49 am
GilaMonster (12/29/2011)
David Moutray (12/29/2011)
December 29, 2011 at 11:45 am
Stefan Krzywicki (12/29/2011)
Revenant (12/29/2011)
Brandie Tarvin (12/29/2011)
December 29, 2011 at 11:43 am
When I need to read from one table and write to another, but can't do it in a single query.
I've had to do that in a couple of complex queries...
December 29, 2011 at 11:32 am
David Moutray (12/29/2011)
GSquared (12/29/2011)
patrickmcginnis59 (12/29/2011)
Brian.cs (12/29/2011)
RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms...
December 29, 2011 at 11:26 am
Brandie Tarvin (12/29/2011)
December 29, 2011 at 11:17 am
Fraggle-805517 (12/29/2011)
December 29, 2011 at 11:15 am
patrickmcginnis59 (12/29/2011)
Brian.cs (12/29/2011)
RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms should support. Locking...
December 29, 2011 at 11:12 am
Grant Fritchey (12/29/2011)
Stefan Krzywicki (12/29/2011)
GilaMonster (12/29/2011)
Stefan Krzywicki (12/29/2011)
I don't have room on my machine either.Two words: External harddrive.
Seriously, I've had to do that once or twice.
I can't even get them...
December 29, 2011 at 10:28 am
GilaMonster (12/29/2011)
GSquared (12/29/2011)
Stefan Krzywicki (12/29/2011)
December 29, 2011 at 9:58 am
Viewing 15 posts - 2,401 through 2,415 (of 14,953 total)