Viewing 15 posts - 136 through 150 (of 2,897 total)
Backup DB1 database, and restore the entire database to DB2 ? Use backup compression, then copy the file to restore location. If you have objects unique to DB2, this will...
March 30, 2022 at 3:32 pm
What are you trying to solve ?
An "uncritical" procedure that runs at end of day taking 24 seconds doesn't really sound like a problem.
I had a long running procedure once...
March 30, 2022 at 2:57 pm
If step 4 fails, in the setting of the step, can you simply set it to go to step 1?
Of course, you run the risk of going in an...
March 28, 2022 at 4:12 pm
below is to get business hours data
SELECT * FROM #TEMP WHERE CAST(LOADDATE AS TIME) BETWEEN '9:00:00' AND '17:59:59'
Thanks for your help
My recommendation is to get out of the...
March 25, 2022 at 7:34 pm
Import the CSV into a temporary table in SQL.
You can use the "Import Flat File" database "Task" to step through the import process.
Then write your Update query based on the...
March 24, 2022 at 1:21 pm
I'm not sure that helps me.
If you notice in my example the 3rd column header has double quotes but the data for column 3 does not.
I think it will...
March 23, 2022 at 6:37 pm
We have a Lookup table containing fiscal year dates and fiscal period dates.
We then use that table to determine what dates to use in programs.
March 21, 2022 at 8:54 pm
We need a reference value to see which scripts has a high popularity because we didnt want to search in more than thousand scripts. We only want the scripts...
March 21, 2022 at 1:38 pm
Is your system already up and running, or are you in the process of configuring ?
If it's already up & running, and you do not have performance problems, leave it...
March 16, 2022 at 5:45 pm
Could be a multi-checkbox type question.
March 15, 2022 at 1:26 pm
What test are you taking ?
Is this a pre-spam practice post ?
March 14, 2022 at 7:37 pm
Or maybe you could be less rude to someone who replied with a suggestion, despite your post not having much information.
The best answers usually are to posts that clearly explain...
March 11, 2022 at 4:15 pm
What happens if you click on Administration "Schemas" below your '?'
Search out a MySql discussion forum.
March 10, 2022 at 5:29 pm
Looks like a poorly worded homework question, with half the information missing.
March 9, 2022 at 2:09 pm
Just a thought, start by importing the file as all character columns, then analyse the data and reconstruct the target table. 😎 I don't like the Import AND Export...
March 7, 2022 at 9:53 pm
Viewing 15 posts - 136 through 150 (of 2,897 total)