Forum Replies Created
Viewing 15 posts - 5,056 through 5,070 (of 6,036 total)
-
RE: Sql how to
Leave them their storage and create the right one in parallel.
Set up a trigger on their storage to syncronise both storages on every insert/update/delete.
Create a simple SELECT from right storage.
You...
-
RE: CURSOR FOR (Remove Comma, Create New Column)
Don't ask me.
I've got one DTS fan sitting 5 meters from me. He inbuilds in those DTS's unbelievable amount of fuctionality, 40 steps with 6 flow directions - is just...
-
RE: Formula field
CASE WHEN column1='x'
then formula
else 'value inserted from the application'
END
-
RE: CURSOR FOR (Remove Comma, Create New Column)
ohhh,
such a relieve!
You made my day!
-
RE: trigger error
Daryl, you overcomplicated the statement and made couple of mistakes.
CREATE trigger UpdateWinMasterDueList on dbo.[Manager_List]
for INSERT, UPDATE
as
begin
Update tblWinMasterDueList
SET Manager= i.Manager
FROM inserted i
WHERE tblWinMasterDueList.jobCostCenter = i.home_jobcost_nbr
end
And 2 Frances:
-
RE: CURSOR FOR (Remove Comma, Create New Column)
Again, for those who don't understand.
GET RID OF DTS!
You don't need DTS to create flat file.
Run you select from bcp command. Direct...
-
RE: Adding Foreign Key Constraint - Problem, probably syntax
Some Customer_ID in Notesdon't have correspsonding recpord amongst Customer_ID in Customer.
And they all should. Excluding NULL.
-
RE: CURSOR FOR (Remove Comma, Create New Column)
LuckyInc,
you are really lucky!
If it's all about flat file report you don't neet to do anything!
Just replace commas in string with delimiters you...
-
RE: Is this true? (Order by goof up)
nileshane,
you must ALWAYS have ORDER BY clause just before FOR XML EXPLICIT.
And this ORDER BY must contain node names, not column names in source tables.
And typically it will be big,...
-
RE: Creating text files for each row of the ouput
> for goodness sake, do not hardcode the user name and password in the code.
Is it your every day pray?
It's definetely mine.
Unfortunately it did not help much by now.
-
RE: Error Message:Cannot open database requested in login ''''databasename''''. Login fails.
You can find extended explanation and bunch of examples by just pressing "F1" in QA or EM.
-
RE: trigger help needed
You may call lots of procedures from your trigger. But first error appeared will roll back all executed commands, including INSERT into table, does not matter how deep you'll try...
-
RE: Is this true? (Order by goof up)
Have uilt hundreds of XMLs and never had problems with ORDER BY clause.
Only with building right resultset.
You probably mess column names in...
-
RE: trigger help needed
Trigger is a transaction by definition. If any error happens during trigger execution everything will be rolled back including INSERT/UPDATE/DELETE commited on table.
Remove all those toys BEGIN TRANSACTION /...
-
RE: CURSOR FOR (Remove Comma, Create New Column)
Same type, same nature and meaning values MUST BE STORED IN THE SAME COLUMN.
Follow the relational model rules and you'll avoid triubles.
Viewing 15 posts - 5,056 through 5,070 (of 6,036 total)