Re-installing a SQL Server Instance - Hi, I have a need to completely uninstall and re-install SQL Server from several servers but I'd like to preserve as...
Extract String - FilePath Structure: \\Servername\Temp\Foldername\ABCabcprices-20170621122040.txt From the given filepath need to extract "ABC" from "ABCabcprices-20170621122040.txt". Conditions : Severname and foldername can be any length and filename...
SUBSTRING and CHARINDEX query.... please help. - Hi, I have this table, column, and string: Table = audit_log Column named = request_u Example column value = http://stable-test.test.net/api/files/fs.testcollection/TP-0000000.pdf/download/ What I need to do is return the...
Merging row records where the end date of previous record is equal to start date of next record. - Hi guys, I'm writing a script on SQL and my aim is to merge row records which have the same location...
Copy Table Data - I have a large table that I need to copy. (insert into , select, from ) It brakes with the following...
How to get the monday of every week - example: today (6/20) tuesday Monday =6/19/2017 last week monday : 6/12/2017 Previous last week monday : 6/05/2017 I need to get all the monday's for...
Missing months group by - My data is like below currently- 7 columns below in first table. Date Country P1 P2 C1 C2 R1 2017-03-01 IN 0...
Database engine tuning advisor - Hello Using the database engine tuning advisor, is the any way to show how much each individual recommendation will improve your...
find out who / what casued my database to increase in size? - So one of my production databases just grew 100 gb in 10 minutes during the lunch break... its been stable...
Report queque - Does SSRS keep track of reporting running queues? If it does, where I can find it? Thanks
If statement in T-SQL - Hi guys, I am trying to display item_name with a new category, which says the following term ( i have pasted my...
Where to use ISNULL to convert NULL in PIVOT result set - Hi, I can't figure out where to use ISNULL (or COALESCE) to convert NULL values in the pivot result set to...
Alternative to Group by and Having - Hi, I am trying to find customers and their who had made orders more than 10 times from transaction data. Eg: My Query; With...
Permission denied error on object - Executing the query "PROC_ACTION_INSERT ?,?" failed with the following error: "Cannot find the object 'PROC_ACTION_INSERT ', because it does not exist or...
Availability Group Listener not routing ApplicationIntent=Readonly to secondary replica - I'm in the process of setting up a test environment for using availability groups. Our goal is to have our...
get full path from sys.xp_dirtree - hello all. I have this script: IF OBJECT_ID('tempdb..#DirectoryTree') IS NOT NULL DROP TABLE #DirectoryTree; CREATE TABLE #DirectoryTree ( id int IDENTITY(1,1) ,subdirectory nvarchar(512) ,depth int ...
Tsql Query help - Hi guys, I am working on a process where the query to be written seems little tricky to me. I have...
Inserting data using OPENXML - Hi, I received am xml file from the customer (Around 2 gb data). The xml looks complex. I have to...
Expression needed for Midnight of previous day - How to get expression for yesterday and day before so that the time stamp resets *exactly to midnight*? I have Yesterday gives...
Potential presentation idea: SQL Server for absolute beginners - So, I took today off from work to prepare and travel to SQL Saturday #517, and something occurred to me...
