Kevlarmpowered (5/16/2014)

---

Right now I have to do something like this and it is time consuming every time I have to query a specific table...

SELECT lots_of_columns

FROM table

WHERE (column5 = '1'...

hehe no problem. Will take a look at your other thread.

I think you left out most of...

jdasilva (5/15/2014)

---

Sean Lange (5/15/2014)

---

jdasilva (5/15/2014)

---

ok. well lets go back to the original stuff Sean posted. He used 2 delcarations that don't work (user-defined type not defined):

dim parm as...

This is nothing like DDL or Sample data. The idea here is that you post create table statements and insert statements so we can recreate the table(s) in our...

ramyours2003 (5/15/2014)

---

is the information provided by executing the query is right ? because i found connections are existing on the datbase which i need to prepare the report .as per...

jdasilva (5/15/2014)

---

ok. well lets go back to the original stuff Sean posted. He used 2 delcarations that don't work (user-defined type not defined):

dim parm as ADODB.Parameter

dim cmd as...

Are you familiar with BOL (Books Online)? It is...

ramyours2003 (5/15/2014)

---

i need to prepare a report that shows last user access on a particular database and the account that is a service account or user account , can...

You can use OUTPUT with dynamic sql too. No need for a temp table. I took Calvo's example and changed it so it uses OUTPUT parameters. The other change I...

JJR333 (5/15/2014)

---

I want to add a column to this query which displays the number of times each MwID is present in the result set.

This number is needed to divide into...

You only get one row because there is only one row with the max...

So you only want to get the ProcDate and DayKey for the row with the highest DayKey?

How about this?

SELECT top 1 ProcDate, DayKey

FROM dbo.MyTable a

WHERE ExtractType = 'D'

order...

dcwilson2009 (5/15/2014)

---

How would I convert this query to use a JOIN in the subquery:

SELECT ProcDate , MAX(b.DayKey) DayKey

FROM dbo.MyTable a ,

...

A cte is just an inline view. You should read up on them because they are very powerful and you...