|
|
I want to display all data from my table except first three colunms. Is there any way to use "select * " query to see all colunms except first three? I'll greatly appreciate any help.
Thanks
|
|
|
|
|
You can do it in front-end programming languages really easily (in .NET you would iterate through the relevent columns returned in a DataReader).
It is really difficult to do within the database - you would have to dynamically construct a select statement based upon the table's column meta data . Generally, doing "select * from xxxx " or doing an insert without explicitely specifying each column is considered to be bad practice for production code.
|
|
|
|
|
Create a view on the table ignoring or selecting only those columns required
then use "SELECT *" on the query
Regards
KP
|
|
|
|
|
hi all
i have an empoyee table with a column Dateofbith
i need to select the employees whose birthday with in coming 14 days..
how i select it.?
thnks in advance..
All I ever wanted is what others have.... CrazySanker
|
|
|
|
|
For SQL-Server it would be something like:
select * from Employee
where datepart(dy, BirthDate) between datepart(dy, GetDate()) and datepart(dy, GetDate()) + 14
or 365 + datepart(dy, BirthDate) between datepart(dy, GetDate()) and datepart(dy, GetDate()) + 14 The "or" condition traps the situation where today is in the last couple of weeks of December and the employee's birthday falls at the start of January. You might need to play with the boundary conditions (i.e. the "365" and "14" constants).
Regards
Andy
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message".
|
|
|
|
|
hi,
Thank u for ur reply.
I am using MSSQL 2000.
it shows some error ..
wat you mean by 'dy'??
All I ever wanted is what others have.... CrazySanker
|
|
|
|
|
You could do this by selecting all records where the dateofbirth was between getdate() and dateadd(dd, getdate(), 14).
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thank you for ur reply..
I think, there is some logic problem in ur reply.
Means
"where the dateofbirth was between getdate() and dateadd(dd, getdate(), 14)"
Suppose an employe 'Sanker' whose DOB is "29/july/1982"
According ur reply,in select query the getdate value is 27/July/2007 and add 14 to it will return 10/aug/2007
do you think employee 'Sanker' will select from ur query??
All I ever wanted is what others have.... CrazySanker
|
|
|
|
|
It would.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
I got the solution..
i fell this is very simple one..
select EmployeeID,EmployeeName
from
TblEmployeeMaster
where
datediff
(
dd
,convert(datetime,'1900/'+cast(month(getdate()) as varchar)+'/'+cast (day(getdate()) as varchar),111)
,convert(datetime,'1900/'+cast(month(DateOfBirth) as varchar)+'/'+cast (day(DateOfBirth) as varchar),111)
) between 0 and 14
All I ever wanted is what others have.... CrazySanker
|
|
|
|
|
Hi there,
I have problem with caling my T-SQL scalar function.
SET ANSI_NULLS ON<br />
SET QUOTED_IDENTIFIER ON<br />
GO<br />
<br />
-- =============================================<br />
-- Author: <Author,,Name><br />
-- Create date: <Create Date, ,><br />
-- Description: <Description, ,><br />
-- =============================================<br />
CREATE FUNCTION dbo.func(@param int)<br />
RETURNS bit<br />
AS<br />
BEGIN<br />
DECLARE @ret bit;<br />
<br />
IF EXISTS (SELECT id FROM [dbo].myTmpTab WHERE id=@param)<br />
BEGIN<br />
set @ret=1;<br />
END<br />
ELSE<br />
BEGIN<br />
set @ret=0;<br />
END<br />
RETURN @ret;<br />
END<br />
GO
I want to call it in C# code, but i cant it even call in MSSQL Server Mamagment Studio (SELECT myTmpDB.dbo.func(1) ) and i get this msg:
Msg 557, Level 16, State 2, Line 1<br />
Only functions and extended stored procedures can be executed from within a function.
Is there any1 who know how to solve it? Im quite sure it would work on Sybase as i have done smthin similar about year ago
-------------------
n00b @ pr0grAmiNg
|
|
|
|
|
|
I did it But its useless for me to call function from stored procedure because i cant get my ret value.
-------------------
n00b @ pr0grAmiNg
|
|
|
|
|
Seems to work with SQL-Server 2000 (after I changed the table name to one of mine). Could "func" be a reserved word under 2005?
|
|
|
|
|
names of tabels and function are changed so thats not an issue. Maybe its caused by the fact DB is on MSSQL 2000 Server? Ill do some research this weekend.
-------------------
n00b @ pr0grAmiNg
|
|
|
|
|
Bizarre - I've copied your code exactly and it works fine for me.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
hi all,
how to handle this case
just i write in this way
insert into e.empone values('kris45','sai','20','prg') where e.empid in (insert into d.deptone values ('20','dev','prg','kris45')
where e.empid in (insert into p.profone values('prg','dev','kris45') where e.empid = d.empid and e.empid = p.deptid
sai krishna
|
|
|
|
|
Get values in store procedure
if not exists(Select * from empone where val1=@val1 and val2=val2 and val3=@val3 and val4=@val4)
then write insert statement.
God Bless you.
Always do good to others
|
|
|
|
|
how can I get second highest date from a sqltable using a query???
hiiiiii
|
|
|
|
|
earlier some time back (in may/jun) i've given this solution for getting nth max value. try the same must work for you
DECLARE @nth as bigint
SET @nth = 10
SELECT * FROM TblA AS a WHERE @nth = (SELECT COUNT(ColA) FROM
TblB AS b WHERE b.ColA >= a.ColA)
@nth is the variable to hold the 1 for getting 1st max, 2 for 2nd max, .....
Regards
KP
|
|
|
|
|
run this query
it will return the second highest date
SELECT max(mdate) FROM <tablename> where mdate not in (SELECT max(mdate) FROM <tablename>) order by 1 desc
Harry
|
|
|
|
|
Dear all,
i am a novice programmer to sqlserver i just want a condition for how to insert the values into 3 tables of data at a time by considering that the three tables contains values if one of the table does not contain any values then it wont to be inserted into any of the tables
sai krishna
|
|
|
|
|
Not sure if this is what you want...
IF EXISTS (SELECT TOP 1 1 FROM tblTable1 WHERE col1 = 'abc') AND
EXISTS (SELECT TOp 1 1 FROM tblTable2 WHERE col2= 'def') AND
EXISTS ( SELECT TOP 1 1 FROM tblTable3 WHERE col3= 'xyz' )
--Do Something
ELSE
--Do Nothing
Eliz.K
www.oin1.com
|
|
|
|
|
Hi,
I am integrating Reporting services with my web application.
Fisrt i designed the report and deployed on the report server.My report is using 4 parameters Location,UserID,LastName,Firtsname.I am able to view the report by passing the parameters.This is all done throw report server.
But i am using my own controls(Textboxes) in my web page to pass this parameters.so i paced four text boxes and a ReportViewer Control.i am able to bind this parameters with the parametrs on report server.
but when i run the page the reportviewe control also showing the parametrs of report server.I dont need this because i already using my TextBoxes.so how to hide the reportserver parameters on Reportviwercontrol.
I hope Ypu guys understood my question. Simply i want hide report server parameters on reportviewer control
Plaese can any body help me?
Thanks
Karuna
Karuna
|
|
|
|