Pretty sure you are not going to find much feedback for two reasons.

1) Your question does not really have anything to do with sql server.

2) There is no clear...

most likely you have multiple records for each ticket id in the additional tables like TICKET_LOCATE_INFO or any of the other tables.

Are you sure the db is only returning 1,000 characters and the limitation is not in the tool you are using? SSMS limits the max amount of text per column...

Agreed that this looks like a query for a report but the column names make me cringe [zip_ZIP_TransportationCommuteToWork15To29min]. Thankfully this is 2008 so there is some intellisense. This would be...

:w00t::w00t::w00t::w00t::w00t::w00t:

Yes chock that one as one of the worst ever!!! Maintain??? I would rather take out my eyeballs to pop them!!!

Although that does seem a bit excessive I would not just assume because the query is long winded that it is horrible. In fact, the query itself needs to be...

Not totally sure what you mean by these drivers and such but if you can view these tables through your linkserver there should be no issue coming from vb.net. SSMS...

try this, it could be cleaned up and made a little simpler but this just adds an isnull to the version you posted. 😉

select isnull(SUBSTRING(ServerName, 1, NULLIF(CHARINDEX('.', ServerName) - 1,...

Is the sql server service running?

Please do not cross post...it will only water down the help you receive.

Please view the original post here.

http://www.sqlservercentral.com/Forums/Forum1292-1.aspx

Of course this is only one way of encrypting data. It really depends on what you are trying to encrypt and why. For example, this method of encryption is not...

np hope it works. 😀

ok i get what you are trying to do.

Have you thought about triggers? You could maybe add an insert trigger the MainInformation and Locations tables. You would probably need...

So does this copy of the data need to stay around? Or are you using it for a little while and then dumping it. Is this like the user goes...

Could you use global temp tables or does the copy need to persist? I am sure there are some really slick ways to do this quickly sans cursor but like...