Lowell, that's a neat trick!

Next step would be some refinement to return the actual SQL needed, ready for cut & paste. This sort of thing (borrowing your code):

IF OBJECT_ID('tempdb..#temp', 'U')...

I think you are out of luck. There is no magic 'reduce the size of files without shrinking them' command.

First thing I'd suggest is removing this line:

INNER JOIN dbo.Drops D ON J.JobID = D.JOBID

As it is no...

padmakumark26 (12/8/2016)

---

With user which have default schema we can access object without specifying schema name right ?

Like select * from table .

But i cannot access like that it is...

I...

Maybe you can use an external SMTP provider. Have a look here[/url].

dianerstein 8713 (12/7/2016)

---

I only want 1 parameter value that can be obtained from the query where the parameter value = '16-17'. However I want to include logic that will also...

Can you use something like this?

IF NOT EXISTS(SELECT * FROM sys.indexes WHERE object_id = object_id('schema.tablename') AND NAME ='indexname')

--Do stuff

dianerstein 8713 (12/7/2016)

---

In a t-sql 2012 column I have a column called test1 defines as (varchar(10),not null) in a table called tab. The values in this column look like '16-17'...

wendy elizabeth (12/7/2016)

---

In an existing sql server 2012 database, there are lots of columns defined as (bit,null). When the value is checked to be = 0, the results are returned...

paul 69259 (12/7/2016)

---

Thank you Thom,

That appears to be nearly there the only problem now is if a job doesn't have any additional drops it doesnt show the collection and...

You had the same idea as me, though STUFF is not doing much here other than removing an unwanted character;...

So ... a single row in the Jobs table can have multiple related rows in the Drops table, is that correct?

If so, you could make use of the FOR XML...

clucasi (12/7/2016)

---

i am trying to convert xlsx to xls using DTS script task,but because the server hasn't got excel installed its throwing an error..Would it be ok to load MS...

Brandon Groom (12/5/2016)

---

I had this error also and it turned out to be a source code promotion merge issue with the project file. After the merge, the parameter ID in...