|
SELECT Dat
FROM dbo.tblkmreading
WHERE DAT = GETDATE()
i have records pertaining to current date , the above query is not fetching the records.Please rectify it
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Thie GETDATE() Function returns the time now ie: 3/30/2008 12.35.05...
You will need to parse the GETDATE() result to return just MM/DD/YYYY and use his in your WHERE clause.
I don't speak Idiot - please talk slowly and clearly
|
|
|
|
|
select dat from tblkmreading where dat = convert(varchar(10) , getdate() , 103)
still getting the following error
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
dat is a datetime type
this is the another way i did , but no record is comming
select dat from tblkmreading where dat = convert(datetime , getdate() , 103)
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
Is the data stored as DateTime dataType in the database? You cant expect that your query will run at the exact time that a record is written.
In this case you may have to change your Where clause to BETWEEN and look from 12:00:00am to 11:59:00pm. Or Between 3/31/2002 12:00:00 And 4/1/2008 12:00:00
Sorry, I dont have a query editor handy to check this out
DECLARE @Start DateTime
SET @Start = '3/31/2008'
DECLARE @End DateTime
SET @End = '4/1/2008'
SELECT [Date] FROM TestData
Where [Date] Between @Start and @End
I don't speak Idiot - please talk slowly and clearly
|
|
|
|
|
Try this
declare @Now datetime
select @Now = convert(varchar,getdate(),103)
SELECT Dat
FROM dbo.tblkmreading
WHERE DAT >= @Now
I suspect your Dat column contains a time as well as a date. The above code trims off the time from getdate.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
dat is of datetime type
still occuring the error
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
What version of SQL Server are you using? My code works fine with 2000 and 2005.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
If Dat is date time format in your table then use following query
SELECT Dat
FROM dbo.tblkmreading
WHERE convert(varchar,Dat,103) = convert(varchar,GETDATE(),103)
If Dat is varchar in your table then use following query
SELECT Dat
FROM dbo.tblkmreading
WHERE convert(varchar,convert(datetime,Dat),103) = convert(varchar,GETDATE(),103)
smile
|
|
|
|
|
iam using oracle 10g and iam getting this problem.plz tell me steps that how could i solve this problem
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
|
|
|
|
|
Hai,
I am hari,
I have a .MDF file, i want to restore this file into sqlserver 2005. How to restore this file give me clear process.....urgent please
thanks
pinna
|
|
|
|
|
Right click on "Databases" and select "Attach". Follow instructions from there on.
|
|
|
|
|
Hai,
Thanks for your reply its working
Thanks
pinna
|
|
|
|
|
please i need help
i have teble withe the flowing colums (slotid,sectionid)
the primery key is bothe i have the sectionid only
and i want to update the slotid withe diffrent values for the same section
i use vb.net and i do not now how i spend 2 week to fand slotion please helpe if you can i use diffrent ways
|
|
|
|
|
Hi,
I have a datatable with 3 expression column bind to datagridview with a bindingsource but the column are not displayed in the datagridview.
when i debug, it was throwing a StronglyTypedException and the innerexception is InvalidCastException "can not convert dbnull to decimal".
Please help.
Thanks in Advance
Lookman
|
|
|
|
|
this question isnt about SQL, however if you are adding rows through SQLDataReader then you will need to check the column weather its null or not, if not then add
use this for checking null value :
DR.IsDBNull( <Column index> )
hope it will help
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
hi iam getting error 01033 errror and oracle is not started..will u give help in this regard thanks in advance
|
|
|
|
|
Can you give more details on the error. Also which operating system you are using and which version of Oracle etc.
Thanks
|
|
|
|
|
Hi Guys,
I tries to look around but I could not find an answer for this question. I need to run an SQl Query which retuns me the highest Unique Value and the lowest Unique value from the same column. For example. Lets say the column name is itemPrice, and has the following values: 10, 10, 11, 12, 12, 13, 14, 14 respectively. How can I get the 11 and 13 as the result of my query. I have tried DISTINCT, MIN, MAX and HAVING but to no avail. I am using SQL Server 2000.
If anyone can help, I would really be grateful.
Thanking in Anticiption.
Regards
Ali
|
|
|
|
|
Look at my solution below. I have created a temp table to depict your scenario. The query in bold is the one you need.
Explanation: I first selected unique values from the table using group by clause, then I just picked the min/max ones
Create table #MyTable
(
ItemPrice int
)
insert into #MyTable values(10)
insert into #MyTable values(10)
insert into #MyTable values(11)
insert into #MyTable values(12)
insert into #MyTable values(12)
insert into #MyTable values(13)
insert into #MyTable values(14)
insert into #MyTable values(14)
select * from #MyTable
Select min(ItemPrice) as MinUniquePrice, max(ItemPrice) as MaxUniquePrice
From
( select ItemPrice, Count(*) as ItemPriceCount
from #Mytable
group by ItemPrice
Having Count(*) = 1
) as MyTableWithUniqueItemPrices
drop table #MyTable
Happy querying,
Mehroz
modified on Sunday, March 30, 2008 5:18 AM
|
|
|
|
|
Thanks Guys!
That was really helpfull.
Regards.
|
|
|
|
|
select itemPrice from Table1<br />
where <br />
(select count(i1.itemprice) from Table1 as i1 where i1.itemprice=Table1.itemprice)=1
I Love SQL
|
|
|
|
|
Hi - I'm having trouble running a sql script with "GO" using DbCommand...
sql scripts looks like this:
<br />
declare EmpCur cursor for (<br />
select * from employee where ...<br />
)<br />
GO << This go leads to error when run by DbCommand (Although NO error when run on ASE isql -- against Sybase)<br />
... more processing ...<br />
GO<br />
Now, the code is like this:
DataSet oDataSet = new DataSet(strName);<br />
DbProviderFactory oDbProviderFactory = null;<br />
DbDataAdapter oAdapter = null;<br />
DbCommand oCmd = null;<br />
DbConnection oConn = null;<br />
<br />
oDbProviderFactory = CDataUtil.GetConnectionFactory(strProvider);<br />
oConn = oDbProviderFactory.CreateConnection();<br />
oConn.ConnectionString = strConnectionString;<br />
<br />
oCmd = oDbProviderFactory.CreateCommand();<br />
oCmd.CommandText = m_Cmd.RenderCommand(null); <br />
oCmd.Connection = oConn;<br />
<br />
oAdapter = oDbProviderFactory.CreateDataAdapter();<br />
oAdapter.SelectCommand = oCmd;<br />
<br />
oConn.Open();<br />
oAdapter.Fill(oDataSet, strName);
Error message is like this:
2008-03-28 17:53:20,875 [1] ERROR XXXComponent - SQL command failed.<br />
Message: ERROR [42000] [MERANT][ODBC Sybase driver][SQL Server]Incorrect<br />
syntax near 'go'.
devy
|
|
|
|
|
GO is not a SQL statement. Rather, it is, by convention, a separator which tells the script processor that this is the end of a batch: it should send what it's read so far to the database, wait for a response, then proceed with the next set of statements up to the next GO (or end of file).
You should split your script at GO statements.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Mike Dimmick wrote:
You should split your script at GO statements.
Thanks - multiple sql scripts? And multiple Cmd.Execute?.. hum
my scripts looks like this, not sure if I can really "split"...
<br />
declare EmpCur cursor for (select * from Emp where ...}<br />
go<br />
... processing ...<br />
fetch EmpCur into @empId ...<br />
while (@@sqlstatus=0)<br />
begin<br />
fetch EmpCur into @empId ...<br />
... some processing ...<br />
insert into #tmp (empId, salary) (@empId, @salary)<br />
end<br />
<br />
select * from #tmp<br />
go
As you can see, declare cursor and the rest of the script must be separated by GO.
devy
|
|
|
|
|
You don't need the GO statement after declaring the cursor. By doing this, your first statement gets compiled into its own batch and is executed independently from the rest of the code. You don't want to do this. The one GO statement at the end is sufficient.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|