Topics
Started by
Posts
Last post
select * from a,b,c where A.cash_id in ( select B.cash_id from B where B.cash_id = C.cas…
4 replies
I have the following 2 xml codes and I want to do a search on tag name DECLARE @X xml SET @X = '<…
2 replies
I have got a data like: IDLevelSeq 1001,1,1 1002,1,2 1003,1,3 1004,1,4 1005,1,5 2001,2…
1 replies
I have two columns 1 appointment 2 joindate date is like Appointment | joi…
3 replies
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
Viewing 15 topics - 7,201 through 7,215 (of 10,635 total)
You must be logged in to create new topics.