Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,241 through 21,255 (of 59,098 total)

RE: Update with Recursive CTE?

isaac.asher (3/19/2015)
My idea was most definitely painful...... and I figured someone out there had a simple solution. Mr or Mrs 500 had exactly the solution I needed! Thank...
--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)

March 19, 2015 at 6:06 pm

#1785254
RE: Call Stored Procedure from a Function

Sean Lange (3/19/2015)
Jeff Moden (3/19/2015)
Sean Lange (3/19/2015)
Nuhamovici (3/19/2015)
Can you share the code that does this? Calling sp_who from within a function?
Why? What could you possibly gain from calling 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)

March 19, 2015 at 5:09 pm

#1785248
RE: Missing green arrow on the sql server icon in object explore

I'm a richer man thanks to your 2 cents. 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)

March 19, 2015 at 5:04 pm

#1785246
RE: Call Stored Procedure from a Function

Sean Lange (3/19/2015)
Nuhamovici (3/19/2015)
Can you share the code that does this? Calling sp_who from within a function?
Why? What could you possibly gain from calling a stored proc from within 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)

March 19, 2015 at 9:36 am

#1785110
RE: Performance Tuning Questions

rwitt 95744 (3/18/2015)
Greetings,
I have been using actual execution plans & Database Engine Tuning Advisor to analyze performance. My questions pertain to interpreting exactly what Database Engine Tuning Advisor is telling...
--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)

March 18, 2015 at 9:10 pm

#1784969
RE: Employeee Benefits Database

sasansamani (3/18/2015)
Yes this was homework.....
When tried to solve problem I determined the relationship between Employee and Benefits is many to many but I cant determine the bridge class. I mean...
--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)

March 18, 2015 at 8:37 pm

#1784966
RE: How to get FileName and TimeStamp of the file from a directory without using xp_cmdShell

SQLCurious (3/18/2015)
Thanks, Jeff. I tried using xp_DirTree but it only gets me the file names. I need to sift through the files based on the file types and their create/modified...
--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)

March 18, 2015 at 5:30 pm

#1784953
RE: SQL Help: Running row Total with Thresholds.

pietlinden (3/18/2015)
Okay, what version of SQL Server are you using, because this has zero to do with SSIS? This works in 2012, and I think in 2008.
Credits to Navy...
--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)

March 18, 2015 at 5:21 pm

#1784949
RE: Update with Recursive CTE?

isaac.asher (3/18/2015)
I have a list of account numbers stored in a table and am trying to update all account numbers to be 10 digits long. Some accounts will be...
--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)

March 18, 2015 at 5:18 pm

#1784947
RE: SQL Help: Running row Total with Thresholds.

subahan_syed (3/18/2015)
Hello Team -
I have a data table in below format and the need the desired output in 2nd table format
TABLE1
RANKBOOLEANREVENUE
1TRUE 100
2FALSE150
3FALSE200
4FALSE250
5FALSE300
6FALSE350
7FALSE400
8TRUE ...
--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)

March 18, 2015 at 5:15 pm

#1784945
RE: How to get FileName and TimeStamp of the file from a directory without using xp_cmdShell

SQLCurious (3/18/2015)
I want to write a stored procedure or a simple T-SQL snippet that takes a parameter "Directory Path" and gives me the name and datetimestamp associated with each of...
--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)

March 18, 2015 at 5:13 pm

#1784944
RE: Employeee Benefits Database

Gosh, this seems like homework. You should at least try to answer the questions and explain why . If you're wrong, then people will help.
--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)

March 17, 2015 at 11:53 pm

#1784653
RE: My recent post is not showing up

DaPainKiller (3/17/2015)
I have 'Added Topic' and it's name is shown under recent subscriptions in my subscriptions list but it never appears on the forum page. Please help
You might want to...
--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)

March 17, 2015 at 6:49 pm

#1784637
RE: Time difference with dates in same column

thomashohner (3/17/2015)
Wow that was fast!
And its faster than my attempt at creating a temp table to build a start and stop time column.
Amazing 242,139 rows in under 30 seconds
How...
--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)

March 17, 2015 at 5:59 pm

#1784636
RE: Add 15 minutes to a time in char format

CELKO (3/17/2015)
Gosh NO! You're missing an entire 10th of a second and if someone uses the table for a different resolution that you built the table for, they're in...
--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)

March 17, 2015 at 5:17 pm

#1784630

Viewing 15 posts - 21,241 through 21,255 (of 59,098 total)