Jeff Moden

Forum Replies Created

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

RE: Converting VARCHAR value to TIME

It's a mistake to do so. You'll be losing the date element forever. Instead of converting the BIGINT to VARCHAR etc, etc, convert it to a DATETIME 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)

October 1, 2009 at 3:06 pm

#1060710
RE: CTE's, Do you use them on an everyday basis?

Bradley Jacques (10/1/2009)
Just wondering how many people actually use Common Table Expressions?
My answer is somewhere in between your two poll answers. It's like asking if someone writes derived table...
--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 3:01 pm

#1060708
RE: very large update

BrentMc (10/1/2009)
cheers, thanks.
That's what I had too but it's the last bit where it's checking for rows that are not null that seems to take too long in a 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)

October 1, 2009 at 3:00 pm

#1060704
RE: Help writing a SQL

Test 1 fails , 2 and 3 pass but 4 fails because the clustered index update that seth was seeing in his attempt of using a view.
Heh... I ran your...
--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 9:32 am

#1060522
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

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