Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,991 through 25,005 (of 59,099 total)

RE: How yo make these two queires to one please

kapil_kk (12/29/2013)
As Christian suggested, it can easily be done using CTE
If it's that easy and since we're here, please post a solution. 😉
--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)

December 29, 2013 at 2:52 pm

#1676280
RE: need help on design of database for student registration system

hlsc1983 (12/28/2013)
thank u all for your help...i have tried to create a relationship but have run into an error. please help. thank you.
k i have created two tables as shown...
--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)

December 29, 2013 at 2:46 pm

#1676279
RE: need help on design of database for student registration system

hlsc1983 (12/29/2013)
I found out the solution... I already had records in the student table n these records were violating the constraint...the query worked fine after I deleted the records.
is...
--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)

December 29, 2013 at 2:35 pm

#1676278
RE: need help on design of database for student registration system

hlsc1983 (12/16/2013)
this is my first SQL server project.. student registration system using SQL server 2008 and VB.net.
can you please help me in designing the database?
the system 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)

December 29, 2013 at 2:28 pm

#1676277
RE: need help on design of database for student registration system

Grant Fritchey (12/18/2013)
I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about the key structure while 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)

December 29, 2013 at 2:16 pm

#1676276
RE: need help on design of database for student registration system

Sigerson (12/18/2013)
Grant,
Yes it was homework, but I thank you for taking your time to craft such a gracious (and clear!) answer. Some posters here scorn helping students and I've...
--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)

December 29, 2013 at 2:12 pm

#1676275
RE: Fusion-IO or Nimble?

chrishoward515 (12/28/2013)
Just replying to the post that said the Fusion-io solution was all flash --- Fusion-io offers both hybrid and all flash arrays. ioControl is the Fusion-io hybrid array...
--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)

December 29, 2013 at 11:42 am

#1676263
RE: Concept of Data and Index pages

As well as the marvelous articles that Gail posted, Books Online has some great information in it (if you don't know what Books Online is, post back... you cannot live...
--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)

December 29, 2013 at 11:39 am

#1676262
RE: Exclude Columns When Using Bulk Insert

david.holley (12/28/2013)
...however I kept getting errors which I tracked down to being a case of not using it with a .txt file.
Patently not the case. BCP format files work...
--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)

December 29, 2013 at 10:15 am

#1676260
RE: Script to Delete Reports Older than a Certain Number of Days

SQLRNNR (12/26/2013)
Jeff Moden (11/15/2013)
Simbo_mk (11/14/2013)
Any suggestions???
Yes... use the DOS command I posted instead. 😛
Or do as was suggested earlier and just use the drag and drop feature in the Maintenance...
--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)

December 26, 2013 at 3:02 pm

#1676025
RE: Document The Code Please !

SQLRNNR (12/26/2013)
Yeah that Forfiles syntax is throwing me for a complete loop 😉
Seriously, notes in the code is extremely helpful. Especially if we are going to start tossing PoSH...
--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)

December 26, 2013 at 1:37 pm

#1676005
RE: How to Pivot without an aggregate

asheppardwork (12/26/2013)
Thank you so much for your code. I have been looking for two days for someone to list a simple example of how to "pivot" rows and columns...
--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)

December 26, 2013 at 1:23 pm

#1676002
RE: Update Temp table where the column names are unknown

This will lead to some pretty miserable performance on top of it all... it makes for a 100% non-SARGable query. You could have a thousand index on the columns...
--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)

December 26, 2013 at 1:19 pm

#1676001
RE: Document The Code Please !

Yeah! Especially THIS guy! 😉
http://www.sqlservercentral.com/Forums/FindPost1512914.aspx
--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)

December 26, 2013 at 9:17 am

#1675963
RE: merge multiple table coloum data in new table

shashianireddy 30786 (12/26/2013)
in my database ....i have four tables ....every table have mobile coloum ..........
i want o/p like FOUR table mobile field MERGE in newtable ......
ex-
table 'a'
name ...
--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)

December 26, 2013 at 6:02 am

#1675938

Viewing 15 posts - 24,991 through 25,005 (of 59,099 total)