Topics
Started by
Posts
Last post
Hello all! I'm trying to create a stored procedure that needs to return only persons that do not ha…
7 replies
If i hard code an xml statement it work. If i use sp_executesql it works. However if I use sp_execu…
3 replies
Hi all I want to knw how i can retrieve the second highest value from the table which has some da…
22 replies
We have tons of views and procedures. It seems like it takes forever to find so I can open and mod…
6 replies
How can I render the following SQL spec which includes an 'OR' statement? Here is the specification…
4 replies
Is there a way to get these records on a single row. I am not familiar with the CASE function. I …
5 replies
I have the following sample data and query. The tblControl (cl) has a one to many relationship wit…
1 replies
hi guys, i have two tables, i need an output in my report to be like i shown in the output below, c…
5 replies
Hello, I have one table like below. (say table name zz) BIDVceFDTV D901110 D902110 D9031…
1 replies
3 replies
Hi, I have a requirement to round off numeric value and its like @MinValue = 0.8230 @MaxValue = 100…
2 replies
First of all, I would rather not be just given an answer to this question, just pointed in the righ…
6 replies
when i insert a record into a table how do i capture server name and database name into that column?
4 replies
In Excel, the HLookup function searches for value in the top row of table_array and returns the val…
1 replies
Please help teach an old dog a new trick :hehe: For example I want top 10 usecounts by objtyp for …
19 replies
Viewing 15 topics - 6,511 through 6,525 (of 12,234 total)
You must be logged in to create new topics.