help on find data

This is a discussion on help on find data within the sqlserver-datamining forums in Data Warehousing category; dear all i have that call xyz that has data taken from a field machine this table has data structure like this ================================================== ==================== = QUEUE (type nvarchar) === TIME ( type nvarchar) == DATA ( type nvarchar) ==== ================================================== ==================== = x1 ==== 2008-03-07 12:17:50.274 == 23.0034 == = x1 ==== 2008-03-07 16:17:50.274 == 28.0034 == i need to create a query that will ask me to select the variable ( which is x1 ) the the intervale of data and time ( for ex. from 2008-03-07 to 2008-03-07 for day and time of houre is between hour 12:00 to 20:00 and ...

Go Back   Database Forum > Data Warehousing > sqlserver-datamining

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-26-2008, 12:24 PM
Default help on find data

dear all
i have that call xyz that has data taken from a field machine
this table has data structure like this
================================================== ====================
= QUEUE (type nvarchar) === TIME ( type nvarchar) == DATA ( type
nvarchar) ====
================================================== ====================
= x1 ==== 2008-03-07 12:17:50.274 ==
23.0034 ==
= x1 ==== 2008-03-07 16:17:50.274 ==
28.0034 ==


i need to create a query that will ask me to select the variable ( which is
x1 ) the the intervale of data and time ( for ex. from 2008-03-07 to
2008-03-07 for day and time of houre is between hour 12:00 to 20:00 and give
the the value
how can i do this in sql knowing that are field are nvarchar type
your's
wael



Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 03:45 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.