Topics
Started by
Posts
Last post
Hi, I want to know that how to use Exists operator instead for below query ... "select fname,…
1 replies
Hi I have to retrieve specific info re customers, however depending on the type of customer the in…
2 replies
Hi All, I have a table containing Applicationid,applicationname,source where an unique application …
3 replies
How can i get rid of cursors from the following SP. Pls check the attached file. thanks
44 replies
Hi There Really need help on this. Write a query that displays pairs of flights, where the destina…
10 replies
I am having some serious trouble figuring out how to do a request given to me. We have a strongly …
5 replies
I am converting from an old application to a new one. The old system has a table with a field with…
3 replies
Hi All, I need to code a query to return a delivery date based on two factors: the days that a del…
13 replies
I need to create table with the data information passed under a proc as follows: CREATE PROCEDURE […
7 replies
Hi All, I have numbers like 121212122, 12364232, 12367 I just wanted these numbers as 121…
4 replies
I have a table which contains the two column ID and skilltype. Create table temp (ID Int identity(1…
14 replies
create table mytable (policyid int, trandate datetime, amount money) insert mytable (policyid, tran…
3 replies
;WITH emps(empID,Percent) AS ( SELECT empID, case when COUNT(DISTINCT payid)>…
3 replies
hi members, how to create a table in a different server apart from the server your working thanks, …
3 replies
I have the following code: DEclare @Level10bit Set @Level10 = 1 IF (@Status = 'All Active') BEGI…
19 replies
Viewing 15 topics - 9,256 through 9,270 (of 12,230 total)
You must be logged in to create new topics.