|
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 USERHISTORY The 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
|
|
|
|
|
Hello,
I had been running my application on Windows XP. It uses Jet 4.0 engine for database connection.
Now in my new system, I have installed Windows XP(sp2)which comes with MDAC 2.8 and it doesn't contain Jet engine. MDAC 2.5 is the last version that comes with Jet and the later versions do not.
I've tried but I can't install Jet or MDAC 2.5 as MDAC 2.8 is already installed with windows xp. I've installed office 2003 but Jet won't install with it.
How can I get Jet engine?
or
what is the alternate to JET engine in MDAC 2.8. can I just change the provider and keep my application working?
-- modified at 20:15 Thursday 18th January, 2007
|
|
|
|