I've a function which returns comma separated values like
I've seven columns i.e. Monday to Sunday in SELECT query. I need to …
Is there a way that I get all values from a column in uppercase .
Select * from TableA
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 …
In my sql below I get a result set of technical "duplicate" records.
What I need is to add a column that show the "Parent" record.
If row = 1 it is IndividualID
If row > I it is Row 1 …
select * from syslogins where sysadmin=1
and if sa became locked…
I am trying to Post my URL through this store proc but it doesn't work for me.
I'd like to know if it works for you and if not, What I need to do to fix it or maybe you have a better…
I'm using sql server 2008
I have a table called MyCompanyEmployees that looks like this:
This the script to create this table:
I have another table called MyCompanyTable1 that …
I want to check if a value is present in a field, if it is not present (null) then I want to set the value to be set to todays date using the GETDATE() function
This has to happen via a stored …
I have a CLR procedure that calls a web service within, and the web service returns a JSON string back with 3 'elements' within it.
I'd like to parse these 'elements' out into 3 separate columns.
I have a query to solve, any suggestions are appreciated :
Need to check who has collectiondatetime for today, the person having it today is on job and the rest are available.
usually we have some perfmon counter for RAM:
Index searches /sec >1000 will have warning. >2000 will have critical message.
SQL Compilations/Sec >100 will have warning ,>300 will have …
I have not ever used a cursor, so please explain when they are useful and how to use them.
Hi. I have been using SQL Server 2008 R2 database mail for many years to send emails from my systems.
Here's my scenario. I have stored procedures with different logic that create records in an…
After the first switch statement
which sets @APNoPrefix
I need to do a test and reset @APNoPrefix if it has a value of 'CZE'
But I don't get the syntax in T-SQL for this simple If …
I've got about 8x SQL Servers VM that is used 24x7 and very big, with some of them is around 12.5 TB in single VM (multiple large VMDK):
128 GB vRAM
C:\ - OS - 300 GB
I'm using sql server 2008.
I'm using the Orders table from the Northwind database.
This is the script for my table:
So the Orders table looks like this. Notice how it …
Is there any way to search a Column name used in Views just like we search Stored Procedures? Please let me know.
Thank you in Advance.
I'm working on a project and we have a geometry column. I'm querying the database to get the data , send it to Mapbox and display it on the US map.
Now, the query is slow and someone at work says …
I use SSMS often and have used SSRS as well.
What does SSIS do? What are the biggest features of SSIS?
Are the rows returned from two tables when using INTERSECT on those two tables the exact opposite set of rows returned with a FULL OUTER JOIN on those same two tables?
On my Exceptions table, with 15 million records, I found that the Clustered index is the default, on the primary key Log_ID. I was considering making a Clustered index on the "Timestamp" column (the …
I am considering investigating a career change to a Database Admin from a C# .NET developer with some SQL and database skills.
What are the biggest things a typical DBA is needed to do on a typical…
I have a table that looks like this:
The "Column_xx_Name" is the literal data …
I'm dealing with the following issue:
I need to know how to use a VARIABLE as a linking-field in a SQL QUERY.
declare @variable1 varchar(30) = select top 1 fieldname1 from table_3