Viewing 15 posts - 9,991 through 10,005 (of 26,489 total)
CELKO (8/17/2012)
... What you have described in your narrative is a deck of punch cards that you want to shuffle.
...
And that could be exactly what he wants to...
August 17, 2012 at 3:19 pm
Using what you provided, I actually came up with the following.
create table SaleLocationXref (
SaleID int not null,
LocationID int not null,
constraint SaleLocationXref_PK primary key (SaleID,LocationID)
);
create table Sale (
...
August 17, 2012 at 2:49 pm
TravisDBA (8/17/2012)
Indianrock (8/17/2012)
At our company, security auditors are looking to see if anyone who has the term "developer" associated with their name has access to production data.
That is...
August 17, 2012 at 1:28 pm
If there are 3 SalesID's with 1 item in common but the overlap is for only 2 of the SalesID's, does that need to be reported or does the over...
August 17, 2012 at 12:31 pm
dba0419 (8/17/2012)
Thanks Lynn. However, the Windows Authentication test login I am using has full control of the remote share (read, write, create, delete).
And the other windows logins that need...
August 17, 2012 at 11:02 am
Since you are using dynamic sql, this could also work:
CREATE FUNCTION TEST_123(@PARAM nvarchar(50))
RETURNS TABLE AS
RETURN(
SELECT
ID
...
August 17, 2012 at 10:45 am
dba0419 (8/17/2012)
I am using Windows Authentication to send email using sp_send_dbmail.
Sending email works if I do not try to add a remote attachment. It also works if I try...
August 17, 2012 at 10:38 am
cphite (8/17/2012)
August 17, 2012 at 10:30 am
Still don't have what is needed to really help. Have you read that article yet?
August 17, 2012 at 10:21 am
ChrisM@Work (8/17/2012)
jfowler 10337 (8/17/2012)
August 17, 2012 at 10:10 am
I was taking another look at your code, and I'm sorry but it isn't a matter of just looking at it and recommending some changes. You have several derived...
August 17, 2012 at 10:08 am
jfowler 10337 (8/17/2012)
August 17, 2012 at 9:58 am
Sean Lange (8/17/2012)
Lynn Pettis (8/17/2012)
Stylez (8/17/2012)
August 17, 2012 at 9:56 am
jfowler 10337 (8/17/2012)
i just need things grouped by week starting with Monday and ending on Thursday.
That's nice. I charge $200.00 an hour with a minimum 8 hour charge to...
August 17, 2012 at 9:50 am
Here is a sample piece of code. Without the details of your tables and some sample data it is a bit difficult to modify it to work for you.
WITH...
August 17, 2012 at 9:43 am
Viewing 15 posts - 9,991 through 10,005 (of 26,489 total)