Heh... you beat me to it, Barry. Despite some awesome technology in some classrooms and the awesome learned abilities by the students in those classrooms, most still can't count...

rajib (12/26/2008)

---

I love the word "depends". 😀

How about we assume that I'm looking for everything (3 things mentioned above as well as other items not listed there)? I am interested...

Heh... Actually, I haven't had a cigarette in over a week. Still want one real bad, but trying not to give in. Also trying not to bury folks...

Using the test data nicely provided by Pradeep, with an added row...

create table #patname

(

FullName varchar(100),

FirstName varchar(100),

MiddleName varchar(100),

LastName varchar(100)

)

insert into #patname(FullName)

select 'John,David Robert'

UNION ALL

select 'sustaita,corie m'

UNION ALL

select 'pena,geneva jesus'

UNION ALL

SELECT...

I have two resolutions....

1. Stop swearing so much at people who want to do stupid things to databases because... most of them are managers that have some say so...

rajib (12/23/2008)

---

I am curious to find out what your team does when it comes to database audit?

Here are a list of questions from me:

- Do you check schema only to...

Dugi (12/26/2008)

---

Dugi (12/26/2008)

---

Jeff you are amazing ...I'm going to delete my answers ah :hehe:

but can you explain to me this t.n*14 where did you find it ???

SELECT DATEADD(dd,t.n*14,'20090102')...

You bet, Doss... thanks for the feedback.

Praveen,

If you want to learn how to make cross tabs, then what Madhivanan suggested is a good idea. Also, I wrote a kind-of tutorial on how to make a...

vaibhav.a (12/26/2008)

---

I want to call a stored procedure inside a function... and then create a view using that function . How can i use stored procedure inside a function....

Thank You...

samsql (12/25/2008)

---

hi i hav an update query which show table scan m confused how to i put indexes so that it does not scan the table

Update temp1 Set Date =...

It's...

Never mind... the answer is YES... you CAN use OPENROWSET in the view. What that means is that you CAN use a stored procedure as the source for a...

Ummmm.... Anyone know for sure if OPENROWSET, OPENQUERY, or OPENDATASOURCE can be used in a view or not? That could be the ticket.

Ummmm... if the real tables are going to be in a database that doesn't have SIMPLE recovery, then probably not. If the temp tables are being used as replacements...