Seems to me if you don't know, you don't know.

There's really no point in cramming for an interview trying to fill in simple quick answers to concepts you're not good...

TheSQLGuru (11/14/2013)

---

Nevyn (11/14/2013)

---

To DBAs, this isn't important, because *we* know that identity columns are arbitrarily assigned. However, the users of the report in question are accustomed to seeing mostly consecutive...

This one is not so bad since you are looking for a break in an integer sequence.

Just outer join to the next record (id+1) and check for the null.

This will...

PugMaster (2/19/2014)

---

Hi Sean

Unfortunately it is a system I have inherited and the table holds 6.8 million rows there is another column that flags if the second column is a child...

If you gave us some sample data and DDL we could likely make this much simpler.

Your example doesn't really tell us all we need to know.

I imagine what you...

Luis Cazares (2/12/2014)

---

CROSS APPLY works similar to an [INNER] JOIN and OUTER APPLY works similar to LEFT [OUTER] JOIN. Maybe that will help you to understand it better.

This article series...

To convert to a date, you need to be able to specify the format of the dates you are sending in. And it does not sound like you know...

Technically, every time I have run that command, it has started raining sometime thereafter. Not always right away, but my server isn't very powerful.

So I think the options were...

Yep. Was trying to...

create table dimdate (datevalue date)

create table totalsdata (datevalue date, totalvalue int)

insert into Dimdate

values(getdate())

,(dateadd(day, 1,getdate()))

,(dateadd(day, 2,getdate()))

,(dateadd(day, 3,getdate()))

,(dateadd(day, 4,getdate()))

,(dateadd(day, 5,getdate()))

,(dateadd(day, 6,getdate()))

,(dateadd(day, 7,getdate()))

,(dateadd(day, 8,getdate()))

,(dateadd(day, 9,getdate()))

,(dateadd(day, 10,getdate()))

,(dateadd(day, 11,getdate()))

,(dateadd(day, 12,getdate()))

insert into TotalsData

values(getdate(), 1)

,(dateadd(day, 3,...

D'oh!

It was too early in the morning and I did it the old way

You look like you are on the right track. If you created a calendar table it might simplify and speed things up (instead of having the dateparts), but your...

Well, you can build the connection string with an expression appending the application name to a string parameter, and then map the parameter to the environment, I think.

Haven't done it,...

I would not mess around with logins at all.

The easiest for you would be to agree with your team on a package password (it is seperate from any connections/users).

Change the...

1) Develop using own accounts. One service account would be a major headache.

2) I am liking project deployment model so far. The catalog and environments make deployments easier. ...