Background to my question At any moment I am expecting the security people in black suits and black sun glasses to come and take me away because of all my sql server login attempts… I used and adapted iris classon’s example to connect to a database via Powershell. The adapted code uses Integrated Security=True” $dataSource […]
I have two table INVENTORY and INPUT create table INPUT( PRODUCTID nvarchar(10), QUANTUMINPUT int ) create table INVENTORY( PRODUCTID nvarchar(10), QUANTUM int, QUANTUMINPUT int, LASTQUANTUM int ) How to create SQL trigger on SQL when insert column QUANTUMINPUT, table INVENTORY change over?
I have following data: CREATE TABLE #Rate ( RateId Bigint ,PropertyId Bigint ,StartDate DATETIME ,EndDate DATETIME ) INSERT INTO #Rate VALUES (100,1000,’2015-01-01′,’2010-01-11′) INSERT INTO #Rate VALUES (100,1000,’2015-01-12′,’2015-02-02′) INSERT INTO #Rate VALUES (100,1000,’2015-02-11′,’2015-02-25′) INSERT INTO #Rate VALUES (100,1002,’2015-01-01′,’2010-01-11′) INSERT INTO #Rate VALUES (100,1002,’2015-01-12′,’2015-02-02′) INSERT INTO #Rate VALUES (101,1000,’2015-02-11′,’2015-02-25′) INSERT INTO #Rate VALUES (101,1000,’2015-01-01′,’2010-01-11′) INSERT INTO #Rate […]
New versions of SQL Management Studio render a bookmark lookup as in the picture below. That makes me think the operation is independent from Index Seek (and can run in parallel?). Shouldn’t Index Seek finish first? Its output (physical row IDs) is the input for Key Lookup, right?
I am creating a Django application for online attendance system that has to store weekly working hours of employees for few years(5 or 6) I want to create a table, that has employeeid, year, month, week and hours(example 4hrs for week1 in Jan 2015 for employee with id 200) I tried creating models(year, month, week, […]
Asp.net Form Student Name Student Address English (marks) Maths (marks) Science (marks) For the above form I have created the following table structure Create Table Student ( sId int primary key identity(100,1), sName varchar(50), sAddress varchar(100) ) Create Table Subjects ( subId int primary key, subName varchar(100) ) Create Table Marks ( mid int primary […]
I’ve been pulling my hair out for a couple of days about the issue i’m having. Trying to read a PDF that is stored as binary blob data in a SQL database (not mysql) varbinary field. If I use a program like Navicat, and save the raw blob data directly as a PDF, the file […]
I have a following question with respect to which of the below sql is right for the types of question. QUESTION 1: I have two tables: TABLE1 and TABLE2. TABLE1 has 1 million records and contains the variables ID and AGE. AGE is a bucketed variable to the nearest 10-years (e.g. 10, 20, 30, 40…). […]
My table looks something like deal_id test_value run_date 820117648 1.2 2014-03-31 820117648 1.33 2014-04-30 820117648 1.33 2014-05-30 820117648 1.26 2014-06-30 820117648 1.11 2014-07-31 820117648 0.58 2014-09-30 820117648 1.64 2014-10-31 820117648 0.64 2014-11-28 820117648 3.65 2014-12-31 820117648 3.8 2015-03-11 820117649 0.64 2014-09-31 820117649 0.23 2014-10-31 820117649 0.64 2014-11-28 820117649 3.65 2014-12-31 820117649 3.8 2015-03-11 SELECT deal_id,test_value,run_date […]
I have a order table and an orderItem table. I would like to get orders for a user which are placed less than or equal to 2 mins between them and who have the same products(number of products must match as well) associated to them. Based on this question I’m able to sucessfully filter out […]