Viewing 15 posts - 2,716 through 2,730 (of 14,953 total)
The default trace, at least for SQL 2008 R2 Dev Edition, does not include the T-SQL command for object creation.
I just ran this:
USE ProofOfConcept;
GO
CREATE TABLE dbo.DropMe (
ID INT);
GO
SELECT *
FROM fn_trace_gettable('C:\Program...
- 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
December 1, 2011 at 7:35 am
Do you need the report to show one company at a time, or to show the top 10 and summary rows for each company in one report?
You could easily do...
- 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
December 1, 2011 at 7:25 am
MysteryJimbo (11/30/2011)
GSquared (11/30/2011)
Otherwise, if you want to stick with Express, I'd look into RedGate SQL Data Compare for your sync tool.To remain neutral ...
Other data comparison tools are available.
Yep,...
- 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
December 1, 2011 at 7:15 am
Looks good.
You're welcome.
- 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
December 1, 2011 at 6:25 am
It all sounds right. No suggestions just spring to mind. If it were mine, I'd be playing with various aspects of it to see what I could break/unbreak....
- 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
December 1, 2011 at 6:22 am
If you're going on vacation, definitely taking a full break from work is needed. Otherwise, you miss the most important point of vacation in the first place.
I'm on-call 24X7...
- 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
November 30, 2011 at 6:49 am
Are you doing this just for yourself, or as some sort of commercial application? If commercial, you might want to look into a higher version of SQL Server, 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
November 30, 2011 at 6:44 am
There are easier ways to get "last month" and such type dates.
Take a look at this:
SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0)AS FirstOfCurrentMonth,
...
- 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
November 30, 2011 at 6:40 am
You can nest NullIf inside the IsNull.
ISNULL(NULLIF(Business_Line, ''), 'Others')
That will take a blank and turn it into a Null, and then run the ISNULL on it. If there's...
- 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
November 30, 2011 at 6:28 am
Check the backup histories in msdb. See if one of the user databases isn't backing up properly.
- 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
November 30, 2011 at 6:24 am
When you say "Import/Export Wizard", do you mean the one in SQL Server Management Studio (SSMS)?
If so, you have an option in that wizard of saving the import/export package. ...
- 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
November 30, 2011 at 6:23 am
Do you mean Row_Number()?
If so, do an inner query that gets the whole result-set and uses Row_Number() to number the rows, then an outer query that gets only the rows...
- 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
November 29, 2011 at 11:16 am
You could use BCP to bulk output all the tables in the source database, then truncate and BCP import into the target database. No need to buy a third...
- 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
November 29, 2011 at 11:12 am
stephanie.sullivan (11/29/2011)
djackson 22568 (11/29/2011)
I'd encourage you to take some time to just think over the holiday season, when there usually is less work going on
HA HA HA HA HA HA,...
- 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
November 29, 2011 at 11:02 am
inayatkhan (11/29/2011)
Is there any work around for this or I can create new temp...
- 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
November 29, 2011 at 10:57 am
Viewing 15 posts - 2,716 through 2,730 (of 14,953 total)