Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,746 through 41,760 (of 59,098 total)

RE: Date format conversion question

I just had a thought about this, Sally... can you add a calculated column to the table without it breaking the 3rd part app?
Another possible "trick" would be to make...
--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)

October 1, 2009 at 7:55 am

#1060448
RE: Running DOS Command Prompt(cmd) command thought SSMS

naveenreddy.84 (10/1/2009)
I am running this on my local system and the file do exists in the path specified.Also, i can run this command through command prompt.
Like I said... the SQL...
--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)

October 1, 2009 at 12:25 am

#1060288
RE: Date format conversion question

I kind of figured it was something like that. I've run into that type of problem with 3rd party vendors more than once.
Anyway... glad it worked out and 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)

October 1, 2009 at 12:23 am

#1060287
RE: Working with Locks--Please Help Big Time

It's a big complicated subject with many options. Anything I would write here wouldn't be any better than what's in Books Online. I recommend looking up "row versioning...
--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)

September 30, 2009 at 11:24 pm

#1060280
RE: In Praise of Barebones Applications

I'm all for POP (Proof of Principle) code... the problem is, that people don't make such code scalable to begin with. People want the code real bad and that's...
--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)

September 30, 2009 at 11:07 pm

#1060275
RE: Running DOS Command Prompt(cmd) command thought SSMS

naveenreddy.84 (9/30/2009)
I tried giving the complete path
exec master..xp_cmdshell 'call E:\PROGRA~1\CA\SERVIC~\bin\bop_cmd.exe'
and i got following error: "The system cannot find the specified path"; but the file do exists
I need to understand...
--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)

September 30, 2009 at 10:43 pm

#1060273
RE: Getting error in create Trigger

It should work just fine as a script with the GO provided that GO starts in column 1. You cannot, however, do something of this nature in a stored...
--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)

September 30, 2009 at 10:41 pm

#1060272
RE: Do nothing in a sql statement--help

Mark-459099 (9/25/2009)
How do you write a "do nothing" in sql. I have a statement where if two variables are 0, I don't want anything to execute
for example
if a=0 and...
--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)

September 30, 2009 at 10:37 pm

#1060271
RE: Getting a row count from a text file using T-SQL.

Mark Marinovic (9/30/2009)
There may be a more elegant way of doing this, but you could create a temporary staging table and do the following:
SET NOCOUNT OFF
INSERT mydb.dbo.foo
FROM 'C:\foo.txt'
WITH (
FIELDTERMINATOR =...
--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)

September 30, 2009 at 10:28 pm

#1060270
RE: Adding index to every column

krypto69 (9/30/2009)
This is for ad-hoc reporting and is one big 'flat table'.
So, I never know what fields they could pick, they could pick any or all of the 400 columns.
Long...
--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)

September 30, 2009 at 10:25 pm

#1060269
RE: Date format conversion question

sfletcher-933270 (9/30/2009)
I am trying to run a simple convert statement for use in a stored procedure. I just want to display some date data (data type = varchar) in 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)

September 30, 2009 at 10:07 pm

#1060265
RE: Qry Performance

Sure... turn those ranges of EmpCodes into a single derived table with a single column of all the EmpCodes and use WHERE EXISTS or an INNER JOIN. It will...
--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)

September 30, 2009 at 10:02 pm

#1060263
RE: New Code formatting engine rolled out

Ben Adderson (9/28/2009)
We've now updated the syntax highlighting here on the forums. We've also tweaked the IFCodes to try and clarify which should be used for what. The revised list...
--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)

September 30, 2009 at 8:39 pm

#1060258
RE: New Code formatting engine rolled out

Just testing....
/**********************************************************************************************************************
[font="Arial Black"]Purpose:[/font]
Returns a single result set similar to sp_Space used for all user tables at once.
[highlight="RED"]Notes:[/highlight]
[highlight]1. May be used as a view, stored procedure, or...
--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)

September 30, 2009 at 7:46 pm

#1060252
RE: Need to import data from a CSV file into SQL2005 the easiest way.

Berl -384058 (9/30/2009)
Ironically, I have continued working on the issue and made a couple of tweeks and got it to work. But to answer you question my original code...
--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)

September 30, 2009 at 7:34 pm

#1060251

Viewing 15 posts - 41,746 through 41,760 (of 59,098 total)