I am not an advanced SQL database admin, so I am looking for a simple and temporary means to monitor if and when data is changed in dbo.MyTable.MyColumn.  The field is Not Null, TinyInt and is either 0 or 1.  

Any suggestions?

Hi, I have few SSIS packages. NOw I want to deploy them. However I can see that our DBA has not
installed any Integration services on the server. But he asked me to just create a Job in SQL Server
agent and call the SSIS Package from the path and schedue it.

can anyone pleae let me know this will work and is this a good strategy ? I thought we need to first
import the SSIS package into the SSIS server and then call this from SQL server agent for the job schedue.

Many Thanks

need to change a value to <blank> if the word is "NO"

I have this field, which has the "YES" or "NO" values.

If the value  =  "Yes" bring back a "Yes"
if the value  = "NO" bring back  nothing  


[PayTermsTiedVolCommi] as 'Payment Terms tied to VC Performance'



Thanks
fordraiders

Good evening everyone,

I have a table with several data (> 2000) of this type:

Reference | Date | Product | Quantity
BC0001 | 2019-09-11 | Bread | 7
BC0001 | 2019-09-11 | Caviar | 5
BC0002 | 2019-09-12 | Oil | 2
BC0003 | 2019-09-13 | Bread | 4
BC0003 | 2019-09-13 | Egg | 12

Select all Open in new window

And another table where I have to reinsert this unique data like this:

Reference | Date
BC0001 | 2019-09-11
BC0002 | 2019-09-12
BC0003 | 2019-09-13

Select all Open in new window

I wish I could execute a SQL query to add in my table2 a single line of my table1 as shown in the example above.

Is there a SQL function to simplify my task?
Thank you for your help

Regards,
Jaber

I have an unbound form frmLogRptCPUSelection that uses a combo box cboComputerDevice to select a device using SQL <SELECT tblComputer.cID, tblComputer.cName
FROM tblComputer ORDER BY tblComputer.cName;>  Once the selection is made I have a "Print" button on the form that has the following code in the Print button Click event.

I also have a report rptEventLogByComputer that is based on a query qryComputerLogCPU.  One problem is that cboComputerDevice is the value of cID not cName.  
I can get the cName with

Dim strID As String
Dim strcName As String

strID = Me.cboComputerDevice
strcName = DLookup("[cName]", "tblComputer", "[cID] = " & strID)

I have tried putting [Forms]![frmLogRptCPUSelection]![cboComputerDevice] as the critera in the query but it does not work.

Now how do I pass strcName to qryComputerLogCPU so that the report will work?

problem getting open query to run

i keep getting an error when trying to run this openquery ?




INSERT INTO
[Metrics].[dbo].[EXTRACT_CUSTOMERPRICE_staging]
           ([PROJECTID]
           ,[LINEITEMID]
           ,[CUSTOMERPRICE]
           ,[WWGSKUPRICE]
           ,[WWGSKU])
SELECT
 [PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM OPENQUERY (XREF_PROD, 'select
 [PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM xref.xref_results')

OLE DB provider "OraOLEDB.Oracle" for linked server "XREF_PROD" returned message "ORA-00936: missing expression".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select
 [PROJECTID],
[LINEITEMID],
[CUSTOMERPRICE],
[PRICE],
[SKU]
FROM xref.xref_results" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "XREF_PROD".


Thanks
fordraiders

I enter the date value in this format.
oracle gives me
 ORA-01843: not a valid month error.
NOTE:(you can better understand the question in the pictures.
Please see the pictures.
but
I enter the date value in this format.
Oracle is running.
)
I want to change the date format.
I don't want to use this date (13.jun.2014),
 I want to use this date = (13.06.2014),
how can I do this?

Result of query 'select sysdate from dual'

17/09/2019 17:46:00

Select all Open in new window

i have 64 names i need to enter into this table via code if possible.
I have a table with these names in a field caled "employee_names"

Or is there another way to add their names or re-design the table ?

Thanks
fordraiders
EMPLOYEE_SCORE.jpg

I am trying to filter a result set based on a DATETIME column

select * FROM [ReportServer].[dbo].[ExecutionLogStorage]  where timestart>=2018-12-31 

Select all Open in new window

here is the what is displayed typically for a TimeStart value

TimeStart
2018-08-03 09:08:24.937

Select all Open in new window

however the filter is not correct, all rows in the table are currently returned.
Any guidance appreciated, thanks

SQL 2014  Cluster
Windows 2012 R2 Servers VM
VMware 6.5

I have two Node SQL Cluster Servers  all disks were iSCSI  connected to a NAS device Seagate Black Armor.

The Black Armor died and I lost two Dries.  but all my SQ Drives were on the two drives that are still working.

 But each of the Server could not connect to the drives.    After remove the target node and adding it back I was able to get most of the drives back.

I have three SQL instances running on both Nodes.

I have a new NAS device and setup all the LUNS and Targets now both servers have al the drives again.

I copied the data from the old NAS to the new NAS

In the cluster I was able to get the DTC back online

and one of the three instances are back online.

I had to add all the permissions back to the new drives folders

The other two instances I can get the SQL server service to start but it stops shortly after

I tried to run a SQL repair from the install DVD  that failed  

Feature failure reason:
An error occurred during the setup process of the feature.

Error details:
§ Error installing SQL Server Database Engine Services Instance Features
Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
Error code: 0x851A001A
Visit …

I have a python script on python 3.7.2 that I have pieced together. The script will first accept user input for a string and store into a variable and then iterate through each function call.

Depicted here:

while True:
    uin = input("Please enter a uin or 'enter' to quit: ")
    if not uin:
        break
    startTime = datetime.now()
    selectCustomer(uin)
    selectVehicle(uin)
    selectHRO(uin)
    selectHLABOR(uin)
    selectHPARTS(uin)
    selectINV(uin)
    selectSUPPLIER(uin)
    selectLABOR_OP(uin)
    selectSOURCE(uin)
    selectRO(uin)
    selectLABOR(uin)
    selectPARTS(uin)
    selectEHRO(uin)
    selectEHLABOR(uin)
    selectEHPARTS(uin)
    endTime = datetime.now() - startTime
    print('It took', endTime, ' seconds to run...')

Select all Open in new window

Each function (for the most part is exactly identical and is composed of:

• opening up a SQL connection
• running a query
• storing the output in an ordered dictionary
• creating a JSON file and naming it with the user input (in our case UIN)
• closing connection and file

Depicted here:

def selectEHPARTS(uin, output_dir=r"C:\Code\TestData"):
    driver = 'DRIVER={SQL Server};'
    host = 'SERVER=SQL2;'
    database = 'DATABASE=ROWSTAGE;'

    connectionstr = driver + host + database
    conn = pyodbc.connect(connectionstr)
    cursor = conn.cursor()

    cursor.execute("SELECT STORE_UIN, RO_NO, PARTNO, PARTDESC, ITEM_NO, 

Select all Open in new window

…

Experts,

I need to add a decode to a JOIN due to inconsistent values used in a table.
In table CL no value is stored as an asterix
in table PI no value is a proper null

...and DECODE(CL.INVT_LEV4,'*',null,CL.INVT_LEV4) = PI.INVT_LEV4

Select all Open in new window

The decode above looks correct to me, but returns no data
If I use the same in a select the columns the proper (null) result.

Why is the join not working?

I am trying to write a SQL statement whereby I have a field named FormElementReference, which is the name of the question, and an associated field called value which holds the answer to that question.

I've written a case statement to try and achieve this, and store the separate values in separate fields for export to SSRS.

What I currently get is an row for each answer value.


SELECT DISTINCT
  FormResults.FormResultKey AS [FormResults FormResultKey]
  ,FormResults.FormID
  ,FormResults.FormReference
  ,UserForename + ' ' + UserSurname as [Full Name]
  ,FormResults.FormResultDate
 
 

,CASE WHEN FormResultDetails.FormElementReference = 'Date' then value else null end AS JobDATE
,CASE WHEN FormResultDetails.FormElementReference = 'Time' then value else null end AS TIMEFrom
,CASE WHEN FormResultDetails.FormElementReference = 'TEB' then value else null end AS TIMETo
,CASE WHEN FormResultDetails.FormElementReference = 'TEA' then value else null end AS TotalWorked
,CASE WHEN FormResultDetails.FormElementReference = 'JNO' then value else null end AS JobNumbers
,CASE WHEN FormResultDetails.FormElementReference = 'AA' then value else null end AS JobAddress
,CASE WHEN FormResultDetails.FormElementReference = 'Reason' then value else null end AS JobReason
,CASE WHEN FormResultDetails.FormElementReference = 'Managers' then value else null end AS ManagerAuthorised


FROM
  FormResultAnswers
  LEFT OUTER JOIN Documents
    ON …