Topics
Started by
Posts
Last post
All, I have 26K records which I have to insert into a table. I have built a query using the Excel b…
2 replies
I am trying to export some table to csv using bcp, I have to do it query-like so this has to be the…
2 replies
Hi Alli have this Query Belowstring updateReq = "UPDATE Student SET Student.ID_Request = Request.ID…
4 replies
I have a query that finds the first recurring character in a string. For eg : if @str = 'ABCCDA' t…
46 replies
Hi All, Need some help in tsql.I want to have a new generated column (i.e. Txnid), for every 1..6 …
2 replies
I have a query that performs an average on a particular column but its giving me unexpected results…
2 replies
Table in my db should be exported to csv file via bcp query. I managed to export it on the Server s…
2 replies
I have two tables one table have lists of tasks and the second table have list of spares which are …
4 replies
I'm trying to null the values for BOMSEQ_0, CPNITMREF_0, YREF_0 and TEXTE_0 from both parts when th…
2 replies
Hi,I am not able figure out how to catch the data conversion error in the select statement. can you…
12 replies
I have stored proc which fetches a lot of data and the performance is really bad. The problem is th…
14 replies
is it possible to dynamically find the row containing the largest numeric value to return only one …
3 replies
HI All, I have an assignment, to Purging data, with conditions:1. Keep the full data 6 months (keep…
17 replies
I have a requirement to write an error to the Windows Event Log when the number of rows in a table …
9 replies
Hello, I am writing a Stored Procedure and would like to return an error code for a web appli…
4 replies
Viewing 15 topics - 931 through 945 (of 4,984 total)
You must be logged in to create new topics.