Often times this request is followed up by the OP stating they are trying to determine if they can safely delete some table(s). The excellent query posted does contain the...

It is a bit more complicated than that. First of all you have to have ad hoc queries turned on, which...

Lynn Pettis (6/10/2013)

---

These are the improvements that have been added to SQL Server over the last few releases. IIRC, this was not the behavior in SQL Server versions from...

g_demetriou (6/10/2013)

---

Have you considered using SELECT INTO?

This would work with any result set, but would create a new table every time. You could either put some logic to create a...

So I was correct in my verbiage but my understanding of what was happening was incomplete for sure. I didn't realize that it creates the missing dependencies when you create...

dbman (6/10/2013)

---

I have attached a screenshot of my report. I have cleaned out the AccountNames though!

Now currently the user can select a Year and Period and a depot and a...

dbman (6/10/2013)

---

Hi Sean

Thanks for your help so far.

The Parameters I am tryin to pass are:

@Year @Period , @Depot @CountryCode

The actual report is a matrix report. The fields are:

...

In addition to needing more details as Stuart said, tables in sql have no concept of "first" or ordering of any kind. "First" indicates some sort of ordering to know...

Krishna1 (6/4/2013)

---

Thanks it worked for the missing tables.

But when i ran it showed me the procedures which are depedent of other procedures. First shot i thought the "called" procedure are...

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

You can find alcohol contents here. http://www.alcoholcontents.com/beer/%5B/url%5D

You really need to test the code you post, it won't work as written because your strings are not correctly wrapped with ''. We are now 4 days and 10...

Yes. nchar and nvarchar

http://msdn.microsoft.com/en-us/library/ms186939.aspx

I agree. The real world usage is pretty limited. But when you find yourself in the position of creating a dataset on the fly it can be a nice shortcut....

Erin Ramsay (6/7/2013)

---

Table Value Constructors.... I've been trying to do some research and some tests and I haven't come across anything that tells me why I should use a TVC...