Topics
Started by
Posts
Last post
Inna is a colleague of mine that came across an interesting problem. She had a query that had a wr…
17 replies
Hello everybody, more than a specific consult is a general wonder. I need to a improve a query perf…
16 replies
i have three table 1. student (stuid,name) 2. subject (subid,sname,studid) 3. marks (subid,studenti…
3 replies
Seems there's a lot of misinformation about SP's so I'm curious what a poll of people here will sho…
16 replies
Hi to all, I have to delete some rows from a table based on timestamp, but this table has foreign k…
1 replies
Hi Guru, I need to develop a new report for sales people. This report will do lots of calculations …
6 replies
Hi Consider this table of account balances: use tempdb go CREATE TABLE balances ( transactionId I…
15 replies
I did this code in ORACLE with lpad and rpad but I cannot figure out the sql server code to do this…
2 replies
How to split the following string ? Note: Without using split function,dynamic sql and xml Declare…
3 replies
how to compare a column from one table with two columns in other table keeping the primary key sam…
6 replies
Let's say i have a table with 20 million records. I have a process that adds about 50,000 records …
4 replies
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
Viewing 15 topics - 7,216 through 7,230 (of 10,647 total)
You must be logged in to create new topics.