Viewing 15 posts - 4,636 through 4,650 (of 15,381 total)
crookj (6/3/2014)
jasona.work (6/3/2014)
JAZZ Master (6/3/2014)
SQLRNNR (6/3/2014)
mutantturtle
Ninja
Warrior
Sensei
June 3, 2014 at 9:00 am
Ananth@Sql (6/2/2014)
Thanks you so much sean.Thanks alot
You're welcome. Hope that worked for you.
June 3, 2014 at 7:10 am
JAZZ Master (6/3/2014)
crookj (6/3/2014)
Ed Wagner (6/3/2014)
BWFC (6/3/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
JAZZ Master (6/2/2014)
Ed Wagner (6/2/2014)
whereisSQL? (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/2/2014)
scienceMath
Algebra
Adademics
College
Expensive
Cheap
Trick
Shame
Embarrass
Humiliate
Debase (not dbase)
corrupt
Politicians
June 3, 2014 at 7:08 am
SQLRNNR (6/2/2014)
Sean Lange (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??No kidding. Seems to be blockhead Monday. 😀
You saying we should...
June 2, 2014 at 12:56 pm
vinpes (6/2/2014)
In Italy the tax office requires a complete seq. number for invoices 🙁
Can you just use a normal process (identity/sequence) for use in the system and then create another...
June 2, 2014 at 12:54 pm
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??
No kidding. Seems to be blockhead Monday. 😀
June 2, 2014 at 12:46 pm
With all the info revealed we can do this pretty easily.
with MyNewValues as
(
select weekdate, ROW_NUMBER() over(order by weekdate) as RowNum
from Tab1 t
)
update t
set Cdate = DATEADD(DAY, -1 * (RowNum *...
June 2, 2014 at 12:45 pm
JAZZ Master (6/2/2014)
Ed Wagner (6/2/2014)
whereisSQL? (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/2/2014)
scienceMath
Algebra
Adademics
College
Expensive
Cheap
Trick
June 2, 2014 at 12:33 pm
Ananth@Sql (6/2/2014)
Thanks you sean lange for the quick replies.you can use the wdate the first column for ordering.(May be i was given wrong sample data)
Do you have a primary key...
June 2, 2014 at 12:33 pm
digdave7 (6/2/2014)
June 2, 2014 at 12:27 pm
Ananth@Sql (6/2/2014)
i want to set the Cdate seven days less than the rundate for the first Aid and 14 days less than the run date for the
second entry in...
June 2, 2014 at 12:05 pm
I don't want to pile on here but a view is the absolute worst possible place you could use NOLOCK. There really is no good place but a view is...
June 2, 2014 at 11:58 am
Ananth@Sql (6/2/2014)
(
weekdate date,
Aid int,
Cid i nt,
Cdate date
)
--The number of entries for a clientid may varies ,5 entries for 01...
June 2, 2014 at 11:55 am
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
JAZZ Master (6/2/2014)
Sean Lange (6/2/2014)
SQLRNNR (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
whereisSQL? (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean...
June 2, 2014 at 10:34 am
Ed Wagner (6/2/2014)
JAZZ Master (6/2/2014)
Sean Lange (6/2/2014)
SQLRNNR (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
whereisSQL? (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj...
June 2, 2014 at 10:23 am
Viewing 15 posts - 4,636 through 4,650 (of 15,381 total)