Viewing 15 posts - 136 through 150 (of 2,893 total)
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
"...I work on sql server 2019 ..."
Post in the SQL 2019 area next time. It's more visible, and others who are familiar with 2019 will see it.
March 4, 2022 at 6:04 pm
( Internet Translate ) Hello
I have a trace that saves in a table and triggered from sql profiler of my local instance but queries a production server (it traces all...
March 3, 2022 at 4:03 pm
It might be a good idea to take differential backups until you resolve the problem with full backups.
You could even add it as a job step, to run only if...
March 1, 2022 at 5:40 pm
Viewing 15 posts - 136 through 150 (of 2,893 total)