well remember floats are stored as approximations, so i'd suspect witht eh full details, that's where the issue lies.

SQL

with the one exampel you offered, i don't see anything specific...

are you sure it's an inline TVF? if you are in the database you know it exists, what does this return?

select type,* from sys.objects where name='getuserrelations'

can you start sending differentials or transaction logs to the other site instead of full backups, and start doing incrementals restores there instead?

this is one of the ramificaitons of having the "universal" lookup table instead of one lookup table for each logical group of values.

to do what you are asking, you need...

since MySQL is preventing you from multiple UNIONs, you'll end up having to insert into a temp table (MySQL has temp tables, right?

3 unions would be three inserts, all into...

bcp.exe requires a MS operating system....so you can't call bcp.exe from a unix operating system....

but you can bcp a FILE into or out of a shared directory that exists on...

I'm thinking it's because of statisitcs..the plan itself is fine, but the statistics used get more and more out of date as that 10% per day occurs.

when you recompile...

okbangas (10/21/2011)

---

Quick and dirty "right direction":

You'll have to have some kind of table controlling user info and access. Then you would typically use suser_name() in your query to retrieve the...

In addition to what my friend here psoted, I usually start with this inside an auditing trigger, and add additional columns,...

steveb. (10/21/2011)

---

you can filter on loginname to exclude those ones you dont want.

Though i have to say writing this kind of function into your server could cause issues, ...

i believe the issue is this;

FOR XML PATH('tr'), TYPE)

in that case, TYPE escapes out all the brackets (less than,greaterthan, quotes, etc) that would have been HTML.

FOR XML PATH('tr'))

will leave...

you can use the .NET Frameworks SQLBulkCopy object , and use that to load via bulk copy, but not BULK INSERT command; that requires you to have already organized the...

in C#.Ner or VB.Net, it's built into the Striigs Class

Dim MyArray() As String = AnyStringObject.Split(",")

the coalesce statement is what you are after; it accepts a param array of values(meaning no limit on the number of values to test), and returns the first non-null value

SELECT...

I'd say its a permissions issue, since the bat file works from a command window.

this is a common security misconception/"gotcha". The problem is that when you access any resource OUTSIDE...