Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,206 through 26,220 (of 59,102 total)

RE: Is this a "gaps and islands" problem? Finding gaps in overlapping times.

GPO (8/15/2013)
Awesome to have the heavy hitters on the case! Jeff, where you say:
You're not actually supposed to use any data from that. You're only supposed to use the presence...
--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)

August 15, 2013 at 6:06 am

#1641750
RE: Put 4 tables in 1 table.. HOW to do that?

HanShi (8/15/2013)
Does this statement work?
CREATE VIEW v_WhatsUp_Assyst
AS
SELECT nDeviceID
, nDefaultNetworkInterfaceID
, item_id
, item_keya COLLATE Latin1_General_CI_AS
, nDeviceGroupID
, sGroupName COLLATE Latin1_General_CI_AS
, nDefaultNetworkInterfaceID
, sNetworkName COLLATE Latin1_General_CI_AS
FROM WhatsUp_Assyst_replicatie.dbo.device
, WhatsUp_Assyst_replicatie.dbo.item
, WhatsUp_Assyst_replicatie.dbo.DeviceGroup
, WhatsUp_Assyst_replicatie.dbo.NetworkInterface
UNION ALL
SELECT nDeviceID
, nDefaultNetworkInterfaceID
, item_id
, item_keya...
--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)

August 15, 2013 at 5:40 am

#1641740
RE: Put 4 tables in 1 table.. HOW to do that?

Just a heads up, Karmin... posting code as a graphic does absolutely nothing for anyone. We can't copy it and modify it for you.
It would also REALLY be a...
--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)

August 15, 2013 at 5:36 am

#1641738
RE: Identify string or integer

Minnu (8/14/2013)
Hi Team,
am passing a parameter to a stored procedure, i want to know whether the parameter is string or integer
i want a print statement in stored procedure to print...
--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)

August 14, 2013 at 10:26 pm

#1641647
RE: Best way to import fixed length ASCII text files, that are not delimited ?

isuckatsql (8/14/2013)
I found the problem !
The data structure for the text file provided by the client was wrong ................... duh !!!!!!!!!!!
It was actually a COBOL data structure, 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)

August 14, 2013 at 10:24 pm

#1641646
RE: Put 4 tables in 1 table.. HOW to do that?

Eric M Russell (8/14/2013)
Rather than inserting into one table, another option would be to create a virtual table using a partitioned view.
create view v_WhatsUp_Assyst
as
SELECT nDeviceID, nDefaultNetworkInterfaceID FROM WhatsUp_Assyst_replicatie.dbo.device
union all
SELECT nDeviceID,...
--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)

August 14, 2013 at 10:20 pm

#1641645
RE: Put 4 tables in 1 table.. HOW to do that?

karim.boulahfa (8/13/2013)
I have just make a new database and im trying to put 4 tables in 1 table. I heard you most use the INTO syntax...
So i was doing firts...
--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)

August 14, 2013 at 10:06 pm

#1641644
RE: Maintain the sort order of data file while using bcp

Gil_Adi (8/14/2013)
Sql server 2008 r2 service pack 2
When trying to import a single varchar column file using bcp utility (no format file)
to a temporary table (## ) the rows...
--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)

August 14, 2013 at 9:57 pm

#1641640
RE: Trying to iteratively use PATINDEX commands to comb through a large amount of text

ScottPletcher (8/13/2013)
That code's written for SQL 2000; I suggest completely ignoring it.
I wouldn't ignore it because it was written for SQL Server 2000... I'd ignore it because it solves 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)

August 14, 2013 at 9:38 pm

#1641638
RE: Log Space % increases while size stays the same

agordon 35530 (8/14/2013)
Because is you look at the Excel spreadsheet from above, you'll see there are several databases (12)on this server.
I put the 15,000 MB log restriction in place...
--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)

August 14, 2013 at 9:24 pm

#1641634
RE: convert vb code to t-sql (pdf automation)

Sean Lange (8/14/2013)
Maybe instead of taking code you found in a 6 year old thread here on ssc and asking us to convert it to t-sql you can tell us...
--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)

August 14, 2013 at 9:09 pm

#1641633
RE: convert vb code to t-sql (pdf automation)

Sean Lange (8/14/2013)
Why do you want to do this in t-sql? It is the wrong tool for the job. A CLR proc, SSIS or even an application would be a...
--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)

August 14, 2013 at 9:07 pm

#1641632
RE: convert vb code to t-sql (pdf automation)

skb 44459 (8/14/2013)
This is what attempted but its not working
What's not working about it? Are you getting any error messages?
Also, what do you get when you run the following?
EXEC...
--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)

August 14, 2013 at 9:00 pm

#1641631
RE: Is this a "gaps and islands" problem? Finding gaps in overlapping times.

GPO (8/14/2013)
OK. So I'm trying to understand table value constructors and cross apply. If I do this (on a SQL 2008 machine):
SELECT *
...
--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)

August 14, 2013 at 7:51 pm

#1641627
RE: Urgent help with Date format needed please

dhananjay.nagarkar (8/14/2013)
Thanks so much it worked.
Just don't ever store that in a permanent table. You will learn to hate yourself if you do. 😉
--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)

August 14, 2013 at 7:10 pm

#1641624

Viewing 15 posts - 26,206 through 26,220 (of 59,102 total)