Lowell

Forum Replies Created

Viewing 15 posts - 10,456 through 10,470 (of 13,460 total)

RE: Linked Server MERG data

blawrence (9/30/2009)
Hi Lowell,
All is perfection!
Thank you again and again, you have been an amazing help through this endeavor. You have been crystal clear in your explanations. Thank you again for...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 30, 2009 at 8:00 am

#1059958
RE: Not able to reverse engineering over a database

I had also tripped over the same issue and if the following assumptions are true, this script might help:
the first column of the table is a sinlge column PK, identity...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 30, 2009 at 5:37 am

#1059883
RE: Linked Server MERG data

as you get more familar with SQL, you'ss see that any column can bbe replaced with a hardcoded value, and vice vers in just about any SQL:
this is the enhanced...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 29, 2009 at 2:05 pm

#1059713
RE: Linked Server MERG data

instead of using the column name [fphone], simply change it to the static value of '1':
MyLinkedServer.PhoneNumber2 = '1'
your code seems to be doing stuff differently....are you updating the Linkedserver...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 29, 2009 at 10:58 am

#1059615
RE: Enabling traceflag 1222

AFAIK, you trace flag(s) will remain in place until you stop the service...when you stop and restart, only the flags that are part of the command line for starting the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 29, 2009 at 9:24 am

#1059549
RE: Linked Server MERG data

this one is specific to the data:
ISNULL(MyLinkedServer.Initial,'A') AS fmi,
your original data source has what i though is the middle initial of the name, right? (if that's wrong, let...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 29, 2009 at 9:20 am

#1059546
RE: Linked Server MERG data

easy enough.
Stripping preceeding zeros, you just convert to int.
for the rest, here's an example:
--results:
exString ...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 29, 2009 at 9:10 am

#1059542
RE: Linked Server MERG data

[ code] --a sql comment [ /code ] <-- with no spaces makes your code become syntax highlighted
--a sql comment
if you are using preceeding zeros, when you...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 28, 2009 at 8:33 pm

#1059292
RE: Linked Server MERG data

a huge help, thanks for the layout!
try this query..it has all the defaults you were looking for. if the query works, uncomment the INSERT portion and confirm that that peice...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 28, 2009 at 11:11 am

#1059104
RE: Monitoring a Table/ Log for a table

Greg Charles (9/28/2009)
You could also query the log file written by the default trace, a background trace that runs in SQL 2005. See "Default Trace" in BOL or search...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 28, 2009 at 9:22 am

#1059047
RE: How to open XML file from a website using xp_cmdshell

bad form!
do not post the same question multiple times!
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts"...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 27, 2009 at 5:15 pm

#1058878
RE: Linked Server MERG data

you cross posted across a few forums...the first being a SQL 2000 forum.
The MERGE keyword is for SQL 2008 only, but all the same process can be duplicated with INSERT...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 27, 2009 at 1:03 pm

#1058867
RE: Linked Server MERGE data

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:
Linked...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 27, 2009 at 12:49 pm

#1058865
RE: Linked Server MERGE

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:
Linked...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 27, 2009 at 12:49 pm

#1058864
RE: Linked Server MERG Data

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:
Linked...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

September 27, 2009 at 12:49 pm

#1058863

Viewing 15 posts - 10,456 through 10,470 (of 13,460 total)