kat35601 (7/23/2015)

---

what I get with the original query is a total box count for the UOMPSCHEDULENUMBER for 072115-01 I would get 812 for every line but with these I...

crowegreg (5/7/2015)

---

I haven't tried any other methods of deleting the records. I figured this would be a quick method, and I'm stuck here.

I'll also try a pass through query.

One other...

rightontarget (7/21/2015)

---

Ran DBCC SHRINKFILE (1, TRUNCATEONLY); with not much success. I am trying to shrink this d/b because I am taking backup of it and restoring it to another server...

jackimo (7/23/2015)

---

I'm dynamically building a BCP command and executing it.

If I manually execute the command like so;

EXEC master..xp_cmdshell 'bcp "exec myDB.dbo.EXTRACT_data ''2015-06-01 00:00:00.000'', ''2015-06-30 23:59:59.000'' " queryout "n:\results\data.txt" -U my_user...

SSRS Newbie (7/23/2015)

---

Hello All,

I've a report that manages Scheduled Ship Date based on the Requested Delivery Date. We normally ship every Monday of the week so I've Scheduled Ship Date...

What you need to worry about first is what SUM you want when there's more than one value specified. Do you want the SUM across all specified numbers? ...

You're welcome... and been there, and DOH!...

xtimesu (7/22/2015)

---

Please help!

Need query to provide rolling 12 month and prior year rolling 12 month. Example: If this is July I would want Jun 14-July 15 and Jun 13-Jul 14

I...

ted.motter (7/23/2015)

---

Hello,

I've got an problem, but I don't know how to fix it.

When I procces my cube I got an error.

It's a little bit strange because I processed my cube...

richardmgreen1 (7/23/2015)

---

Hi all

I've got an SSIS package built in VS2010 that needs to connect to a SQL2012 database (the database already exists with tables, etc).

I've set up a SQL-only login...

GilaMonster (7/23/2015)

---

Repeating exactly the same thing again and again isn't giving me more detail!

A backup is of a database, an entire database, not a query. You cannot put a...

I'm not sure anyone understood the original posters requirement, which is to show all rows that match the max value. The one "sticking point" is that he didn't...

SQL Hamster (7/22/2015)

---

If you're data is still in the source systems, I would suggest ETL'ing them into tables in a single database. Then you could easily do a SQL...

jghali (7/22/2015)

---

Hi sgmunson,

The systems are independent but structure can be identical.

I'm still in testing mode (so I'm testing on the same system) but eventually this will be going...

jonathanm 4432 (7/22/2015)

---

Hi all,

So I got the following example below to try to help me get these files copied from one location to another. The example was:

NET USE \\RemoteServerName\IPC$ /u:server\user...