pwalter83

Forum Replies Created

Viewing 15 posts - 181 through 195 (of 541 total)

RE: Issue with duplicate data

no issues.

January 27, 2014 at 7:38 am

#1683546
RE: Condition requirement

Sean Lange (9/4/2013)
pwalter83 (9/4/2013)
Sean Lange (9/3/2013)
You seem to have forgotten the ddl. Even if the tables were provided it really isn't very clear what you are trying to do here....

September 6, 2013 at 3:05 am

#1647957
RE: Condition requirement

ScottPletcher (9/3/2013)
Something like below. It's possible you only need one left join, depending on the specific data in your tables:
SELECT
CASE WHEN b_out.Continent_cd IS NOT NULL...

September 6, 2013 at 3:04 am

#1647956
RE: Condition requirement

Sean Lange (9/3/2013)
You seem to have forgotten the ddl. Even if the tables were provided it really isn't very clear what you are trying to do here. Can you try...

September 4, 2013 at 2:51 am

#1647214
RE: iif condition

Koen Verbeeck (8/27/2013)
=iif(Fields!FROM_LOC3.Value = "", iif(Fields!FROM_LOC2.Value = "", Fields!FROM_LOC1.Value, Fields!FROM_LOC2.Value), Fields!FROM_LOC3.Value)
That worked !! thanks very much for your help.

August 27, 2013 at 5:27 am

#1645121
RE: Update table values if corresponding values change in another table

ChrisM@Work (8/16/2013)
pwalter83 (8/16/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The reason is...

August 16, 2013 at 7:30 am

#1642169
RE: Update table values if corresponding values change in another table

ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The reason is - The...

August 16, 2013 at 6:32 am

#1642126
RE: Update table values if corresponding values change in another table

Sean Lange (7/29/2013)
Since you started a new thread and Chris pointed me back to this one I will post here.
I would agree that trying to keep this data in multiple...

July 31, 2013 at 9:13 am

#1637424
RE: Update table values if corresponding values change in another table

ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The...

July 24, 2013 at 8:34 am

#1635381
RE: Update table values if corresponding values change in another table

Lowell (7/24/2013)
pwalter83 (7/24/2013)
Thanks Lowell,
However, I was wondering is it not possible to implement this logic within the table structure because as I mentioned earlier, the values in one table would...

July 24, 2013 at 8:31 am

#1635379
RE: Update table values if corresponding values change in another table

ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The reason is...

July 24, 2013 at 8:11 am

#1635368
RE: Update table values if corresponding values change in another table

ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The reason is - The...

July 24, 2013 at 7:43 am

#1635355
RE: Update table values if corresponding values change in another table

ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The reason is - The same data...

July 24, 2013 at 5:52 am

#1635310
RE: Update table values if corresponding values change in another table

Lowell (7/24/2013)
pwalter83 (7/24/2013)
Hi,
I am very new to SQL and really dont know how to phrase my question.
There are 2 tables linked through a primary key and if the values...

July 24, 2013 at 5:26 am

#1635301
RE: Using SET IDENTITY_INSERT with trigger

Lowell (4/24/2013)
ok, i'll skip the peer review and go straight to the error you are tripping over:
your error was pure syntax.
the SET IDENTITY_INSERT must be inside the body of the...

April 24, 2013 at 8:45 am

#1609552

Viewing 15 posts - 181 through 195 (of 541 total)