Right, but I unable to decrease the physical size of the file. When the DB was created it was created without a limit on the size of the trans log, as a result it kept growing to a size of 17gb. Generally, there only needs to be about 1gb of log space required for this db. I have truncated...
i had a mistake in my code...
try this
--=======================================
SELECT *
INTO ai_clien_prev
FROM ai_clien
WHERE tc_id IN (
SELECT DISTINCT a1.tc_id
FROM ai_clien a1
INNER JOIN ai_enc_prev a2
ON a1.tc_id = a2.tc_id)
--========================================
in your original query you were joining on "urs"."dbo"."ai_enc_prev" . I removed all of the qualifiers in the example that i responded with. try putting them back in to the example i gave you and remove the quotes.
the message you are getting indicates it is not seeing the table. it does...
try this...
SELECT Count(Q1)/COUNT(*) as Q1,
Count(Q2)/COUNT(*) as Q2,
Count(Q3)/COUNT(*) as Q3,
FROM questionaire
you may have to convert each into a float data type to be used in a percentage. ex. convert(float,count(q1))
you could try this...
SELECT *
INTO ai_clien_prev
FROM ai_clien
WHERE tc_id IN (
SELECT DISTINCT a1.tc_id
FROM ai_clien a1
INNER JOIN ai_enc_prev a2
ON ai_clien.tc_id = ai_enc_prev.tc_id)
trying to decrease the size of the trans log for a sql7 db. In sql 2000 the dbcc shrinkfile seems to actually descrease the size of the file when run after using the truncate log, but in sql7 running that same command does not seem to descrease the physical size of the file on the hard drive...
I would like to be able to branch from a 'task' based on a result from the database. Is there such a task where i can query the DB and return a result such as 1 or 0 and be able to branch one way or the other based on the result?
thanks
I created a macro then deleted it. Now everytime the excel document is opened it propmts the message to Enable or Disable macros as if it detected one. Even though i deleted the macro and I can not see any macros available to run it still reacts as if there is one.
How can one completely...
thanks for the leads on this.
I was actually able to resolve this issue straight from the BOL info for "bcp utlity". I was able to set the argument "-C 437" to indicate that the file being used has international characters.
If my codepage is set to 1252 and i was able to DTS data into the column with an umlaut, shouldnt that indicate that the DB be set correctly? I was going to try and change the collation on that column, but codepage 1252 should be able to accept umlauts.
So are there any ideas of what is...
your first question "what is the datatype of the field you are importing into?" clued me to try changing the datatype of the column from varchar to nvarchar. I tried that and it did not seem to solve the issue.
On a side note, I tried using DTS to perform the data import and was...
I am trying to bcp ascii data into sql from a .txt file that has characters such as umlaut. running the bcp statement from cmd line using the argument "-c", the characters change from an "ä" to ',,' (double comma). other characters experience similar changes. the code_page...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.