Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,371 through 23,385 (of 59,102 total)

RE: How to imbed an image into an email sent by dbmail

Excellent, Sachin! Thanks for the great info!
How in the world a newbie would make the connection in his/her mind that you need to find and embed a MIME attribute...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 22, 2014 at 2:48 pm

#1723868
RE: How to imbed an image into an email sent by dbmail

Sachin Nandanwar (6/22/2014)
Having good background with C# maybe I will try to clear that.
Cid is called ContentIdentifier.So when an image needs to be referenced in a mail basically it can...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 22, 2014 at 11:08 am

#1723857
RE: How to imbed an image into an email sent by dbmail

Lowell (6/23/2010)
the secret is to use cid:attachedimage.gif for the source file.
here's a setup and working example:
I'm attaching the results of a query, and i copied the SQl server logo to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 22, 2014 at 9:24 am

#1723848
RE: Optimize SQL

J Livingston SQL (6/21/2014)
Jeff Moden (6/21/2014)
a.guillaume (6/19/2014)
ARNAUD is working the 06/19/2014
He can't work on
00-8:00
12:00 p.m. to 1:00 p.m.
...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2014 at 3:54 pm

#1723812
RE: no. of columns in excel may vary

ykonline (6/20/2014)
Hi,
I want to insert data periodically from an excel file into a table using a SSIS. But each time the no. of columns in excel may vary.
Suppose, the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2014 at 3:50 pm

#1723811
RE: Help need for Select Query Remove Empty Cells

Explain why the two with blanks in the expected output are allowed but the first 3 of 5 with the blanks in the original results are not.
Also (and there's no...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2014 at 3:42 pm

#1723810
RE: Optimize SQL

a.guillaume (6/19/2014)
ARNAUD is working the 06/19/2014
He can't work on
00-8:00
12:00 p.m. to 1:00 p.m.
10:00 p.m. to 0:00
...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2014 at 2:35 pm

#1723808
RE: How best update lots of actively used R/O data?

Lynn Pettis (6/21/2014)
I've used synonyms before as well, should have thought of it myself. But, it was a good exercise in learning to swap partitions since I hadn't done...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2014 at 2:02 pm

#1723806
RE: How best update lots of actively used R/O data?

dave 67553 (6/21/2014)
I had not heard about DB synonyms before which seem a great feature for this problem. I guess you keep the state as to which table is current...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2014 at 1:56 pm

#1723805
RE: What color is SQL Server?

"It Depends". I think of it (and virtually any programmable product) as more like a mirror and it's color is dependent on the imagination of the person standing in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2014 at 12:24 pm

#1723799
RE: Counting the characters in a string before a space

Appreciate that but don't do it on my account. I'm thinking that the OP should have such a thing. If not, then we know the real problem.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 21, 2014 at 12:12 pm

#1723798
RE: How best update lots of actively used R/O data?

We do such a thing on a regular basis except we keep it even simpler.
Two tables almost identically named. For example, SomeTable1 and SomeTable2.
We also have a synonym called...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 20, 2014 at 11:02 pm

#1723744
RE: OpenRowSet query Error

You need to remove the parenthesis from (server\instance) in the following example...
select * from openrowset('SQLNCLI','Server=(server\Instance);Trusted_Connection=yes;','exec dbo.sp_who') AS a
Of course, you also need to sub the correct names for server\instance.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 20, 2014 at 10:25 pm

#1723743
RE: Help for Preparing date schedule.

I believe this will do it but you should test a broader range of dates to make sure it works. Look for "Rev 01" to see the changes I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 20, 2014 at 9:49 pm

#1723741
RE: Help for Preparing date schedule.

Ah... looking back at the requirements, I get it now. The last two examples are based on the end of the month and that's what you're trying to return...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 20, 2014 at 8:24 pm

#1723736

Viewing 15 posts - 23,371 through 23,385 (of 59,102 total)