Viewing 15 posts - 10,291 through 10,305 (of 14,953 total)
That should work.
The update audits are pretty standard. I don't use them, because any place I need to audit that, I need to know more than when it was...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:48 pm
Are you looking for that last time data in the table was changed, or the last time the table structure was changed (added a column, for example)?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:39 pm
Bruce W Cassidy (3/24/2009)
Bob Hovious (3/24/2009)
I console myself about aging by reminding myself that I'm only 34 in hex.
[font="Verdana"]There are 10 kinds of people in the world: those who understand...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:36 pm
Bob Hovious (3/24/2009)
Just try teaching pointers...
I did, back in the early 80s, when computers were still hand-cranked. People didn't trust me when I started counting from...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:33 pm
You'll need to expand and translated this to work with your actual tables and actual results, but here's something that will test them.
-- Create test tables
create table #A (
ProductID int...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:25 pm
Do you have a Numbers or Tally table? If so, then yes, it's quite easy to split without a loop. Actually, it's faster than it would be with...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:08 pm
lmu92 (3/24/2009)
umar iqbal (3/24/2009)
But if you want cheap solution and ... want to save money then it would be INDIA the great. oooooo
We have a saying over here in...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:05 pm
On something this complex, I would move each set of updates to it's own proc, and create one proc that calls each of those in turn. Try that, see...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:04 pm
You might want to look into SSRS 2008. It has some significant improvements over 2005.
I've had some problems getting earlier versions of SQL Server to connect to later ones....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 2:01 pm
I'm going to recommend taking a look at Full Text Indexing. Check it out, it will almost certainly do what you want, better than "like" statements will. Has...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 1:58 pm
I prefer to keep such in the database, in procs. That way, if a table needs to change, it's much easier to find all procs that depend on the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 1:52 pm
RBarryYoung (3/24/2009)
GilaMonster (3/24/2009)
RBarryYoung (3/24/2009)
Q: How many psychiatrists does it take to change a light bulb?
A: Only one. But it takes a very long time and...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 12:08 pm
Your query is using "nodes()" on "productRef", but there's only one productRef in your XML sample.
I've attached a query that will get the second result you want. The main...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 12:01 pm
foxjazz (3/24/2009)
GSquared (3/24/2009)
declare @ID int;
--
select @ID = productcontrolid
from productcontrol
where productcontrolid in
(select top 25 productcontrolid
from productcontrol
order by productcontrolid desc);
That'll get you an ID you can use for your update.
Then just...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 9:52 am
I tried creating a test table with a constraint that looks like it should restrict the hierarchy to one level, but I must be doing something wrong.
Here's the test table:
if...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 24, 2009 at 9:42 am
Viewing 15 posts - 10,291 through 10,305 (of 14,953 total)