Topics
Started by
Posts
Last post
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
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
There is this a stored procedure that joins table to retrieve the required results. It needs to fil…
1 replies
As the subject says, I'm receiving the "invalid column ordinal" error while trying to BCP data into…
1 replies
Viewing 15 topics - 601 through 615 (of 3,067 total)
You must be logged in to create new topics.