CASE with OPTION (RECOMPILE) and dynamic SQL are the go-to solutions here, as Erland also concludes.
00:00 - 23:0023:00 - 00:00
Correct - community wiki is stripped during migration. Normal rules on the destination site apply, so the question may get auto-converted to CW again - however these checks are done when a new answer is submitted.
One of the reasons we're so strict about VLQ is that it's being used for Audits.
It's still useful to keep around for answers, but it has a very high threshold (as you point out) it has to meet to being marked 'helpful' by a moderator.
Should it be this way? Yes and no. We need a way to alert...
99
Try This:-
DECLARE @intFlag INT
SET @intFlag = 0
WHILE (@intFlag <=5)
BEGIN
begin Try
if @intFlag = 3
begin
SET @intFlag = @intFlag + 'A'
End
Else
begin
PRINT @intFlag
end
End Try
Begin Catch
--print 'Error...2
Recently, a question from SuperUser was migrated to Arqade. The user that posted the question, however, was unregistered and did not have an Arqade account. As a result, some strange things happened. First, look at the picture. See anything missing?
Second, when you open the question to look at ...
The number of up-votes shows the level of acceptance by the community.
If the "accepted answer" has no up-votes, but yours has 12, clearly yours is the community-accepted answer :)
I want to update a table's all columns values from another table, but it doesn't work.
I get this syntax error:
You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use
near 'FROM silinecek s WHERE frameworkcode I...
I've had a complex issue involving strange wait types, VM ware, deadlocks,existing code and more. I've done in depth analysis and I think I've figured it out based on a ton of research.
I'd like to sort of open it up to see if I've missed anything or I'm just plain wrong in my statement regar...
The following query gives me the error
Incorrect syntax near 'OUTPUT'.
SELECT * FROM dbo.sales ;
OUTPUT USING 'Driver=Microsoft Excel Driver (*.xls);
DBQ=c:\\test\\sales.xls;
READONLY=0' INTO "newSalesData"
I know about the Import/Export Wizard and also about using Copy/Copy with Headers...
I don't see any problem with posting it as a question at the site. We love complex issues!
Depending on how sure you are about your analysis results:
if you are not very sure about your findings:
one question with two parts (within the question): the problem and your analysis/results.
Others ...
Sample data:
id|location|date
1|TUNDUMA |16/8/2015
2|TUNDUMA |16/8/2015
3|TUNDUMA |17/8/2015
4|TUNDUMA |18/8/2015
5|TUNDUMA |19/8/2015
Is it possible to count the number of consecutive days for TUNDUMA?
Something like:
TUNDUMA -> 4 days
Use DatePart to extract the Month and Year adding in the day manually.
Something like:
SELECT * FROM [MarkTSK]
WHERE Convert(date, DatePart('yyyy', [MonthlyDt]) + DatePart('mm', [MonthlyDt]) + '01' ) IS NOT NULL
(Disclaimer: untested code)
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GO
DECLARE @hostname nvarchar(20) = 'your_host',
@cmd nvarchar(20)
SET @cmd = 'ping ' + @hostname
EXEC master.dbo.xp_cmdshell @cmd
I have to transfer table 'USERS001' from schema SOURCE to schema DESTINATION. Table 'USERS001' contains 3 million entries. I want to use python script to transfer data in chunks. what is the procedure and python script to do this ?
Just to get these out of the way:
Technically speaking, both of these options are "dynamic" / ad hoc queries that are not parsed / validated until they are submitted. And both are susceptible to SQL Injection since they are not parameterized (though with the SQLCMD scripts, if you are passing i...
3
I have a student attendance table.
Fields/data sample
id | studid | smonth | syear | total_p | total_a
1 | 20 | 08 | 2015 | 1 | 0
2 | 21 | 08 | 2015 | 0 | 1
3 | 22 | 08 | 2015 | 1 | 0
Those are the first entered values. Then I again enter ...
I have a table student attendance.
Fields/data sample
id | studid | smonth | syear | total_p | total_a
1 | 20 | 08 | 2015 | 1 | 0
2 | 21 | 08 | 2015 | 0 | 1
3 | 22 | 08 | 2015 | 1 | 0
this is the list entered values. then I am again enter ...
00:00 - 23:0023:00 - 00:00
