Jeff Moden

Forum Replies Created

Viewing 15 posts - 27,841 through 27,855 (of 59,101 total)

RE: free online backup

Free online SPAM reported. 😉
--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)

December 16, 2012 at 7:07 pm

#1568992
RE: Complicated Query Requirement

Subbu S (12/16/2012)
i tried with CTE, but i didnt get the output
Can we see it, please?
--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)

December 16, 2012 at 7:00 pm

#1568991
RE: Formatting Phone Number

Just for information purposes... what I said about Area Codes occurring more frequently than you'd think might be scoffed at a bit by some. Please see the following URL...
--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)

December 16, 2012 at 6:09 pm

#1568986
RE: Value of column dependent on the values of others. How can I do it . Please help !

Minor mistake in Magoo's excellent code has been corrected in the following...
-- drop the temporary table if it already exists
if object_id('tempdb..#sample') is not null
drop table #sample;
-- create some...
--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)

December 16, 2012 at 5:20 pm

#1568975
RE: Create Table and Bulk Insert

Here we go... this is just one way to skin this particular cat. If you end up with some really large files or files with line lengths longer than...
--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)

December 16, 2012 at 5:02 pm

#1568973
RE: Create Table and Bulk Insert

Perfect and understood.
I've done things like this a lot so I'll give it a shot. In the mean time, could you post the CREATE TABLE statment for the target...
--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)

December 16, 2012 at 1:46 pm

#1568967
RE: Missing Indexes on Temp tables

TheSQLGuru (12/16/2012)
My statement about making "queries" faster is about the ENTIRE process. The act of populating a temp table with an index already on the temp table before data...
--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)

December 16, 2012 at 1:44 pm

#1568966
RE: Create Table and Bulk Insert

urso47 (12/15/2012)
Hi guys,
I have a .csv file wich has the following information (exactly like this):
List Name: User
Format Version:1.2.5.0
Date:12/11/2012 12:00:34
Equipment.:L6867000214
IP:172.21.12.62 ...
--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)

December 16, 2012 at 11:24 am

#1568962
RE: Missing Indexes on Temp tables

I guess I'd have to say, "It Depends". 😉
I don't know how others use Temp Tables but I follow a cardinal rule there. Only populate the table with what...
--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)

December 16, 2012 at 11:11 am

#1568961
RE: Need easy way to make 3 lines per child

pkaraffa (12/16/2012)
Thank you all. Appreciate all of your knowledge. Thanks again!
You're welcome.
As a bit of a side bar, you should store the data as 1 row per relationship anyway. ...
--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)

December 16, 2012 at 10:07 am

#1568958
RE: Formatting Phone Number

Just as an important sidebar...
You can see the bit of trouble that you're in because someone stored a formatted phone number and you want a different format. What you...
--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)

December 16, 2012 at 10:01 am

#1568956
RE: Get continuous date with count

CELKO (12/15/2012)
Code should be in Standard SQL as much as possible and not local dialect.
[font="Arial Black"]That's an absolute load of hooie! This is an SQL Server specific forum...
--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)

December 16, 2012 at 9:20 am

#1568949
RE: Need easy way to make 3 lines per child

You can skip joins altogether. While you could certinaly use the VALUES statement in 2008 and above, I decided to stick to a method that will work in all...
--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)

December 15, 2012 at 7:47 pm

#1568917
RE: exec master.dbo.xp_cmdshell

According to what I've found on Google, your error is a privs problem for a non-SA account. If it's been running fine for years and suddenly quit like you...
--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)

December 15, 2012 at 10:07 am

#1568890
RE: how to read xml variable using openxml

jos.moy (12/14/2012)
Hello
In a SQL to get the fields of XML to SQL query would be like this, not if you really want to take SQL.
select
campo.value('(/Encabezado/Heads_tree_XML)[1]','Data_type'')
from tabla
I hope to help you
Thanks.
--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)

December 15, 2012 at 10:00 am

#1568889

Viewing 15 posts - 27,841 through 27,855 (of 59,101 total)