i want to select only 15 words from table , plz reply me how can i do this???
View Complete Post
hi all
i have Price column in my table ( tbl1)
1.2 1.44 1 1.66
how can i select the prices that dont contain (.) ??
and then update it to add (.0) to it ???
this mean i will find (1) then convert it to ( 1.0)
please help me ;)
Hello!!
I need your help. Imagine that I have two tables:
Supose that my tables could be differnced by a number 1 is for ALUMN and 2 is for SPORT.
And the columns of each table too. So 1 is for IdAlumn, 2 is for Name and 3 is for Address. 1 is for IdSport, 2 is for Name 3 is for Players and 4 is for Description.
For example the combination of table 2 and column 3 is SPORT-Players.
Then I want to do an stored procedure that receives two parameters (the table, the column) @tab and&
How can I Create Select store proc for select Table but I will send the Table Name in Parmeter which table I want Like below.
Alter
Proc SelectAll
(
@Table
varchar(30)
)
as
select
My current query is
select Date= createdon , Total=count(*) from ReportDetail where reportid = 9 and (CreatedOn BETWEEN '07/01/2010' AND '09/30/2010') group by createdon order by createdon desc
return data like
2010-09-21 09:36:46.493 112 2010-09-21 08:33:12.667 114 2010-09-21 07:45:20.830 176 2010-09-21 07:33:34.340 114 2010-09-20 07:27:43.753 125 2010-09-17 10:04:27.120 75 2010-09-16 11:50:05.777 52
What I am looking for
2010-09-21 09:36:46.493 112 2010-09-17 10:04:27.120 75 2010-09-16 11:50:05.777 52
Basically for 9/21, I want to get only one latest row. Please advice.
Insert into ReportDetail( Partcipantid, Reportid)
select distinct ParticipantID , 9 from OpenCredit
except select ParticipantID, 9 from StoreCredit where Closed = 0
Issue is that when above select statement returns no row, it seems like no record is
Hall of Fame Twitter Terms of Service Privacy Policy Contact Us Archives Tell A Friend