Example - if user 1 has a value in the Text column of 'Att20451', and user 2's is 'Att40451', if we pass in @attendance = '30452', then the Sproc should...

norbertackerman (10/6/2010)

---

In my database I have a contact_phone table. The type of phone it is, is indicated in the contact_phone_type_KEY.

1 = Business

2 = Fax

4 = Home

5 = Cell

This table...

AndrewSQLDBA (10/11/2010)

---

Yes, because the secondary box is a DR box that is on a separate network that has only one way communications. I can only see the secondary box from...

It looks like the only difference between the first three sections is in the where clause - specifically in the # of days being selected. Is this correct?

The dateadd(hh,0,) part...

george sibbald (10/11/2010)

---

WayneS (10/10/2010)

---

Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀

Any suggestions on good, inexpensive, close places...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Jeff Moden (10/10/2010)

---

WayneS (10/10/2010)

---

Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀

Any suggestions on good, inexpensive, close places...

Well, SSIS does use the Jet driver, via OpenRowSet, to work with Excel files. So, this link will probably help you out. You would just need to add it to...

Here is the latest version of the Delimited Split Function.

You would use it like:

declare @test varchar(20);

set @test = '2,7,12';

SELECT ID = convert(int, Item)

FROM dbo.DelimitedSplit8K(@test, ',') ds;

Jeff Moden (10/10/2010)

---

Heh... the lion sleeps. That wasn't...

Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀

Any suggestions on good, inexpensive, close places to stay? Guys...

Well, you quoted my article. And that is how I fixed exactly those same issues... except I had thousands instead of hundreds.

There's only two ways to fix the problem. Follow...

Thanks for your responses guys. It's right in line with what I was thinking, but it's always good to get the double-check.

Now, I just gotta get used to using the...

Jeff Moden (10/10/2010)

---

WayneS (10/10/2010)

---

Using the DelimitedSplit8K function, you would end up with:

DECLARE @String1 varchar(8000),

@String2 varchar(8000);

SET @String1 = 'a,b,c,d';

SET @String2 = 'apple,boy,college,dog';

SELECT a.Item,...

Mordred (10/9/2010)

---

Hi all,

I am a student who is relatively new to SQL. While I am not looking for someone to do my work for me,...