Topics
Started by
Posts
Last post
Dear Fellows, How could be find the records where specific values/field changed. In the sample tabl…
5 replies
Hi there, I have a table that stores date periods against PersonID's and there should be no overlap…
2 replies
Hello,When I try to run below BCP command from SSMS SQL 2014 version or sqlcmd linebcp "[db_name].[…
7 replies
the inner query returns only 36 rows, so I expected the DELETE WHERE EXISTS to delete only 36 rows.…
9 replies
I already have a working stored procedure that exports sql query data set into a .cs…
9 replies
I wanted to retrieve single rows of two columns based on a certain criteria after joining multiple …
3 replies
In subject line of email I want @Subject to return "'Submission at 10/03/2019 22:46:34". Concatenat…
5 replies
we keep data in an Excel spreadsheet on a local drive.Can i use that data in an SQL query??I do not…
1 replies
i have a question about joining tables. I have read online people describing the two methods …
8 replies
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[HSN]( [MSN] [float] NULL, [SN]…
2 replies
Hi All, We have a table which have high data insert with a status flag column , I want to select da…
1 replies
Hi Everyone, Reaching out for some help solving a SQL problem. I have a list of active servers and …
6 replies
Hi Experts,I am running a query below in ssms and it returns data,but when i put the same query on …
3 replies
By: Thom A
My table and data as following,USE [myERPMARA]GOALTER TABLE [dbo].[firstTimeReg_UsrCommunity] DROP …
3 replies
This query (I've simulated it to show you. Otherwise, it is longer with many more lists of columns,…
5 replies
Viewing 15 topics - 601 through 615 (of 3,069 total)
You must be logged in to create new topics.