Viewing 15 posts - 976 through 990 (of 13,849 total)
Does the antivirus software you use have a CLI?
You could write a script task in C#, VB.Net to interact with your AV and call it to scan the file...
April 12, 2023 at 11:01 am
That is not easy! This gets you part of the way, but the MultiValue bit is missing:
DROP TABLE IF EXISTS #XML_TABLE;
CREATE TABLE #XML_TABLE
(
ProductID...
April 9, 2023 at 9:40 am
It's difficult to help without seeing the actual execution plan and the DDL for StockDB (assuming that is a table rather than a database!)
For a quick fix, try the divide...
April 9, 2023 at 7:55 am
The database was working on copy (SQL server 2008) and now it is not working on copy (SQL server 2014) and I get error number (0xc0202009)
Please explain what you mean...
April 3, 2023 at 12:20 pm
Thanks for all replies!!
Will test out Emperor100 solution. Just need a way to update the sp's that use this table structure when new month starts.
The synonym suggestion avoids the...
April 3, 2023 at 10:24 am
You say this:
The database is intact and there is no error in it because it was working in copy (ٍَSQL server 2008)
which suggests that you were able to migrate the...
April 3, 2023 at 10:16 am
Scott's synonym suggestion sounds like your best bet to me.
March 31, 2023 at 4:38 pm
The output you get from your query is the same as
SELECT 'MERGE ' + dc.ChannelReadingTableName + ' USING ' + dc.MainLevelDataTableName
FROM #DeviceChannel dc;
March 31, 2023 at 11:57 am
'Get to the last record' still makes no sense to me. Once again, I suggest you provide the output you are hoping for.
March 31, 2023 at 11:37 am
Not sure what you mean by 'Complete at the last record'. What results are you hoping to see?
I want to get to the last record
but i thinik ive...
March 31, 2023 at 11:35 am
Not sure what you mean by 'Complete at the last record'. What results are you hoping to see?
March 31, 2023 at 11:18 am
Here is a version with a sequence number which you should be able to adapt
DROP TABLE IF EXISTS #Leave;
CREATE TABLE #Leave
(
EmployeeId INT
...
March 30, 2023 at 3:23 pm
The sample data you have provided has no column which provides ordering. Without a column to order by, a T-SQL solution is not possible.
March 30, 2023 at 3:08 pm
Compare the execution plans in both environments. Are they identical?
Are the hardware, o/s and SQL Server versions the same?
Have you checked for blocking?
March 30, 2023 at 8:06 am
Does your view definition include 'WITH SCHEMABINDING'?
March 28, 2023 at 8:29 am
Viewing 15 posts - 976 through 990 (of 13,849 total)