Viewing 15 posts - 1 through 15 (of 50 total)
Look at the files on the drive and see if there is a large, obsolete file(s) (perhaps old backups?).
Depending on the version of SQL Server, you might...
December 8, 2023 at 3:47 am
Look at the files on the drive and see if there is a large, obsolete file(s) (perhaps old backups?).
Depending on the version of SQL Server, you might also be...
December 8, 2023 at 2:41 am
thanks for all the reponses!
Do you have any other local drives with available space?
Yes, I do. This is my work machine and I connect through a virtual machine. I...
December 7, 2023 at 9:02 pm
<!--more-->It isn't anything complex that I write which causes the error. Just a simple
select column a,b,c,d from TableName
The table is pretty large
December 7, 2023 at 12:46 pm
assuming you are using US formats you can do
select convert(decimal(10, 2), parse('$16,500.50' as money using 'en-US'))
thanks this worked. I tweaked it by using try_parse as there are non-numeric values...
September 20, 2022 at 9:33 am
I did it using a double replace. But wondering if there is a cleaner way to do it
select TRY_CONVERT(decimal (10,2),REPLACE(REPLACE('$16,500.50','$',''),',','') )
September 20, 2022 at 8:04 am
It would be much better for you to go back to the sender and have them send that data in an unambiguous format. I get that some senders refuse...
September 12, 2022 at 9:27 pm
IF you add the statement
SET DATEFORMAT DMY;
before you attempt the INSERT, the error will go away and the INSERT runs successfully.
Although this is an option - don't...
September 11, 2022 at 9:34 pm
sp_helplanguage @@Language
Once you have that, look at the 2nd column titled "dateformat"... that will tell you what the "default" format is for "punctuated dates". There's a...
September 11, 2022 at 5:58 am
jcelko212's post got me thinking
I tried to change the datatype of the paydate column to date by using the alter command but ended up getting this error
"Conversion failed when converting...
September 11, 2022 at 12:55 am
Please learn what a table is. First, we need to fix your non-table.
Thanks for your "constructive" criticism of my dummy data and code which I provided. Even though I...
September 10, 2022 at 10:31 pm
Thanks for the almost instant response! It worked like a charm!
I didn't know using the IN statement in an IIF condition was even possible ( I have to admit, I...
September 4, 2022 at 10:13 am
Thanks Phil. This does the job
I modified my pivot code by replacing the count with Max. This results in a text in the flag values instead of the 1 or...
September 4, 2022 at 10:00 am
I believe that this does close to what you are looking for. It can probably be massaged to do exactly what you want. The big problem is that the...
September 2, 2022 at 8:55 am
Viewing 15 posts - 1 through 15 (of 50 total)