Results after creating table and database:

checkDatenamedatabase_idcreate_datefile_typedb_file_namedb_file_size

2014-11-19 09:42:22.460db_work1152014-11-19 09:41:46.597ROWSdb_work4096

2014-11-19 09:42:22.460db_work1152014-11-19 09:41:46.597LOGdb_work_log1024

Results after insert into:

checkDatenamedatabase_idcreate_datefile_typedb_file_namedb_file_size

2014-11-19 09:43:58.207db_work1152014-11-19 09:41:46.597ROWSdb_work19456

2014-11-19 09:43:58.207db_work1152014-11-19 09:41:46.597LOGdb_work_log76216

I then deleted the table and database, then recreated them. Ran the SQL...

SQL to create the database and table:

DROP DATABASE db_work

;

CREATE DATABASE db_work

;

USE db_work;

CREATE TABLE target_table

(

pNum CHAR(100),

pMod INT

)

;

The Insert Into statement:

INSERT INTO db_work.dbo.target_table

SELECT pNum,

pMod

FROM source_db.dbo.source_table

;

The log file size check SQL:

SELECTGETDATE() AS...

I'm having issues again posting SQL code here.

But thanks for the link. This tells me for most of what we do some logging is still going to occur, tables...

I got a little more detail on how this was tested today. The first thing that was done was to create a new database and a new empty table...

Don't feel bad about hating stored procedures, there are others that prefer not to use them. 🙂 That being said they do have a purpose and aren't that much...

I had to attach the SQL in the text file, some reason it wouldn't allow me to post it.

No I didn't try anything other than the database and what I wanted to search for. Just tried on a real small database, got it back in less than...

OK this isn't the same SQL, this is something I got back in March, probably from this site, didn't keep who wrote it, sorry about that, I'm trying to do...

Sean Smith-776614 (10/22/2014)

---

below86 (10/22/2014)

---

I like the idea of this but the only issue I have is this, If I want to run this against our production warehouse I'm not going...

I like the idea of this but the only issue I have is this, If I want to run this against our production warehouse I'm not going to have rights...

To me it looks like someone was looking to add the code persontype = 'sp', but just put it in the wrong place. I've seen code like that before,...

What I see as another trick question. In your example data you see before answering the question you have values that would give you the rankings of:

CustomerIDRank

4 ...

I got the same thing.

pietlinden (9/28/2014)

---

DECLARE @currMonthNum INT,

@lastDayMonth INT

SET @currMonthNum = DATEPART(MM, GETDATE())

IF @currMonthNum IN (1, 3, 5, 7, 8, 10, 12)

SET @lastDayMonth = 31

IF @currMonthNum = 2

SET @lastDayMonth = 28

IF @currMonthNum IN (4,...

How about one more version?

SELECT DATEPART(DD, DATEADD(DD, -1, DATEADD(MM, 1, DATEADD(DD, -(DATEPART(DD, GETDATE()) -1), GETDATE()))))