Viewing 15 posts - 376 through 390 (of 569 total)
Hi,
Bit question?
You’re working with 2000 or 2005?
ARUN SAS
June 8, 2009 at 11:54 pm
rafejeyaraj (6/8/2009)
BEGINdeclare @tempUse varchar(20)
set @tempUse='USE' + '' + '@tempUse'
exec(@tempUse)
Hi,
You need to create the DB Tables in the New DB (in the Sp) or in the Current DB (Running DB)...
June 8, 2009 at 11:34 pm
Duplicate posting,
Don’t answer here
Answer to: http://www.sqlservercentral.com/Forums/Topic730655-169-1.aspx
June 8, 2009 at 9:39 pm
rafejeyaraj (6/8/2009)
but doesnt work properly, its through syntax,invalid object name etc... error.
Hi,
Your are created the temp table or the DB table, (why because the users who run the stored procedure...
June 8, 2009 at 9:20 pm
Hi,
Try this,
SELECT E.IDEmisionSeriada,
YEAR(S.FechaPrestamo) AS [Año],
-- START
(case when MONTH(S.FechaPrestamo) <=6 then 'First Seme' else 'Second Seme' end)Semester
-- END
COUNT(*) AS Seriadas,
@FechaIni as FechaInicial,
@FechaFin as FEchaFinal,
@Tipo as Material
from dbo.Servicios...
June 7, 2009 at 10:16 pm
EIAnd (6/7/2009)
In this query i group by Year, but i need to group whit semester, how can i do this?
Hi,
A bit question,
In your statement which one is the semester column?...
June 7, 2009 at 9:17 pm
Dan Fran (6/5/2009)
I am selecting rows from Table A, but would like to count the number of records in Table B (which has foreign key to A).
Hi,
Try this
Select A.ID,A.COLUMN,A.COLUMN2,
(Select count(B.ID)...
June 5, 2009 at 9:42 pm
Gordana.Lazic (6/5/2009)
From QA I got results, but from VB I got empty grid.Stored procedure stopped on insert step from VB.
Hi,
Check the user permission in the DB1/DB2 and for the table1/2
ARUN...
June 5, 2009 at 9:31 pm
Hi,
I don’t know why you need the top 4 maximum score; the real situation may be the sum of the score grate than 50 or 60, however you got the...
June 4, 2009 at 11:51 pm
arijit (6/4/2009)
I would like to have sum this 4 marks in a single SQL and not by putting these marks in a temp table and summing them.
Hi,
Try this
create table #temp
(
studentID...
June 4, 2009 at 10:31 pm
jonathanmreynolds (6/2/2009)
I basically am trying to know what my "email capture rate" is...basically Query#1/Query#2.
Hi,
try this,
select count(N.PHONE_NUMBER),
(count(N.PHONE_NUMBER)/RN.RESV_NAME_ID_COUNT)email_capture_rate
from
NAME_PHONE N,
(select NAME_ID,
COUNT(RESV_NAME_ID)RESV_NAME_ID_COUNT
FROM RESERVATION_NAME
WHERE BEGIN_DATE BETWEEN PMS_P.BUSINESS_DATE -30 AND PMS_P.BUSINESS_DATE) RN
WHERE N.NAME_ID=RN.NAME_ID
AND N.PHONE_TYPE='EMAIL'
ARUN...
June 2, 2009 at 9:24 pm
Hi,
Use the CURRENT_TIMESTAMP instead of the getdate()
ARUN SAS
June 2, 2009 at 3:55 am
Kingsleen Solomon Doss (6/2/2009)
i have to get in seperate row one by one
Hi,
Also try this to store the record one by one
declare @RESULT varchar(1000)
select @RESULT = ''
select @RESULT = @RESULT...
June 2, 2009 at 3:33 am
Hi,
Ok, suppose you need to show the records having the date range of current date,
Then you try Tom Brown coding to get the result.
Select * from yourtable where getdate()...
June 2, 2009 at 3:06 am
info (6/2/2009)
I have a table with news-items with a start- and end-date.
Hi,
Can you show the table schema with data?
ARUN SAS
June 2, 2009 at 2:09 am
Viewing 15 posts - 376 through 390 (of 569 total)