David Webb-200187 (11/7/2012)

---

Tempting to just say:

select ano from #x1 where ano <> 4

order by ano

but there must be some rule involving the 'dept' column in play here. What...

Thanks

This is Awesome, help me a lot.

Ray M (10/5/2012)

---

Ya, looks like it is satisfying your request. Is it the output you want?

Now, when using the query on your "Real" Table you may need to look at...

ok, i got it.

But in my requirement, I insert the output to another table and i...

The difference is an additional column(RowNumber) in second output.

Thanks for Your reply

My question is,

Is it possible in SQL, I increment Row Number while i am inserting...

anthony.green (10/1/2012)

---

Without data it is hard to trouble shoot, run the procedure with the parameters that where passed in and it should error at the same point, and then you...

Yes, The Job running with Stored Proc

Here is that sql command in that job.

Please...

anthony.green (9/24/2012)

---

compression, sparse columns, different columns have data populated (e.g 9 out of 10 columns are null in archive, but 0 out of 10 columns are null in the main...

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...

anthony.green (9/20/2012)

---

yes it will work after the ghost cleanup task has gone in and removed the data but your only buying yourself some time, you will need to get more...

right now i am deleting...

Thanks for...

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...

anthony.green (8/16/2012)

---

Make your inserts into your tempoary table a sub query

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...