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 …

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 …

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 …

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 …

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 …

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 …

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 …

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?

…

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.

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          …

(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 …

<?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'];
      …

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 …