rakkpra (2/1/2011)

---

Hi Lowell

We have a History table but like Emp is my current table and EmpHistory is our History table .

Emp Table only have current table and EmpHistory...

do you have a table that does an audit or history for when someone changes their title?

so if i got promoted to "Developer 3" , is that stored in a...

not sure buddy; from what you described, the first two queries (i thought) would return something; can you show us the actual queries you tested with?

what is the datatype of...

ouch; looks like a varchar column is being used to hold dates, instead of a datetime datatype; i've inherited a few of those situations myself.

one of the first things you...

SELECT @CountOUT = COUNT(*) FROM [' + @REMSServer + '].rems.dbo.[Order

the above string is exactly 70 characters; if @SQLString is too small, it'd truncate and give that error message. what...

I'm asking you to think outside of the box for a moment. you seem to be locked into one method, and i'm suggesting an alternative.

it looks to me like you...

if it fails on only one procedure, i'd just fix it manually and be done.

Are you sure this is something that must run in all situations, or is this just...

what you want to do is to use the DATEADD function, which allows you to add to an existing datetime value.

in the below example, i'm adding hours (hh); note i...

store the latitude and longitude in decimal form only.

it's trivial to convert the decimal to the long syntax, but very difficult to do it back from text to decimal...lots of...

i was under the impression that simple CONNECT rights gives you access to creating objects in tempdb, and the same for at least reading tables in the master database(sys.objects, etc).

to...

in the past, i've used a rowversion as a semaphore column to designate that a row has not changed since the last time it was downloaded.

in some rare cases where...

here's a complete example you can use as a model:

-==snip oops it had a CTE in it; rewriting it... hang on

a datatable is a local object that exists in memory until you call UpdateDataTable from your DataAdapter, which would synchronize any changes....

typically you would use a typed dataset that has...

simply restore the backup with a different database name.

so for example, you could create the database SandBox, and then restore that db with the backup from "PRODUCTION", or you can...

i believe CONNECT privileges automatically gives you rights to tempdb,so because of that you can create a temp table.

so you could insert data into a temp table, which would not...