I have 3 tables. Client,Documents and ClientDocuments. The first one is the clients,where the information for each client are. The second one is the documents, which document can go in the system. The third one is the ClientDocuments, which client has which document. Tables Here I have to do a select where i …
Tag: sql-server
SQL Flag Rows Occurring 2 Hours After Previous Flag
I have some messy RFID data due to over sensitive antenna’s. There is a physical process that tracks an RFID tag moving through different stations in a cycle. An item with an RFID tag can move through the cycle more than one time a day, but it is highly unlikely that it could start the cycle within a tw…
Assigning result of For Xml and With clause to a variable
I’m trying to use XML for to concatenate a bunch of columns together and then assign the result set to a variable. I’m using ‘with’ clauses because my initial sub-queries contain calculated fields that later sub-queries need to generate additional fields. When I run it gives Lookup Err…
Get total Sum from SQL Query of two tables
I have two tables which are as follows: Table1 and Table2. Table1 : Table2: I want a SQL query which would show me the result in total manner. The Output that I want is : I have done it using the PowerBI and I know it can be done using SQL too but I am not able to achieve it.
specific day of next month on a sql query
I have a complex (complex because it gave me lots of work to complete!) and it returns results that fulfill the query till the day 30 of the current month. Here is the code: I have a job that runs this query on the third monday of every month. What i need is that the query returns values not only
How to check json format in SQL?
I have a table with a column of type Nvarchar where json is stored. But the format of some of its columns is wrong. So I get an error when I parse them all. I want my query to ignore lines that have errors. It gives this error when I run on all lines: JSON text is not properly formatted.
Apply multiple validation to SQL records and identify all failing validations
I have a requirement where I need to capture all failing validations in SQL database. I have below table: My validation rules are as follows: Department should be IT Age should be in 20s Age should not be 25 These are sample validation and my requirement is to capture all failed records along with failing con…
Query not returning expected data
I’m looking for an explanation for why 1 of the following 3 queries aren’t returning what I am expecting. Assume the following: Anmodning with ANNo=1, ANCpr=1111112222 And the Person table doesn’t have a row with PSCpr=111111-2222 Queries are executed in Management Studio against a SQL Serve…
Remove trailing comma
I have a table with names formatted as “Smith, Stan” and need to display them as “Stan Smith”. I was able to do that but it seems that the comma has been left behind and I need to get rid of it. This is what I currently have: Answer How about using replace as below
How to check if a given database exists on the server?
I am doing a union of same table from different databases to get all the company details. Something like below. This is working fine and I am getting all company details, but I want to make sure that database is exist in the server. Because if any one of the union database is not exist in the server then the