Topics
Started by
Posts
Last post
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
Hi, Guys i have a one question. I have a db where backup is 50 gb.Is it possible to backup only dat…
5 replies
I have one main table tbl_con and one more Audit tbl_Aud_con. tbl_con has trigger(AFTER) when …
1 replies
I am trying to run a SELECT statement and post the results to a Gridview in C#. Everything wo…
8 replies
Viewing 15 topics - 931 through 945 (of 4,984 total)
You must be logged in to create new topics.