|
Select LAST_TRAN_DATE = Max([Date])
From(
Select [Date] = LastDDTxn
From UserHistory
Union
Select [Date] = LastCardTxn
From UserHistory
) Dates
Wout Louwers
|
|
|
|
|
Thanx! Its working fine.
Shahzad
|
|
|
|
|
SELECT LAST_TRAN_DATE =
(CASE
WHEN LastCardTxn > LastDDTxn THEN LastCardTxn
<s>ELSE</s> WHEN LastDDTxn > LastCardTxn THEN LastDDTxn
ELSE NULL
END) AS Last_Tran_Date
FROM USERHISTORYThe first, crossed-out, ELSE is incorrect - ELSE is only used for the 'default' case i.e. when no WHEN clauses match. Therefore, when the query parser encounters ELSE, it's expecting an expression, and reports that WHEN is an error.
|
|
|
|
|
hi all
please tell me the query
actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter
thanks
hello
hello
|
|
|
|
|
Not only cross posting, but reposting. Do you really think we are so stupid as to not notice this?
OK - some guidelines. Tell us what the table structure is and the query criteria you have to work with. Then, give us some idea as to what you have tried so we can see that you aren't just trying to get us to do your homework for you. Finally, pick a meaningful subject. "Re: need query" is not going to get your question answered.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
hi all
please tell me the query
actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter
thanks
hello
|
|
|
|
|
Please don't cross post.
---
Year happy = new Year(2007);
|
|
|
|
|
hello
can anyone plz tell me the query to rename an existing field in a table????
Saira
|
|
|
|
|
EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'
|
|
|
|
|
SQL Server:
exec sp_rename @objname='TableName.ColumnName', @newname='NewColumnName'
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
:-Dwrite querry to compare row in table A and in table B.
for example
if in table A contains row values as a 12
b 14
c 15
if in table B contains row values as a 13
b 21
c 43
compare table A's row c with table B's row c.
pradeep kulkarni
|
|
|
|
|
The questions you're asking are very easy, and you're obviously typing in your homework. Please try yourself, if you can't work this out, you should quit your course.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
write querry to display all books whose name start with 's'
please help me
pradeep kulkarni
|
|
|
|
|
SELECT * FROM <tablename>
WHERE COLUMNNAME LIKE 'S%'
|
|
|
|
|
Please don't do people's homework, it's not helping them
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
hi ,
this is santhosh in my project i want to store 3 images in one column in sqlserver and when the time of displaying(in front end c#) it should display seperately , plz tell me how to do this
thank you
santhosh
|
|
|
|
|
Why do you want to store three images in one column? Seems like a bit of a normalisation issue here.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
hi ,
in my project documentation is prepared like that that's why i am trying to store 3 images in one column plz help me
.......santhosh
|
|
|
|
|
write a querry to delete table.
pradeep kulkarni
|
|
|
|
|
drop table [dbo].[TableName]
I am Entry level person
|
|
|
|
|
DELETE TABLE WHERE <condition>
EX:DELETE TABLE EMP WHERE EMPNO = 1;
|
|
|
|
|
That doesn't work. You can't conditionally delete a table.
Either way, don't do the guys homework.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Hi,
I have two tables A and B.
A have a column col1 with list of values comma separated.
B also has a column col2 with list of values comma separated.
Now I should get records joining on both the columns where values in col1 = values in col2 all the values should match.How can I achieve this.
For example.
table A
col1
delhi,chennai,kolkata,mumbai
delhi,mumbai
delhi,chennai
table B
col2
delhi,mumbai
now i want to get all the records from table A where ever the column col1 has both delhi and mumbai
this is my problem.
Regards,
Uma
|
|
|
|
|
SELECT TABLEA.COL1,TABLEB.COL2 FROM TABLEA INNERJOIN TABLEB
ON TABLEA.COL1 = TABLEB.COL2
|
|
|
|
|
Try this:
select b.col2 from tableA a,tableB b where BINARY_CHECKSUM(a.col1) = BINARY_CHECKSUM(b.col2)
Girish Kumar Sharma
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
