Viewing 15 posts - 16 through 30 (of 38 total)
Dear Neetu,
You need to make very small change in your table B, Add one primary key ProId as follow
CREATE TABLE B (
ProID int IDENTITY (1, 1) NOT NULL ,
RefNo int...
/**A strong positive mental attitude will create more miracles than any wonder drug**/
November 8, 2005 at 11:59 pm
Try this:
Select count(1)
From dbname..tablename
Where sdate=CONVERT(varchar, GETDATE()-1, 101)
/**A strong positive mental attitude will create more miracles than any wonder drug**/
October 26, 2005 at 8:10 am
SELECT SUBSTRING('20050910',7,2)+'/'+SUBSTRING('20050910',5,2)+'/'+SUBSTRING('20050910',1,4)
/**A strong positive mental attitude will create more miracles than any wonder drug**/
October 17, 2005 at 4:52 am
I give you full 100 out of 100. Thank you.
Vivek
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 26, 2005 at 2:30 am
Hunting has been done long back - 2 years before. If you don't mind, kindly provide the link if already posted.
Well, hunt me if you can..?
Vivek - HUB of...
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 25, 2005 at 5:54 am
ACTUAL | |||
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 25, 2005 at 4:44 am
hi,
after 3 days of pain, i have got the job done. thanks others for their time to look into the problem....
We need people in action to accomplish impossible to possible.
Vivek
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 24, 2005 at 12:13 am
I am not satisfied, as this is not working. Users can login and access the application
Vivek
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 23, 2005 at 2:22 am
Join is generally performancce degrader. Select Case is faster and executes in less time compared to JOIN. For faster execution, avoid join. Better table design is something I appreciate but
your query...
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 18, 2005 at 2:37 am
--Hi,
--Following SCRIPT will serve your purpose.
DECLARE @ID int
SELECT @ID = Max(ID) From Sheet
--SELECT @ID
WHILE @ID <> 0
BEGIN
UPDATE Sheet Set
FromStatus
= (
SELECT
CASE IsNull(EndDate,1)
WHEN 1 THEN 'NULL'
ELSE ToStatus
END
FROM
Sheet
WHERE...
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 16, 2005 at 10:35 pm
Ur nos are creating win win mysterious scenario...hope u hv understood my doubt...explain in det...
Cheers,
Vivek
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 12, 2005 at 5:55 am
Will u be bit more clear...?
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 12, 2005 at 5:50 am
CREATE FUNCTION ReturnAll (@msgID VARCHAR(8000) )
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @Result varchar(8000)
,@i int
,@one varchar(100)
,@two varchar(100)
,@three varchar(255)
SET @one = ''
SET @two = ''
SET @three = ''
SET @result = ''
SELECT @i = Count(*) FROM t_Attachments WHERE msgID =...
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 12, 2005 at 5:38 am
ALTER FUNCTION ReturnAll (@msgID VARCHAR(8000) )
RETURNS VARCHAR(8000)
AS
BEGIN
DECLARE @Result varchar(8000)
,@i int
,@one varchar(100)
,@two varchar(100)
,@three varchar(255)
SET @one = ''
SET @two = ''
SET @three = ''
SET @result = ''
SELECT @i = Count(*) FROM t_Attachments WHERE msgID =...
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 12, 2005 at 5:37 am
Query 1 - >
SELECT DrawID,DrawDate,WinningNumbers FROM [Result Table] WHERE
DrawID IN (SELECT Max(DRAWID) From [Result Table])
Query 2 - >
SELECT DrawID,DrawDate,WinningNumbers FROM [Result Table] WHERE
DRAWID IN (SELECT Max(DRAWID) FROM [Result...
/**A strong positive mental attitude will create more miracles than any wonder drug**/
August 12, 2005 at 12:30 am
Viewing 15 posts - 16 through 30 (of 38 total)