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 …
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 …
Hello, I'm using MS SQL Server 2014.
I have data that looks like the following:
And I'm trying to 'collapse' the various groups which have the same values into a single row - for …
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 …
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 …
I have this code in a trigger:
(ITEMNMBR, PRCLEVEL, UOFM, TOQTY, FROMQTY, UOMPRICE)
SELECT @ITEM, PRCLVL, @UM, 999999999999.00000, 1.00000,PCT_OF_LIST FROM PCT_PRCGRP_PRCLVL WHERE …
I have query which specifies 'ON Job' based ob the collection date
Need to change the ' on job' criteria if the A.StartDate = 23-May-2017 and A.EndDate =26-May-2017 then it …
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 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.
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 have 2 table
col1 col2 col1 col2
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 …
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
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:
Could you please advise how to CAST that?
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 …
Hi, may I know is there a way to find the average by using Access Query?
Date1 = 1 May 2017
Date2 = 31 May 2017
Query to find average, result should be something like 15 May 2017
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 …
I have this data in a single column
I need these as 4 separate columns A function is fine
ColA ColB …
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 …
TSQL script or PowerShell script to find if windows service is running or not on remote server.
//connect to db
//Collect the post
(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 …
I have this
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 …
I have this query
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.