from the page you posted, someone suggested this code

SELECT *

FROM

[dbo].bookPageFromAddress(@address) addresses

outer apply [dbo].[imageFileFromBookPage](addresses.Book, addresses.Page) foo

you said it didn't work, but didn't say why, or whether you...

i think the key on the error is Level 19 that's a really high error number; I'd bet the lock is waiting on the database growing and getting more space...

It seems like most of the time i'm tuning, i have a specific query plan , either from a query, a procedure, or from the cache when i checking top...

just had the same issue on a database hosted on a web server.

the database was limited to 250 meg, and not allowed to auto grow.

check the properties of the database,...

here's my first guess on what you are after...some SUM(CASE statements to get your subtotals:

SELECT SUM(CASE

WHEN prd_cd='1'...

since you want date elements that are related to the same row where your max() is found, i think you want to use row_number with partition to organize the...

JohnFTamburo (1/3/2014)

---

I thought that this was the case, but apparently you need more oomph than that.

Testing this from a SQL login that is not a sysadmin...

tnt750 (1/3/2014)

---

hi all

i have a username and password of the instance sqlserver 2008 in a web server

i want create a admin user or hack this server

please help...

I believe in that case, you want to load all the files associated to a trace, instead of individual files.

I typically create a view for every trace i have to...

it would be much, much easier to add indexes and modify the code in your trigger to perform better, instead of trying to second guess what the optimizer is doing...

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic1527490-147-1.aspx

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:

http://www.sqlservercentral.com/Forums/Topic1527490-147-1.aspx

where did you download your current shape files?

did you check to see if they had updated versions there?

did you try searching for anything?

https://www.google.com/search?q=geospatial+shape+files+sudan

Ok Sean, I'm revisiting your ITVF version of this function, and seem to have a problem with it when the data does not have the data at the assumed index;

rub...

pujain (1/3/2014)

---

Thanks for your replies.

why I need this much of data : This is the requirement by Higher management for some analysis purpose, I know this much of data is...