Viewing 15 posts - 1 through 15 (of 61 total)
David Webb-200187 (11/7/2012)
select ano from #x1 where ano <> 4
order by ano
but there must be some rule involving the 'dept' column in play here. What...
November 7, 2012 at 3:17 pm
Ray M (10/5/2012)
Now, when using the query on your "Real" Table you may need to look at...
October 5, 2012 at 2:02 pm
Sean Lange (10/3/2012)
select *, ROW_NUMBER() over (PARTITION BY cStudentId Order by dtEnrollmentDate) as RowNum
from #temp1
ok, i got it.
But in my requirement, I insert the output to another table and i...
October 3, 2012 at 12:09 pm
@SQLFRNDZ (10/3/2012)
Can you tell me where is the difference in your 2 outputs above ?
The difference is an additional column(RowNumber) in second output.
October 3, 2012 at 12:08 pm
Sean Lange (10/3/2012)
This should do it.
ROW_NUMBER() over (PARTITION BY cStudentId, Order by tEnrollmentDate)
Thanks for Your reply
My question is,
Is it possible in SQL, I increment Row Number while i am inserting...
October 3, 2012 at 11:47 am
anthony.green (10/1/2012)
October 1, 2012 at 8:41 am
anthony.green (10/1/2012)
Find out what the job runs and debug it, could be SSIS packages, stored procs etc.
Yes, The Job running with Stored Proc
Here is that sql command in that job.
Please...
October 1, 2012 at 8:12 am
anthony.green (9/24/2012)
September 24, 2012 at 9:29 am
tim_harkin (9/20/2012)
surma.sql (9/20/2012)
That table has all historic info.
that table contains all user archive log entries for application. and it will starts from last 2 years. I already put red flag...
September 20, 2012 at 12:49 pm
anthony.green (9/20/2012)
September 20, 2012 at 10:12 am
anthony.green (9/20/2012)
You will have to do 1 or more of the belowDrop objects
Delete data
Add more drive space
Enable AutoGrowth if disabled
Remove unnessesary files from the file system
right now i am deleting...
September 20, 2012 at 8:46 am
anthony.green (8/17/2012)
run query in ssms, results to grid, right click top left hand blank thing to select the whole result set including headers, then right click, save results as
Thanks for...
August 20, 2012 at 10:20 am
Please help me too this
How i dump into csv file using Export Wizard
declare @CurrentSchoolYear int
select @CurrentSchoolYear = iCurrentSchoolYearCode from [STARS-DAYB-SRV.PGHBOE.LOC].STARS.dbo.tblSysVariables
; WITH Students AS
(
SELECT DISTINCT
cStudentId
FROM [STARS-DAYB-SRV.PGHBOE.LOC].STARS.dbo.tblStudentSchoolHistory...
August 16, 2012 at 11:47 am
anthony.green (8/16/2012)
something like this
declare @CurrentSchoolYear int,
@dtBeginDateIA3 datetime,
@dtEndDateIA3 datetime,
@dtBeginDateIA2 datetime,
@dtEndDateIA2 datetime,
@dtBeginDateIA1 datetime,
@dtEndDateIA1 datetime,
@dtBeginDateIA datetime,
@dtEndDateIA datetime
select @CurrentSchoolYear = iCurrentSchoolYearCode from tblSysVariables
SELECT @dtBeginDateIA3...
August 16, 2012 at 8:38 am
Viewing 15 posts - 1 through 15 (of 61 total)