Click here to Skip to main content
15,867,453 members
Home / Discussions / Database
   

Database

 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl21-Jul-08 6:54
dasha_pl21-Jul-08 6:54 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius21-Jul-08 8:29
mentorWendelius21-Jul-08 8:29 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl21-Jul-08 20:27
dasha_pl21-Jul-08 20:27 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl22-Jul-08 1:52
dasha_pl22-Jul-08 1:52 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius22-Jul-08 5:33
mentorWendelius22-Jul-08 5:33 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl22-Jul-08 21:44
dasha_pl22-Jul-08 21:44 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius23-Jul-08 5:48
mentorWendelius23-Jul-08 5:48 
QuestionExcel Query [modified] Pin
Sunil Wise17-Jul-08 21:01
professionalSunil Wise17-Jul-08 21:01 
Hi frns,

select CONVERT(varchar ,[regdate],103) Dates,[user],[client facility],sum([payroll score])LC from [sheet1$] 
group by [user],[client facility], CONVERT(varchar ,[regdate],103) order by [user]

i am programatically retreving data from excel sheet. for retriving data from excel the query i have written is the above but it is giving me error.
the error is :Syntax error (missing operator) in query expression 'CONVERT(varchar ,[regdate],103) Dates'.

How to use the convert function in excel query

regards

sunilwise

modified on Monday, December 1, 2008 4:53 AM

AnswerRe: Excel Query [modified] Pin
Sunil Wise17-Jul-08 21:32
professionalSunil Wise17-Jul-08 21:32 
QuestionHow to insert data from MS SQL server in MS EXCEL Sheet? Pin
guriqbal8717-Jul-08 4:22
guriqbal8717-Jul-08 4:22 
AnswerRe: How to insert data from MS SQL server in MS EXCEL Sheet? Pin
leoinfo17-Jul-08 5:17
leoinfo17-Jul-08 5:17 
GeneralRe: How to insert data from MS SQL server in MS EXCEL Sheet? Pin
guriqbal8720-Jul-08 20:50
guriqbal8720-Jul-08 20:50 
AnswerCross Post Pin
Paul Conrad17-Jul-08 16:51
professionalPaul Conrad17-Jul-08 16:51 
QuestionSending Email Pin
jonhbt17-Jul-08 3:38
jonhbt17-Jul-08 3:38 
AnswerRe: Sending Email Pin
Wendelius17-Jul-08 8:06
mentorWendelius17-Jul-08 8:06 
QuestionNested Cursor loop problem Pin
Member 387988117-Jul-08 3:25
Member 387988117-Jul-08 3:25 
AnswerRe: Nested Cursor loop problem Pin
Mark J. Miller17-Jul-08 9:27
Mark J. Miller17-Jul-08 9:27 
GeneralRe: Nested Cursor loop problem [modified] Pin
Member 387988117-Jul-08 19:59
Member 387988117-Jul-08 19:59 
GeneralRe: Nested Cursor loop problem Pin
Mark J. Miller18-Jul-08 5:20
Mark J. Miller18-Jul-08 5:20 
QuestionCompact database not working Pin
krishnan.s17-Jul-08 2:41
krishnan.s17-Jul-08 2:41 
AnswerRe: Compact database not working Pin
Paul Conrad17-Jul-08 16:51
professionalPaul Conrad17-Jul-08 16:51 
QuestionNot In operation? Pin
Member 387988117-Jul-08 1:03
Member 387988117-Jul-08 1:03 
AnswerRe: Not In operation? Pin
TheFM23417-Jul-08 3:00
TheFM23417-Jul-08 3:00 
GeneralRe: Not In operation? Pin
Member 387988117-Jul-08 3:09
Member 387988117-Jul-08 3:09 
Questionselect datas using union operation Pin
deepthy.p.m16-Jul-08 22:48
deepthy.p.m16-Jul-08 22:48 

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.