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...

does this query from technet, which purportedly gets cluster information by reading the registry and other items via TSQL help?

COLLECT CLUSTER INFORMATION USING TSQL

i see it identifies node names and...

profiler is resource intensive, no matter the SQL version.

consider this:

there is nothing a slow, resource intensive profiler trace can do that a server side trace cannot do.

EVERY client side trace...

that error is normal, because you cannot execute as the context of a windows group, only as a windows user, who happens to be in that group.

balasach82 (1/2/2014)

---

I have to create a new role which should have "Select" permission on all tables created by other users and

2.should have ability to create tables and have access to...

can you add CLR procedures?

writing to a file is very, very easy if you add some CLR's;

i've got a simple example out on codeplex that i wrote as a proof...