Viewing 15 posts - 4,081 through 4,095 (of 14,953 total)
SQLRNNR (6/7/2011)
GSquared (6/7/2011)
GilaMonster (6/7/2011)
The client-from-hell is no more.
Woohooooooooooo!!! Time for you to celebrate!
I think that means either all of us have to buy you a drink, you have to...
- 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
June 7, 2011 at 11:26 am
GilaMonster (6/7/2011)
The client-from-hell is no more.
Woohooooooooooo!!! Time for you to celebrate!
I think that means either all of us have to buy you a drink, you have to buy all...
- 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
June 7, 2011 at 11:23 am
ALZDBA (6/7/2011)
What's with the watermark on our SSC ??Is it webmaster fun, or is SSC changing logo ?
What watermark?
- 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
June 7, 2011 at 11:20 am
The only difference I see between the rows is column Acct_Row, but your post says, "BUT I DON;T WANT OUTPUT BASE ON ACCT_ROW".
So, what do you want the output based...
- 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
June 7, 2011 at 11:19 am
CREATE TABLE #TempPermissions
(uid SMALLINT,
UserName VARCHAR(100),
Group_Name VARCHAR(100),
NT_Group VARCHAR(3),
...
- 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
June 7, 2011 at 9:59 am
The Acct_ID column is identical within the Acct_No value, but you say don't use the only value that actually does differentiate the rows. Your requirements, as stated, are different...
- 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
June 7, 2011 at 9:55 am
Create the temp table, use sp_MSForEachDB to insert into it from each database, then select from it after that.
- 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
June 7, 2011 at 9:43 am
mister.magoo (6/7/2011)
Steve Jones - SSC Editor (6/7/2011)
Craig Farrell (6/6/2011)
calvo (6/6/2011)
GSquared (6/6/2011)..."Billion" means two different things on different sides of The Pond.
wow. I was about to question this when I looked...
- 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
June 7, 2011 at 9:16 am
Definitely sounds like more fun than I usually allow myself to experience. 😛
If you aren't familiar with Between, are you familiar with using "In" in Where clauses, to filter a...
- 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
June 7, 2011 at 9:08 am
Steve, when you originally envisioned SSC, did you imagine it would end up having debates on the meaning of "philosophy" and the definitions of "1" as part of the content?
- 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
June 7, 2011 at 8:52 am
It really depends on what you're trying to do.
If you absolutely have to loop through results and get them into a single resultset, the best way is usually to insert...
- 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
June 7, 2011 at 8:49 am
You're running into issues with padding and implicit conversion.
- 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
June 7, 2011 at 8:46 am
Were files changed after the shutdown? Or have you confirmed corruption is the issue already?
You should be able to restore the model database from a backup. Do you...
- 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
June 7, 2011 at 8:41 am
Lowell (6/7/2011)
- 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
June 7, 2011 at 7:33 am
odanwada (6/7/2011)
My problem here is both the systems are not on same network... How to configure Replication if Both the servers are on different network...
Use SQL Server authentication, instead of...
- 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
June 7, 2011 at 6:55 am
Viewing 15 posts - 4,081 through 4,095 (of 14,953 total)