I have a stored procedure which pulls a large SQL blob from a table. That SQL blob returns tens of thousands of records and then the SP performs certain actions on those records (inserts into different tables) . Essentially, the blob looks something
There is a varbinary column in database table,in sql statement,we can use convert(varbinary(10),N'hello') ' to convert string to varbinary ,but in rails,how can I do that or there is a another way to insert a string content into varbinary column.
I am writing aprogram which uses the Microsoft.SqlServer.Dts.Runtime library to load a package from XML. Currently, I am extracting all of the connections and tasks but I am not currently capturing the precedence sequence. I used the following short
How to get columns with only non null values. Say Output of CTE1 is ColA , ColB , ColC , ColD , ColE 1 , 2, NULL, NULL, NULL So in I must write a CTE2 that takes CTE1 (ColA to Col E) (ONLY ONE ROW ALWAYS) as Input and returns only Non null Values i.e
This question already has an answer here: PHP, Simplest Two Way Encryption 4 answers below is my encrypted code so, please tell how to decrypt the string using php. <?php $input = 'password'; $password_hash = md5($input); echo "$password_hash"
I tried many query to achieve the expected result , I couldn't find any solution. Actual:- ID | EmpDailyFee | EmpMonthlyFee | CompDailyFee | CompMnthlyFee 1 NULL 12 NULL NULL 1 50 NULL NULL NULL 1 60 NULL NULL NULL 2 50 NULL NULL NULL 3 NULL 30 NULL
Have to move a table from MS SQL Server to MySQL (~ 8M rows with 8 coloumns). One of the coloumns (DECIMAL Type) is exported as empty string with "bcp" export to a csv file. When I'm using this csv file to load data into MySQL table, it fails sa
I have a main report that pulls data from our CRM datasource: -Project No -Voucher No -Cheque No Then I have a subreport that is from a different GP datasource and displays -Cheque No These are linked on Voucher No. The subreport works great, however
I am trying to match IP addresses. The input IP address can be "184.108.40.206". So, I am matching like first part of input IP address with all the IP address in database that start with 5. My query is like following SELECT top 1 PARSENAME(ipaddress,
I know there are a lot of articles out there that show you how to PIVOT data and return different outputs but i am really struggling with this. I need to transform data which presents as multiple rows into a single row. THe table I have contains the
I have a SQL agent job that I want to have kicking off 4 other SQL agent jobs using the following: EXEC msdb.dbo.sp_start_job 'My Other Job' Now each job is its own step, however, the job does not wait to see if the job finishes successfully, it just
I have a scenario (SQL 2008) where I need to find the occupied timeframes /non-gaps from the below table. For e.g . I have created this dummy table. CREATE TABLE Job ( JobID INT NOT NULL, WorkerID INT NOT NULL, JobStart DATETIME NOT NULL, JobEnd DATE
I have two table Cal_date and RPT_Invoice_Shipped. Table cal_data has columns month_no start_date end_date The table RPT_Invoice_Shipped has columns Day_No Date Div_code Total_Invoiced Shipped_Value Line_Shipped Unit_Shipped Transaction_Date I am usi
Here is what I am trying to do: SELECT iif(d.ItemType = 'INVOICE', 0, iif(d.ItemType = 'PACKING', 0, 1)) AS MissingDocuments FROM dbo.DocumentDetails AS D Unfortunately realized this is not compatible with MSSQL2008. So tried writing an IF ELSE but t
I have 5 TB of data in production and my development team requested to restore only last month data(<=500 MB ) in staging server and last 2 months data in pre production. How can I restore only last 1 or 2 months data in sqlserver? --------------Solu
Currently the code below does running total with 50 as its limit. Now i would like to have 50 as the minimum value for the remaining. How could i possibly do this. Any hints will be really helpful. (min balance 50). This code is in sql 2012, need it
I have a stored procedure which is runs automatically every morning in SQL Server 2008 R2, part of this stored procedure involves executing other stored procedures. The format can be summarised thus: BEGIN TRY -- Various SQL Commands EXECUTE storedpr
I have this table ID AGE ACCNUM NAME -------------------------------- 1 10 55409 Intro 2 6 55409 Chapter1 3 4 55409 Chapter2 4 3 69591 Intro 5 6 69591 Outro 6 0 40322 Intro And I need a query that returns the two max age from each ACCNUM in this case
I have two databases one database is recording tank levels every 1 minute. We have about 30 tanks. The other database contains lookup tables that contain the number of gallons or each tank for a given level. I have manged to use an INNER JOIN to get
i am having a sample table generated and xml generated using cte from it declare @t table (ID int, PersonID int, Type varchar(10), Name varchar(10), Category varchar(10), value int) insert @t values (1, 1234, 'xtype', 'John', 'abc', 200), (2, 1234, '