Topics
Started by
Posts
Last post
Hello, I have been told that the keyword DISTINCT is rather costly for sqlserver and was wondering …
18 replies
Hi I am trying to generate a Stock Ledger Report. I am wondering my requirement can be met without …
6 replies
I have the following columns in a table: AccountNumber, TelephoneNumber, DateCalled. I'd like to fi…
8 replies
This has to be a very basic question but it just puzzles me. I want to select all the dates less th…
21 replies
hi friends i want to convert money value in the term of word through query example 1000 (rupees) t…
2 replies
I understand what this statement does: select distinct(names) from tableA But what about this one? …
6 replies
wht is wrong in the below cursor ? When execute it double rows get inserted .... declare @name varc…
7 replies
Good Morning, I am relatively new at using SQL and stored procedures. I am trying to tune our SP's…
17 replies
(Please forgive me in advance if this is not in a proper post format, this is my first time posting…
8 replies
I have a sql statement which needs to be modified. It combines several fields which may or may not…
7 replies
What's the best way of debugging a stored procedure, I have a really long stored proc. Thanks!
4 replies
When using sp_executesql, is it possible to "evaluate" a function? In other words, is there anyway …
4 replies
The following error (referring a non-existent column) is not catched: begin try insert into exclu…
2 replies
hi im writing login stored procedures. im having some difficulty with my update user stored procedu…
9 replies
Dear Friends, In my application, I have the below requirement. When the user specifies a keyword, I…
6 replies
Viewing 15 topics - 8,266 through 8,280 (of 12,230 total)
You must be logged in to create new topics.