Topics
Started by
Posts
Last post
I have a query as below: SELECT district_nm, urban_appr, urban_in, NULL, NULL, NULL, NULL FROM dbo…
12 replies
Hi Friends, The below query fires an Error:- (Case TEJPGLMA_LEAF.CATEGORY WHEN 3 then (Select Sum(C…
6 replies
Hi, Greetings!!! How we can Improve the Performance of a Query WIthout creating Indexes?
5 replies
Hi to all, I have 120GB database,i have to import data from my DB to XML file by date ,but my prob…
1 replies
Hello all! I'm afraid I need some help with T-SQL :s I have 2 tables: ---------------------------- …
3 replies
Hi All, The following stored proc is used to return the results in one of my report. But the report…
6 replies
I have a stored procedure that needs to return the next number in the sequence a particular sequenc…
3 replies
Dear Pros, I need specific grouping, please see example... Example Data: [font="Courier New"] PRICE…
8 replies
We have a default OrgnizationID we need to use in our database. It's a constant integer variable. I…
9 replies
Hi, I'm using try and catch for my query. I got two tables Main and MainSub1 and pulling data from…
3 replies
In my table I have my dta like, all the data is same except the phone no.s in repeted rows. the cod…
13 replies
Hi, Suppose I have a table with values 8000, 6000, 4000, 2000, 1000 I want retrieve the nearest �…
3 replies
3 replies
say that we have a table naming "abc" with their values id name address email 1 …
4 replies
I know updating statistics improves the performance of the queries(selects the best execution plan)…
3 replies
Viewing 15 topics - 7,216 through 7,230 (of 10,635 total)
You must be logged in to create new topics.