Jeff Moden

Forum Replies Created

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

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
RE: Restoring a database and simultaneously increasing it's file size

If you buy the right disk defragmentation system, you can defragment SQL Server MDF, LDF, and NDF files while the system is up and running with little or no degredation...
--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 6:59 pm

#1641623
RE: need help transforming row values to a table

ron morgan (8/14/2013)
how do i transform the result set or table columns eg. using tsql
See the following article for two different methods. Instead of using SUM(), use MAX().
http://www.sqlservercentral.com/articles/T-SQL/63681/
After that...
--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 6:35 pm

#1641621
RE: Modifying a stored procedure to point from PROD to TEST

Gerard Silveira (8/13/2013)
Hey Sean ,
The issue is I have a 4 part naming here, so Im looking for a method to move from PROD - TEST and TEST -...
--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 13, 2013 at 3:54 pm

#1641175

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