Topics
Started by
Posts
Last post
Hi, i Have one sp which givings results 20 rows But COLUMN HEADINGS ARE REPEATING FOR each row. …
1 replies
Hi All I have project that basically requires me to “find the best match” solution. Any advice/guid…
1 replies
My sub select is giving me errors stating that it is returning more than 1 row. I am not sure how. …
7 replies
I need to compare whether a particular date(say date1) is greater than date2...How do i do it in SQL
9 replies
I have a table like below: Emp ==== id name -- ----- 1 x now, i want the resuts in t…
1 replies
I am trying to find a solution for changing sort order on a complex query without having to re-writ…
7 replies
I would like to round off the 2937 values that are returned when running this query. I have been lo…
5 replies
Hi created a store proc.In this 3 table insertion are done. 1.Consumer table 2.RoleConsumer table 3…
2 replies
Hello, Please find the below TSQL Code: declare @table1 table ( SourceId INT, RecordStatus NVARC…
4 replies
3 replies
Hi All, I Have 2 servers A&B. 1) A contains sp and target server is B. now i used open row set…
3 replies
Hello gurus, I have recently been told that adding PRINT statements in a Stored Procedure helps whe…
5 replies
I have two tables: one with name tblmonth and another with name tbldate as follows: tblmonth: stdid…
9 replies
I have created the following function: CREATE FUNCTION [dbo].[DailyActivity] ( ) RETURNS @SalesData…
2 replies
declare @tblmonth table(stdid int, code char(1), jan int, feb int, march int, april int, may int) d…
1 replies
Viewing 15 topics - 9,271 through 9,285 (of 10,647 total)
You must be logged in to create new topics.