todd.ayers (7/10/2013)

---

Well.... I have four fields called Stack ID, Location, Move Date, and Move Time.

The Stack ID refers to a bundle of wood and in that column we have multiple...

phoenix_ (7/10/2013)

---

To be honest with you I don't like dynamic sql because of quotation marks '' which are making whole code harder to read 🙂

So Instead of this I developed...

Oh be careful here Laurie. You suggested using dynamic sql which is a good choice here. However you committed a cardinal sin. You allowed for the parameters to be executed....

This will get you the first 3.

select name, backup_finish_date, backup_size from msdb.dbo.backupset

To get free space you will have to loop through all the databases and look at dbo.sysfiles.

--EDIT--

I should mention...

Here is a free...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

erikd (7/9/2013)

---

The .sql file that I started using to store interesting bits of code, things I wanted to play with, general interest, etc., is growing rather large and unwieldy. I'm...

LOL sounds like you are making good headway on this. Good thing...I am swamped at my actual job and don't have any time to dig back through this. 🙂

The good...

Just curious...you have users that have SSMS installed but you don't want them to be able to see the tables? What are you trying to accomplish here?

Is there a question here or are you simply explaining how you solved this?

You are welcome. Glad you got it sorted out.

Pretty sparse on solid details but I think I get the gist.

select *

from tableb b

LEFT join tablea a on a.Server = b.Server and a.AppName = b.AppName

where a.AppName IS NULL

What is failing? Are you getting an error message? Or is it a logic error? I am still confused as to what...

deepkt (7/9/2013)

---

Hi,

I have one requirement and need help.

I have a table:

CREATE TABLE MiscItems(ID INT, Description VARCHAR(50), DisplayOrder SMALLINT)

INSERT INTO MiscItems(ID,Description,DisplayOrder)

SELECT 100, 'A1',1

UNION ALL

SELECT 101,'A2',2

UNION ALL

SELECT 102,'A3',3

UNION ALL

SELECT 104,'A4',4

UNION ALL

SELECT...

I have no idea if Oracle or SQL pays more. I have never worked with Oracle much. You should focus on the areas of SQL server that you enjoy/are good...