Click here to Skip to main content
14,928,442 members
Home / Discussions / Database
   

Database

 
GeneralRe: Logging Pin
Ashfield29-Aug-09 3:57
MemberAshfield29-Aug-09 3:57 
GeneralRe: Logging Pin
εїзεїзεїз30-Aug-09 20:37
Memberεїзεїзεїз30-Aug-09 20:37 
GeneralRe: Logging Pin
Ashfield31-Aug-09 2:42
MemberAshfield31-Aug-09 2:42 
GeneralRe: Logging Pin
εїзεїзεїз5-Sep-09 22:18
Memberεїзεїзεїз5-Sep-09 22:18 
GeneralRe: Logging Pin
Ashfield6-Sep-09 21:19
MemberAshfield6-Sep-09 21:19 
AnswerRe: Logging Pin
εїзεїзεїз30-Aug-09 20:36
Memberεїзεїзεїз30-Aug-09 20:36 
QuestionHelp writing query Pin
michaelgr128-Aug-09 2:04
Membermichaelgr128-Aug-09 2:04 
AnswerRe: Help writing query Pin
Mycroft Holmes29-Aug-09 15:22
professionalMycroft Holmes29-Aug-09 15:22 
Thats one, no two ugly queries. You have a couple of options, you can move this into a cursor and insert the operator information into a table variable. I hate cursors and would not recommend this.

I would move the operator information out of the where clause into the select areas and join the 2 result sets by operator. This will allow you to use group by operator to get the results without using a cursor.

Research GROUP BY and INNER JOIN

You are probably going to have to muck with the calc as well.

Never underestimate the power of human stupidity
RAH

QuestionSQL:Problem in dynamic sql query [modified] Pin
xodeblack27-Aug-09 22:37
Memberxodeblack27-Aug-09 22:37 
AnswerRe: SQL:Problem in dynamic sql query Pin
Mycroft Holmes28-Aug-09 0:45
professionalMycroft Holmes28-Aug-09 0:45 
QuestionPlease suggest Pin
ME_Learner27-Aug-09 20:25
MemberME_Learner27-Aug-09 20:25 
AnswerRe: Please suggest Pin
Mycroft Holmes28-Aug-09 0:50
professionalMycroft Holmes28-Aug-09 0:50 
AnswerConsider Data Partioning Pin
David Mujica28-Aug-09 2:48
MemberDavid Mujica28-Aug-09 2:48 
Question## in sql server..? Pin
DIPAK@EMSYS27-Aug-09 19:57
MemberDIPAK@EMSYS27-Aug-09 19:57 
AnswerRe: ## in sql server..? Pin
Ashfield27-Aug-09 20:56
MemberAshfield27-Aug-09 20:56 
AnswerRe: ## in sql server..? Pin
Coding C#28-Aug-09 1:58
MemberCoding C#28-Aug-09 1:58 
Questiondesign questions - tables to support users Pin
Kimmmmy27-Aug-09 9:58
MemberKimmmmy27-Aug-09 9:58 
AnswerRe: design questions - tables to support users Pin
Luc Pattyn27-Aug-09 10:57
sitebuilderLuc Pattyn27-Aug-09 10:57 
GeneralRe: design questions - tables to support users Pin
Kimmmmy27-Aug-09 12:04
MemberKimmmmy27-Aug-09 12:04 
GeneralRe: design questions - tables to support users Pin
Luc Pattyn27-Aug-09 12:29
sitebuilderLuc Pattyn27-Aug-09 12:29 
GeneralRe: design questions - tables to support users Pin
Kimmmmy27-Aug-09 12:38
MemberKimmmmy27-Aug-09 12:38 
GeneralRe: design questions - tables to support users Pin
Mycroft Holmes27-Aug-09 14:34
professionalMycroft Holmes27-Aug-09 14:34 
GeneralRe: design questions - tables to support users Pin
Luc Pattyn27-Aug-09 15:25
sitebuilderLuc Pattyn27-Aug-09 15:25 
GeneralRe: design questions - tables to support users Pin
Mycroft Holmes27-Aug-09 16:04
professionalMycroft Holmes27-Aug-09 16:04 
Questionproblem:storing rtf formatted data into sql Pin
askhar51627-Aug-09 2:30
Memberaskhar51627-Aug-09 2:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.