Viewing 15 posts - 1,261 through 1,275 (of 14,953 total)
Glad we could help.
And don't worry, we don't apply the death penalty until the third time you post a question without fulfilling all possible requirements on it. :w00t:
- 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
July 12, 2012 at 6:17 am
I think you'd be best off building a custom service for that. Should be simple enough to build a .NET service that you grant access to the tables 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
July 12, 2012 at 6:11 am
Happen to know where to get a list of all the time-zone abbreviations? I tried a quick search online, including a couple of wikipedia articles, and couldn't get anything...
- 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
July 10, 2012 at 11:51 am
Steve Jones - SSC Editor (7/10/2012)
jay-h (7/10/2012)
SQLRNNR (7/10/2012)
If you can show that there is data to support a decision, it is more likely to be well received than one...
- 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
July 10, 2012 at 11:47 am
Should the code be sensitive to Daylight Time vs Standard Time (US), or should it rely on "EDT" vs "EST" in the input?
If sensitive without the input being modified, should...
- 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
July 10, 2012 at 11:14 am
Without your table structure and some sample data, we're left guessing on parts of this, and left doing more work than would be necessary if you provided that. We're...
- 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
July 10, 2012 at 11:07 am
How about something like this?
CREATE VIEW dbo.Rnd
AS
SELECT NEWID() AS R ;
GO
ALTER FUNCTION dbo.character_scramble
(@OriginalVal_in VARCHAR(MAX))
RETURNS VARCHAR(MAX)
AS
BEGIN
...
- 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
July 10, 2012 at 10:46 am
Jeff Moden (7/10/2012)
ChrisM@Work (7/10/2012)
Jeff Moden (7/9/2012)
- 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
July 10, 2012 at 9:30 am
I'm used to using GUIDs instead of identities for Merge Replication, specifically to avoid these kinds of problems.
Assuming you don't have the option of switching to those at this late...
- 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
July 10, 2012 at 9:25 am
Jeff Moden (7/10/2012)
SQLKnowItAll (7/10/2012)
ravigour2000 (7/10/2012)
Thanks Rookie it worked. 🙂
Hmm... So, because it worked on a set of 3 records you will accept it? Do you even know what that is...
- 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
July 10, 2012 at 9:14 am
ChrisM@Work (7/10/2012)
GSquared (7/10/2012)
- 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
July 10, 2012 at 8:55 am
thadeushuck (7/10/2012)
Gut Feel is a baby boomer approach. The old "establishment" managers and politicians just need to retire...:)
I'll assume by the smiley at the end that this was meant sarcastically/facetiously.
I'm...
- 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
July 10, 2012 at 8:52 am
There are times when cursors are the best or even the only viable solution. No question about that. Generally speaking, avoid them. But in specific cases, they're...
- 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
July 10, 2012 at 8:46 am
Just looked in Jeff's old article on running totals, and on his PC, the quirky-update running total on a million rows of data was about 6 seconds. Assuming margin-of-error...
- 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
July 10, 2012 at 8:41 am
The prior attempt is still rolling back, so I modified the script as follows:
USE tempdb
GO
IF OBJECT_ID(N'tempdb..Simpletable2') IS NOT NULL
DROP TABLE Simpletable2 ;
IF OBJECT_ID(N'tempdb..vwRunningTotals2') IS NOT...
- 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
July 10, 2012 at 8:28 am
Viewing 15 posts - 1,261 through 1,275 (of 14,953 total)