drew.allen (5/30/2012)

---

dwain.c (5/29/2012)

---

Datetime functions do have their issues though, like the following:

SELECT DATEADD(month, 1, '2012-02-29')

Depending on your point of view, the results this returns looks wrong, or maybe not. ...

I wonder if its something like:

"By setting the useDomainNameAsHostName attribute to true, you can specify the virtual host and user name by using domain name syntax; this lets you use...

You should probably repost the code you're currently trying to get to work! Also, you could post sample ddl that would help folks play with the code and especially duplicate...

SSRS Newbie (7/30/2015)

---

ZZartin- I ran the 4 queries you suggested. I was able to truncate the destination database on the new server successfully. It shows the same number of rows...

SSRS Newbie, how much experience do you have producing SQL programs?

SSRS Newbie (7/30/2015)

---

ZZartin- I ran below script on my new SQL server using LinkedServers. The tables did not update. I mean I checked few tables. The number of rows in...

SSRS Newbie (7/29/2015)

---

ZZartin- I appreciate your response. I've 25 tables in the database that has to be moved over to the new server. I already have the database restored on...

inside your subquery, it looks like you are limitting the "LKC.seq" to 1 in order for LockCombination to be joined in (and thus LKC.seq to have a value in your...

GoofyGuy (7/29/2015)

---

... under no circumstances can [the US Constitution] be ignored or interpreted by the Executive branch, a State, or a branch of government like the Justice Department, Department of...

Lynn Pettis (7/28/2015)

---

Okay, obviously you are set on doing this using a loop instead of taking an opportunity to see if there may be a better way to accomplish the...

Yep, go with Seans approach, much better than mine!

The only thing I would add would be to try to maintain the associations between the label and the value.

edit: Just wanted...

Sean Lange (7/29/2015)

---

Not much detail here...

GeorgeCopeland (7/24/2015)

---

jckfla (7/24/2015)

---

It's like with Windows 8, 8.1, and 10. They want me to have a touchscreen PC. Why would I want to move my hand all the...

don't include the *'s if they aren't part of your password LOL

Is userx a user in both databases? Just wondering!