SQL

1K

Solutions

4

Articles & Videos

904

Contributors

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Related Topics

  1. Microsoft SQL Server
  2. Query Syntax
  3. Microsoft SQL Server 2008
  4. Databases
  5. Oracle Database
  6. Microsoft Access
  7. Programming
  8. SSRS
Refine results

Hi Experts,

I have a report that until recently used one SQL database to populate.  Business requirements are forcing me to split the database up.  When I deploy the report it fails and I get the …

1215 views
Create Professional Looking Email Signatures
Create Professional Looking Email Signatures

Create "Professional HTML Email Signatures" with ease.
7 Day Money Back Guarantee if not 100% Satisfied.
Affordable - Try it out for 7 Days Totally Risk Free.
Installers provided for over 45 Email clients.
Both Windows & MAC Supported.
Highly Recommended!

I have a SQL table with the fieldnames the same as the node names in the attached xml file.

I need to write  a SQL script to import this XML file into the table:  TimeSch

I have tried the …

35 views

Hello, I'm using MS SQL Server 2014.

I have data that looks like the following:

(CODE)

And I'm trying to 'collapse' the various groups which have the same values into a single row - for …

220 views

New to SQL but have been asked to set up a sql database from checklist I was provided

I assume this is just creating a new user in the database by going to the users folder under the database I …

28 views

Greetings!

As I make my transition from working on "DB2 for I" to "DB2 for z/OS", I'm finding subtle differences that are tripping me up.

For example, I copied the following simple stored …

215 views

I have this code in a trigger:

INSERT IV00108
(ITEMNMBR, PRCLEVEL, UOFM, TOQTY, FROMQTY, UOMPRICE)
SELECT @ITEM, PRCLVL, @UM, 999999999999.00000, 1.00000,PCT_OF_LIST FROM PCT_PRCGRP_PRCLVL WHERE …

211 views

Hello,

I have query which specifies 'ON Job' based ob the collection date
(CODE)

Need to change the ' on job'  criteria if the A.StartDate = 23-May-2017  and A.EndDate =26-May-2017 then it …

2015 views

Dear all brother and sister, i am working on VB.Net and SqlServer application, let say i have table "tbl_att" with field (empid, WorkingDate) and i want Sql job to do a task for me. I want it …

313 views

Hello,

I have been struggling to figure out how to properly use the STUFF function to update a column's values.  If column's first char is "D" then update it to begin with "DC" instead.

column …

615 views

I have a form where the user selects combo boxes and presses a button.  I would like to code the button so that it takes what's been selected in the combo boxes and uses that to append a row in an …

411 views
Technology Partners: We Want Your Opinion!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

If they had a tdap (cpt4_code = '90715') then show the date (order_date) else if not then if they had dtap = to any of these codes cpt4_code in (90696, 90697, 90698, 90700) then show the date …

1231 views

I have 2 table
tab1                                          tab2
-------                                         --------
col1     col2                               col1           col2
------  …

816 views

I need to pull two values from a repeating string. I've got it working 99% but it's ugly.

Looking for a trick here if you see one.

/******************************************
I got a simple …

318 views

Hello experts,

I have to write a sql joining 6 tables. to retrieve classid, planname, workoutname,date,timeslot,status,staffemail and display them to a gridview.

the tables are as below

427 views

Dear All,

Could you please have a short look on this syntax, I would like to have the result in format like 0,134 instead of getting 0:
(CODE)

Could you please advise how to CAST that?

722 views

Using Access 2010.
The following query displays several records with NULL 'detQuan' values in BOTH Period1 and Period2.
I'm looking for a way to display only records with NON-NULL 'detQuan' values …

622 views

Hi, may I know is there a way to find the average by using Access Query?

Example:
Date1 = 1 May 2017
Date2 = 31 May 2017

Query to find average, result should be something like 15 May 2017
Tq.

318 views

Hello - we are considering our options on whether to scrub our newly installed Windows SVR 2012 / SQL SVR 2012 installation, and rebuild it on Windows 2016 instead, and wanted to get the experts to …

335 views

Hi

I have this data in a single column

X^00001JU4QK^129920250^201211070034
Z^00001JUAGI^123995189^201209231021

I need these as 4 separate columns A function is fine

ColA    ColB          …

434 views
U.S. Department of Agriculture and Acronis Access
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

(CODE)


Above is my original code.  The issue is, I cannot do a true >= comparison on RD.ResultInfo because it isn't an integer--so I'm getting all kinds of non <= 70 results.  If I change the …

320 views

TSQL script or PowerShell script to find if windows service is running or not on remote server.

422 views

<?php
      error_reporting(E_ALL);
      ini_set('display_errors', 1);
      
      //connect to db
      require_once 'DB_connect.php';
      
      //Collect the post
      $Cust_Fname=$_POST['Firstname'];
      …

836 views

Hello All;
(SQL Server, is what it will run on, for the production environment.
Access Database is what it will run in, for demonstration)

This is the code.
The query is sent through Jquery, to …

4332 views

I have this
(CODE)

How can I use the result of wordPosition and add it to the end of [ClientCodeWodePosition]

ive attached a small spreadsheet to show

I am using the most recent version of …

820 views

I have this query
(CODE)

I would like to know how I can get the number of words so in this case Field NoOfWords would =3 in each row as the original string contained 3 words before it was split.

923 views
Show more content
201506-LO-Top-001

SQL

1K

Solutions

4

Articles & Videos

904

Contributors

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Related Topics

  1. Microsoft SQL Server
  2. Query Syntax
  3. Microsoft SQL Server 2008
  4. Databases
  5. Oracle Database
Top Experts In
SQL
<
Monthly
>