brainy (1/21/2009)

---

select * from

FROM dbo.OPFORTE RIGHT JOIN (dbo.NAVMC RIGHT JOIN tblUnit_Ref ON dbo.NAVMC.UIC = tblUnit_Ref.UIC) ON dbo.OPFORTE.MEFUIC...

yisaaacs (1/21/2009)

---

Hi everyone,

how do i schedule a job to run for the previous day?

i have SQL extracting daily statistics and every morning at 9am i need to run a job...

I think i'm not clear on your exact requirement. What i understand is you need to populate this table (and may be others) at regular intervals for testing purpose. ...

I dont think i understood what you mean here...

i can't use Order by in Sub Query.

is...

Pls post your replies to http://www.sqlservercentral.com/Forums/Topic640431-338-1.aspx?Update=1

betsy.powlen (1/20/2009)

---

Hello everyone,

I can get this to run no problem, but it always says "0 records updated". I'm pretty sure it has something to do with where its looking for...

kuldip.bhatt (1/20/2009)

---

my questiion is

Suppose there is one table and it has one primary key it's type is Integer.

currrenlty this table has 20 rows but it's last indentity value...

Lynn Pettis (1/20/2009)

---

OR, create a table, mytable_new. Copy over just the records you wish to KEEP. Rename the current table (mytable) to mytable_old, then rename mytable_new to mytable.

Saves...

If this takes up lot of time and you need to delete appx 70% of your records, i might do it the other way.

change recovery model from FULL to Bulk...

kuldip.bhatt (1/20/2009)

---

That's right but then

what is the use of the set indentity ?

if we set it to max no value in the table.

so there no change in the table...

:w00t: Is there a rationale behind this weird behaviour?

Thanks for clarification Christopher :). I also searched few posts here on AD and groups and found this to be quite informative.

http://www.sqlservercentral.com/Forums/Topic498389-146-1.aspx

i was so slow!!

declare @str1 varchar(10)

set @str1='1234,578'

select right(@str1,len(@str1)-charindex(',',@str1))

output

----------

578

(1 row(s) affected)

Use default value in the money column.

create table #t1

(

col1 int,

col2 money default 0.00

)

--drop table #t1

insert into #t1 (col1)

select 1

union all

select 2

union all

select 3

select * from #t1

Output

=====

col1 ...