Viewing 15 posts - 916 through 930 (of 6,678 total)
no need for further variables.
just do the conversion in sql
delete from T1 where date_cr between convert(int, ?) and convert(int, ?)
Or - just let SQL implicitly convert them to integer. ...
July 4, 2021 at 4:08 pm
While a Calendar table will certainly work, a little (and I do mean very little) math can be used to solve this problem. Case in point...
--=====...
July 4, 2021 at 3:26 pm
One other note - probably not a performance issue. It appears you are storing entry_time as a datetimeoffset and want to return the time in 'Central Standard Time'. The datetimeoffset...
July 3, 2021 at 3:16 pm
It could be a NAS share - a separate drive on the server that is shared - a folder on a different server even. All depends on how you want...
July 2, 2021 at 5:55 pm
The error here is telling you the problem - it cannot open the file. It is looking for the file on your desktop on the C:\ drive - have you...
July 2, 2021 at 4:10 pm
YES!
"Nice to have: 2k years experience with DBCC TIMEWARP()."
And then sit back and see how many people actually respond. @=)
The smart ones will respond that they will have had...
July 1, 2021 at 8:56 pm
You can check the SQL Server logs - if the service is currently stopped then the last row in the log will tell you when it stopped. This should also...
July 1, 2021 at 8:50 pm
I find myself wanting to put in our DBCC Time() joke in the next wanted ad I help design (must have 2000 years experience!) but now I can't remember...
July 1, 2021 at 8:10 pm
I'll like to find a solution without loading the driver..
To do that you would need a file that can be opened using a driver that is already installed on...
July 1, 2021 at 3:55 pm
Nah... my bad, Jeffrey. I was hoping I was fast enough with my "takeback" but wasn't. I did some bad math. You're fine and my apologies for the incorrect...
June 30, 2021 at 10:28 pm
Check that users login - are they a member of the sysadmin role? Check other groups that have access to the server - do any of those groups have access...
June 30, 2021 at 9:30 pm
You might want to take a look at the execution plan for that. With just the 9 rows of data the OP posted, it does 48 table scans and...
June 30, 2021 at 9:11 pm
That is because you didn't export from Excel as pipe-delimited, you exported it as a CSV file. The problem here is that Excel uses the regional settings on the machine...
June 30, 2021 at 7:01 pm
Viewing 15 posts - 916 through 930 (of 6,678 total)