I have the following query:
Vesion = 1 means working status
Version = 0 means published status
Active=1 means active ID
Active =0 means inactive ID
I would li…
Currently I have 2 views that tell me if an invoice whose Status = 2 has more than 3 purchase orders assigned to it. I'd like to have one query do all of this instead of 2 views.
Using SQL ;with , I need to only find the latest payment record with the highest payment amount for a customer.
I marked with a *, the records I need to be selected.
I will then take the With dat…
I have 3 unions...and am trying to do a left join...it might be I need to do each left join to each one and then do the union...I was thinking I could take the resultset of all the unions and then do …
I have two tables. One table called pay_encounter(PE), it has PK enc_id and parent_enc_id. Second table named pay_document(PD), it has PK document_id, and FK = enc_id to PE table. PE table has one->ma…
I have a SSIS requirement to VERIFY MemberIDs from one Server with MemberIDs on another Server. I need to create a matched list and an unmatched list.
I need to compare data from these …
My table name = tbl_Students
This table has a column ' Student_TEL1 ' nvarchar(50)
How can I change the max lenght from (50) to (200)? - Without losing DATA
I need to setup MS SQL Transactional Replication between two untrusted domains over the Internet.
One of the SQL Servers running sql2008 (the Publisher that acts as it's own Distributor) is in a ph…
We are looking for a query builder tool for end users which can dynamically create parameters, export to excel, adhoc report capability. Please suggest if there are any. Has any one us…
I have a computer (Win7 Pro) on our network who cannot connect to a SQL server outside the Network. However, If I try on another computer (Windows 7 Pro) to connect on the same server with the …
What is the best method to import database from an old Microsoft SQL version 2000 to our SQL 2014
this is the query :
why i am getting this error ?
Windows 2012, SQL 2008 STD.
I have a database of 60GB size, not too big.
I am trying to rebuild index and update statistics using SQL SMSS Maintenance Plan.
Rebuilding index went smooth, took le…
First of all, I'm sorry I am not SQL expert, but I have to do this tomorrow, so I need a quick starting code to do what I want.
There are 2000 tables I need to update statistics, but last time, it f…
I had this question after viewing Following an example - removing duplicate strings (https://www.experts-exchange.com/questions/28977910/Following-an-example-removing-duplicate-strings.html).
I found this example
To remove duplicate strings. Mine is not comma delimited.…
We have got a basic query that we run on a daily basis that works really well. However we now want to format it into a HTML table.
Im new to the SQL statements and have got the below so far
Hi Experts I get following Error
Updating a record
**** SUMMARY ****
MESSAGE: 'The record cannot be deleted as 'Agreements' contains related records'
LEVEL:1 TYPE: 'System.Data.SqlClient.Sql…
System: Windows Server STD 2012, SQL 2008 STD.
I rebuilt indexes using the maintenance job in SMSS.
It finished with no error.
I checked fragmentation after it(Code to check fragmentation is a…
We have a logon failure occurring each day at about the same time. The failure is occurring because the login does not exist on the SQL Server. I notified the developer who's machine it is coming fr…
I am trying to SELECT all sys.messages that contain the text string 'NULL'.
First query shows there is at least 1, message_id = 515.
Second query does not return this record. I assume there …
I'm not an expert on SQL, but have to rebuild index and update statistics on a database.
When I search the steps to do, nearly all of them are running manual codes to do it and they are all differ…
I need to provide some information to IT about.
I am not sure, how I can generate this information?
i. OR RTO
ii. OR RPO
iii. DR RTO
iv. DR RPO
Is there any query or script that I ca…
I'm getting an error while setting up the server farm account (Sharepoint 2010).
Trying to deploy a single server with SQL Server 2008 R2 Standard. This is not the domain control…
Could anyone share the steps involved during DR drill for failing over the log shipped databases and app team is gonna do some tests on the secondary database(which will become primary …