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...

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...

Yep,...

Looks good.

You're welcome.

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....

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...

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...

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,

...

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...

Check the backup histories in msdb. See if one of the user databases isn't backing up properly.

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. ...

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...

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...

stephanie.sullivan (11/29/2011)

---

djackson 22568 (11/29/2011)

---

HA HA HA HA HA HA,...

inayatkhan (11/29/2011)

---

like query is not much simple here I just create simple query to show the issue.

Is there any work around for this or I can create new temp...