Lab Sql

I am checking one SSIS job execution report, which shows me the below report: The most recent one … Read more Sql Server Job Activity (job Failed But History Records In Job Activity Still Showing 'running' Status )

I have created one variable table. In my stored procedure, there are lots of transactions. Now wh… Read more Why Rollback Is Not Working For Variable Table In Sql Server 2012?

i want to select value from my database but i got error Caused by: java.lang.IllegalStateException… Read more Caused By: Java.lang.illegalstateexception: Get Field Slot From Row 0 Col -1 Failed

Possible Duplicate: Database design to create tables on the fly I have a need to create a databas… Read more Database Within A Database (table Design)

I am working in SSIS to fill a staging area database. I want to transfer the following data: ------… Read more How Can I Turn A String Into A Decimal In Ssis Using A Derived Column?

Django has the great new annotate() function for querysets. However I can't get it to work prop… Read more Django Annotate() Multiple Times Causes Wrong Answers

I have a temp table A having 2 columns col1: ID col2: Value generated using XML. I need to update t… Read more Updating Values In One Table From Another Table Using Dynamic Sql In Mssql

Latest version of Excel M365 and SQL Server 2017. I have a stored procedure which takes a date as i… Read more Power Query Data Type Conversion Issue Running Sql Server Stored Procedure

I have a certain request to read/parse the .xel file which is extended events file , How can I do t… Read more How To Read Extended Events .xel File

I have a table that contains JSON objects. Each JSON object contains an array in square brackets, s… Read more Sql: Explode An Array

I have an expression that shows the total inventory before all orders in and out: (Query3 just com… Read more Access Sql Filter Query By Date For Two Values

This has been cracking me up for a few days now and I just can't solve it. I followed an online… Read more Azure Sql Database Working When Ran Locally But Not When Published To Azure

i want to group prices according to products id, like here: http://s44.radikal.ru/i106/1108/57/3338… Read more Cfoutput Group Prices

The following code fails on my Windows 10 machine running Strawberry Perl 5.24: use DBI; unlink gl… Read more Perl Dbi Sqlite Commit Or Detach Fails When Autocommit Is Set To False

I have a problem where I need to get the earliest date value from a table grouped by a column, but … Read more Sql Query To Find Earliest Date Dependent On Column Value Changing

I'm trying to connect with C# code to a SQL Server database hosted on gear host using the Syste… Read more Issue Connecting To Gearhost Database

Here is the table that I am working with: MemberID MembershipStartDate MembershipEnd… Read more Contiguous Dates

I have this kind of data: Date Count1 Count2 Count3 ... Countxx 01-05-2012 1 0 … Read more Tsql Calculating Sum Of Numerous Fields

I got an error: #1242 - Subquery returns more than 1 row when i run this sql. CREATE VIEW test AS … Read more Error : #1242 - Subquery Returns More Than 1 Row

This is an overall question of best practice when designing a database and I have been unable to co… Read more Storing Data In A Side Table That May Change In Its Main Table