Database

Wendelius27-Nov-08 7:31

Wendelius

27-Nov-08 7:31

Brady Kelly wrote:
The following query gives me a concatenation of the name attributes of all sections in an XML column, but I need the values to be delimited.

One way to do this is to use concat function:

...ExportDef.query('for $nm in /ExportSpecification/Sections/Section/@name return concat(string($nm),'', '')')...

The need to optimize rises from a bad design.

My articles[^]

Brady Kelly27-Nov-08 7:39

Brady Kelly

27-Nov-08 7:39

Thanks, I actually just figured that out. It seems to use a single space as a default delimiter, which could present problems in some scenarios. Can you suggest any way of preventing this?

Wendelius27-Nov-08 7:48

Wendelius

27-Nov-08 7:48

If you want a simple varchar value out then you could use something like:

...replace(
      convert(
         varchar(500),
         ExportDef.query('for $nm in /ExportSpecification/Sections/Section/@name return concat(string($nm),'', '')'
      ),     
      ',  ', 
      ',')...

The need to optimize rises from a bad design.

My articles[^]

Issue with Reporting services

Brady Kelly27-Nov-08 7:56

Brady Kelly

27-Nov-08 7:56

Ah, yes, thanks. Actually the spaces don't matter - the result list is for an IN clause anyway, which tolerates spaces.

All Sorted

import from excel

tkoletsis27-Nov-08 5:15

tkoletsis

27-Nov-08 5:15

I think it's a very common case to import data from an excel file to sql server 2005 thru a stored procedure. There are many solutions solutions such as OpenDataSource methods, cmd call DTS packages etc.
However i have not succeeded in find a receivable solution when the excel file is on the local machine. These methods work only if the file is at the same volume where the sql server is. But what happens if the excel file is at the local volume? I've read all the previous topic - export to excel - and have searched to a lot of other communities but the result was nothing. Has anyone came up against a similar situation?

Thanks in advance

www.netsemantics.gr

Re: import from excel

Wendelius27-Nov-08 5:56

Wendelius

27-Nov-08 5:56

If you want to import an excel file using tools or utilities provided by SQL Server, then the SQL Server must have access to the file. It doesn't matter where the file is. It can be on a network share etc as long as SQL Server can read it.

If your excel file is located on your local machine and you're not able to provide access to it from the db server, you can use utilities like bcp on your client machine to get the data to the SQL Server.

The need to optimize rises from a bad design.

My articles[^]

Sandeep Akhare27-Nov-08 4:41

Sandeep Akhare

27-Nov-08 4:41

Hi All,
Its been 2 weeks i am facing this issue.
I have sql server 2005 with Reporting services on Windows server 2003 64 bit machine.
I have configured the dashboard and its working . Sometime it is showing the generated report
But 9 out of 10 times i am getting error.When i checked the log files
at C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles below error is displaying

11/27/08 10:31:22, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3096
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x20154C3C
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
11/27/08 10:31:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
11/27/08 10:31:29, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
11/27/08 10:31:29, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0153.mdmp
11/27/08 10:31:29, ACTION, w3wp.exe, Watson Invoke: No

Again in event view for Application application below error is coming

Event Type: Error
Event Source: Windows Search Service
Event Category: Gatherer
Event ID: 3083
Date: 11/27/2008
Time: 10:32:13 AM
User: N/A
Computer: CIGSCMMETRIC01
Description:
The protocol handler Search.Mapi2Handler.1 cannot be loaded. Error description: Class not registered.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Please can anyone help me

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Check My Blog

Re: Issue with Reporting services [modified]

Jerry Hammond27-Nov-08 15:49

Jerry Hammond

27-Nov-08 15:49

Did you try http://go.microsoft.com/fwlink/events.asp[^]

The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright

modified on Thursday, November 27, 2008 11:47 PM

Re: Issue with Reporting services

Sandeep Akhare27-Nov-08 15:56

Sandeep Akhare

27-Nov-08 15:56

Hi Jerry,
Url is not working

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Check My Blog

Re: Issue with Reporting services

Jerry Hammond27-Nov-08 17:50

Jerry Hammond

27-Nov-08 17:50

It should work now.

The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright

Re: Issue with Reporting services

Sandeep Akhare28-Nov-08 8:49

Sandeep Akhare

28-Nov-08 8:49

Thanks Jerry ,
Searching for fix now ... Smile | :)

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Check My Blog

data versioning in CMS

m-khansari26-Nov-08 21:41

26-Nov-08 21:41

hi
i want to implement data versioning in a CMS.
before it I want to realize it's methods and approches.

if u present PDFs or articles it is the best.

who can help me? Rose | [Rose]

bye

Mohammad Khansari

Ashfield26-Nov-08 21:46

26-Nov-08 21:46

Is there no search button at the top of your screen? Does google not work where you live?

Bob
Ashfield Consultants Ltd

m-khansari30-Nov-08 23:39

30-Nov-08 23:39

hi
ha ha ha ha Poke tongue | ;-P

what did u mean?

google is working here!!!!!!!!

bye.

Mohammad Khansari

Ashfield1-Dec-08 1:42

1-Dec-08 1:42

m-khansari wrote:
what did u mean?

I mean its as easy for you to use the seach function on CP or google as it is for anyone else to do the search and send you the links. Its generally known as doing your own research, unfortunately it does not seem to be widely practiced judging by the majority of posts on these forums.

Bob
Ashfield Consultants Ltd

m-khansari7-Dec-08 20:21

7-Dec-08 20:21

hi prodigy

i have searched by google these words

versioning software
versioning system
versioning .net
versioning control
versioning database
versioning tools
versioning C#
versioning ADO.net
content versioning
versioning implementation
versioning methods
row versioning
record versioning
data versioning

but i reached only 2 articles in this field
one article in code project and another in some thing else

can u tell me what expression i must search to reach more articles?

thanks

Mohammad Khansari

Ashfield8-Dec-08 1:34

8-Dec-08 1:34

You said

m-khansari wrote:
i want to implement data versioning in a CMS.
before it I want to realize it's methods and approches

So first decide on what you actually mean. Do you want to know about data versioning in general, or in relation to a specific CMS product. If the latter, then check with the vendor. If it the former, what do you actually want to know, what it means or how to do it.

As I say, nobody can really help as you are not clear in your requirements.

Bob
Ashfield Consultants Ltd

m-khansari9-Dec-08 18:41

9-Dec-08 18:41

hi
thanks very much.

I want to know how to improve and enhance data versioning performance
and I want to know it's approachs in general.

God bless Wink | ;)

Mohammad Khansari

Ashfield9-Dec-08 20:53

Parameter in stored procedure

9-Dec-08 20:53

I think you are trying to run before you can walk.

m-khansari wrote:
I want to know how to improve and enhance data versioning performance

OK, so you need a good understanding of deltas etc associated with versioning

m-khansari wrote:
I want to know it's approachs in general

Seems you don't much understanding about how it really works.

I suggest you google for methods of version control and learn from there.

Bob
Ashfield Consultants Ltd

Saiyed Alam26-Nov-08 18:44

Saiyed Alam

26-Nov-08 18:44

Ca any I tell me the maximum number of input or output parameter a sql stored procedure can have?

Ashfield26-Nov-08 22:01

26-Nov-08 22:01

In Books Online, the sql server help, search for "maximum capacity" - it will tell you the answer and loads more useful/interesting (boring?) bits of information.

Bob
Ashfield Consultants Ltd

Saiyed Alam27-Nov-08 20:42

Saiyed Alam

27-Nov-08 20:42

Thanks Bob. This is really great.

Jerry Hammond27-Nov-08 15:51

Jerry Hammond

27-Nov-08 15:51

2,100

The world is a stage and most of us are desperately unrehearsed.
—Sean O’Casey, Playwright