Search:
Type: Posts; User: chapran
Search:
Search took 0.05 seconds.
-
September 11th, 2020, 07:59 AM
The reason was found. Query Store General/Operation Modes settings were Off, then somebody changed them to Read write with Stale Query Treshold = 30 days. Then probably somebody ran some queries the...
-
September 10th, 2020, 07:42 PM
Schema and data. I also tried to split the file using online service. I created 10 files, and tried to run them one by one. First of all the first file took more than 10 minutes and finished with a...
-
September 10th, 2020, 09:00 AM
Something happened to the SQL Server 2017 database size recently. I was 400MB and in one day it doubled its size.
When exactly and why it happened nobody knows. The size of each table remains almost...
-
The previous attempt has frm, the last one is correct, no typo.
Thank you
-
I'm trying to implement VB.Net scenario in C#.
In VB.Net I have an MDI application with MDI form and several child forms.
MDI has a List Bar control on the left.
Child forms load and occupying the...
-
December 3rd, 2019, 08:03 AM
Sorry I do not understand your advice. Would you please give more details.
Thank you
-
December 2nd, 2019, 12:25 PM
I need to create a select statement to get the list of PartialID with corresponding CommissionSplitPercent
There is no direct relation between these values. This is my attempt graphically:
35765...
-
June 12th, 2019, 10:34 AM
Thank you very much for your help
-
June 12th, 2019, 10:00 AM
Can you tell me if using ##TempTable is a bad way? If it is the same as #TempTable then I'm fine and wouldn't want to fight with this stuff anymore because my main area is VB6 development. SQL Server...
-
June 12th, 2019, 09:24 AM
I cannot do this because I have dynamic selection (see my initial code).
Thank you
-
June 12th, 2019, 08:45 AM
I get this:
Msg 208, Level 16, State 1, Procedure dbo.USP_TestTempTable, Line 11 [Batch Start Line 2]
Invalid object name 'Status'.
I understand that I have to have the table Status. It...
-
June 12th, 2019, 07:55 AM
Any table I tried - Num, #TempTable and ##TempTable are used once. Num and ##TempTable work fine, #TempTable doesn't.
Thank you
-
June 11th, 2019, 04:57 PM
Sorry, but the sources I was working with say that the table may be created and populated with SELECT INTO, like my working code does:
SET @sql = N'SELECT TOP ' + CAST(@QtyOfDays AS varchar(5)) +...
-
June 11th, 2019, 07:46 AM
Right here by using SELECT INTO:
----Create Num table just for populating #Dates with all dates
SET @sql = N'SELECT TOP ' + CAST(@QtyOfDays AS varchar(5)) + N' n = IDENTITY(INT, 1, 1) INTO...
-
June 10th, 2019, 07:28 PM
Replace regular table with temporary in SQL Server
I have a stored procedure which has this code at the beginning (it is simplified to make it easier to understand)
ALTER PROCEDURE...
-
Doing research on internet I found some script allowing to see some settings. The difference I already see: On the production server the edition of SQL Server is standard, on my workstation it is...
-
My company upgraded SQL Server from 2008 R2 to 2017. I did the same upgrade on my development machine. Since that when I run VB6 program some processes produce errors on my local workstation with...
-
March 18th, 2019, 08:52 AM
My VB6 application communicates with Intuit QuickBooks desktop via special version of XML language qbXML. The application contains a pretty big number of procedures to send and receive data to and...
-
October 19th, 2018, 04:23 PM
Thank you. It looks to complex to work with variable table in my case - a lot of parameters and many tables are used in selections and filters. Variable tables are visible inside of dynamic string,...
-
October 19th, 2018, 02:48 PM
I have this in stored Procedure:
DECLARE @1_Main TABLE (JobID int)
--I create dynamic sql:
If Not(@JobNumber Is Null)
BEGIN
SET @sql = N'
-
October 18th, 2018, 08:35 PM
2008 R2.
As I know table variables are supported. I know nothing about table expression.
Thank you
-
October 18th, 2018, 03:06 PM
Sorry for the delay. I had to finish and test to be sure that it works properly. The solution for AND I created looks like this:
If Not(@JobNumber Is Null)
BEGIN
SET @sql = N'...
-
October 16th, 2018, 09:27 AM
-
October 15th, 2018, 05:30 PM
By some reason the button for code tag disappeared from my page. Next time I'll try to add manually.
One more thing:
The request was made more complex - users want to have the ability to set search...
-
October 15th, 2018, 03:27 PM
It looks like this now and it works. I just need to rewrite all IFs:
If @DontDisplayArchivedData = 0
BEGIN
If Not(@JobNumber Is Null)
BEGIN
SET @sql = N'
SELECT JobID
FROM...
|
Click Here to Expand Forum to Full Width
|