MS SQL Server :: CONCAT Function + SQL Sever 2005

SQL Sever 2005 Remote Uploads
Hi,I created a small application to upload small video files on my
local machine and tested it to work perfectly on my local sql server
database. I then change the connection string to connect to the remote
database.When I do this and try to upload, the application hangs and
the video file is not uploaded. The file is small file only about 10MB
or less.When I upload the same file locally,it works perfectly fine and
uploads quickly without hanging.Here's a link to sample of my web.config filehttp://www.bleusolutions.com/sampleconfig.txt Here's a link to the pagehttp://www.bleusolutions.com/foto/uploadvideo.aspxI believe that this may be a database issue. I am running my
application locally
(http://localhost:4796/BleuS/foto/uploadvideo.aspx)and all I do is
change the web.config connection string to point to my local database
or to the remote database. When I point to my local database the application works fine as you can see: http://www.bleusolutions.com/images/localupload.jpgWhen
I run the application locally and change the connection string to point
to the remote database this is when I have problems with the same video
file. The application hangs for a minute or two and then it finally
finishes the upload. When I go to the database to view the table the
table takes a minute or two to open and then I get this message:http://www.bleusolutions.com/images/remoteupload.jpgAnd this is what the table looks like after I click Okhttp://www.bleusolutions.com/images/remoteupload2.jpg Any help on why this is happening or how I can fix this issue will be greatly appreciated. Thanks

View Replies !

SQL Sever 2000 And 2005 On Same Machine
Hi, I am trying to create a connection string that will connect to a SQL Server 2005 Registration on a remote machine. I have a SQL Server 2000 registration (installed) on the same machine and so I think there may be a conflict. The SQL 2005 registration is denoted as HARDYSQL5 and the 2000 registration is merely HARDY (the machine name). I need to connect to a database on the HARDYSQL5 registration but I am not connecting. I have tried various connection strings but none have worked. I get a Login failure. I think this is red herring because I doubt its even finding the database.I can connect to the 2000 db with:"Server=HARDY;Database=Perimeter;UID=use;pwd=example;" But its fails with the following, for example:"Server=HARDYSQL5;Database=Perimeter;UID=use;pwd=example;" "Server=HARDYSQL5;Database=HARDYSQL5Perimeter;UID=use;pwd=example;" "Server=HARDY;Database=SQL5Perimeter;UID=use;pwd=example;" I'm gon go nuts. What am I doing wrong? Thanks.

View Replies !

Tuning Sql In SQL Sever 2005 Using The Dta Utility
Hi,I am using the dta utility successfully.I have problem to tune query without specifying the schema as prefix incase the tuning session is not with the login that own the schema, thedta utility fails.e.g.Create a new login: login1, pass1CREATE USER user1 FOR LOGIN login1 WITH DEFAULT_SCHEMA = user1_schemaWorkload file:select * from table1Table list file:[db_recommend].[user1_schema].[table1]1.If the tuning session of the dta is connected with login1, pass1 thedta succeed.2.If the tuning session of the dta is connected with other login thedta fails.If I will specify the owner in the workload file the dta in this casewill succeedIs there a way to update the dta with the correct user/schemadynamically instead of specifying the owner for each object in theworkload file?Is there a way to active setuser function in the workload file?Is there an option in the XML file to set the correct user?ThanksMeytal

View Replies !

Mail Configuration In SQL Sever 2005
Hi,

I have a requirement sql server 2005 in which i need to send a mail when ever there is an error in the procedure or job.
The mail should fire with the error attached to it.
could you please suggest the ways to handle this.
Please tell me the list of steps to configure and send the mail.

Thanks in advance.

View Replies !

How Do I Look Through The Log To See Updates To Tables In Sql Sever 2005?
hi. changes were made to a dababase and we need to read the log file to see how much exactly was changed and what. how do i read the log file in sql server 2005 with out buying 3rd party software?

View Replies !

Please Help How To Add New Instance Of SQL Server 2005 On The Same Sever-new Name
help
(i have one sql server installed in my server)
how can i add another databese server on the same server
like for example the server name is server-1
need to create
sever-1/sql_data1 ----------------- instance of SQL Server 2005
sever-1/sql_data2 -----------------new instance of SQL Server 2005
so i open my SQL Server Management Studio i see 2 servers !

and how many databese servers i can install in the same server 1,2,3,4......... what is the limit

is thre is examples with screenes picture of the install step by step for add

TNX

View Replies !

Sql Sever 2005 Sp1 Installation Problem
Hi there,
I have some problem on install sql server 2005 sp1 on my machine. The problem is I always fail the authentication checking no matter I try the windows authentication or sql server autentication.

The error messgae is
-------------------------------------------
Your account information could not be verified for one or more instances.
Ensure that you can connect to all the selected instances using the account information provided.
To proceed further deselect the instances to which connectivity cannot be established.
---------------------------------------

but I have 100% sure that my sa password is correct. why I am still getting this error message?
My OS is Windows server 2003 R2 64 bit, will that cause any problem?

Could you help me to solve this problem?
Thanks in advance.

View Replies !

SQL Sever 2005 Only Has Client Side?
Why I couldn't find any datebase engine setup?

SQL Server 2005 Developer

Windows xp

View Replies !

SQL Sever 2005 Express Backup
How do you backup tables and stored procedures in SQL sever 2005 express? Also, I'm getting ready to load VS 2008 with SQL sever 2008. How will I move SQL sever 2005 express tables and procedures to SQL sever 2008?

View Replies !

SQL Sever 2000 To SQL Server 2005
Hi all,

I have an aplication in VB6 that uses an ODBC to link to a SQL database.

Until today all my clientes had SQL Server2000 and my aplication worked fine.

Some of my cliente have now SQL 2005 and my application still woks fine except in one of them.

In this particular cliente it gives an error when the application tries to read/write a particular table and a particular column.

This column is data type BIT and my code is

...
Myrs("Servida")= true
...

Any idea why the error appens? And why only in a particular machine and not all of them with SQL2005?

What can I do? I changed the code for

myrs("servida")=abs(cint(true)) and solved the problem, but is not the way that I want to go. I do not want to change thousands of line of code where I read/write a column in the database data type BIT.

Is there a way to configure SQL Server 2005 the way that it controls data type BIT?

Regards

Luis

View Replies !

How Can I Speed Up If There Is A Slowdown In SQL Sever 2005?

How can I speed up if there is a slowdown in SQL Sever 2005?

View Replies !

Can't Send Operator Email In SQL Sever 2005
I have:Set up Database MailSet up and Operator (me)Set up a job to send a message to that operator.When I run the TSQLEXECUTE msdb.dbo.sp_notify_operator @name=N'Chris Auer',@body=N'wewqe'I get the errorMsg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94No global profile is configured. Specify a profile name in the@profile_name parameter.When I run the job it get the errorExecuting the query "EXECUTE msdb.dbo.sp_notify_operator @name=N'ChrisAuer',@body=N'wewqe'" failed with the following error: "No global profile is configured.Specify a profile name in the @profile_name parameter.". Possiblefailure reasons: Problems with the query, "ResultSet" property not setcorrectly, parameters not set correctly, or connection not establishedcorrectly.I have also modded the registryHKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQLServerMSSQL.1SQLServerAgentDatabaseMailProfile = The profile I have set up in Database MailUseDatabaseMail = 1Any ideas?Thanks,Chris Auer

View Replies !

Anyone Have SQL Sever 2005 Developer 64-bit Running On Vista 64
Hi,

I have been trying to install SQL 2005 Server Developer Edition 64-bit on Vista 64 all morning.
The setup refuses to install many components.

Has anyone gotten this to work?

jerry

View Replies !

SQL Sever 2005 Express Ed And The Installation Of SQLEXPR_Toolkit
Hello, I am experiencing difficulty with the installation of sqlexpr_toolkit for sql server 2005 express. I have installed sql server 2005 express with advanced services. That has installed correctly. However, when I try to install the sqlexpr_toolkit with the feature 'Business Intelligence Studio' , the toolkit does not install; the toolkit does not show up in the program list in the"Add & Remove Programs" window. When I try to 'Change' the sql server 2005 in the "Add & Remove Programs" list and try to upgrade the feature components with the Business Intelligence feature, I get a error that states"cannot find devenv.exe." Both versions of setup files for sqlexpr_avd and sqlexpr_toolkit are the same. I previously had an earlier version of sql server 2005 express loaded but it was not the beta version. And I uninstalled the sql server apps, except I did not uninstall .NetFramework 2.0.

I have found some of the Business Inteligence files installed in the path: C:ProgramFilesMicrosoftVisualStudio8common7IDEPrivateAssemblies

I was wondering if I need to uninstall everything and start over. I also had previously installed Visual Web Developer Express and Visual Basic Express 2005 which are working okay. Do I need to obtain updates for these applications in order to get Business Intelligence Studio to install?

Any advice would be greatly appreciated. I really would llike to use the Business Intelligence Studio application.

View Replies !

Stupid Question In SQL Sever 2005 Report

Hi There

I have a report built in SQL Server 2005 Reporting. When i run that report i see the output question is, if i want to copy
any column data like for example on 10th record i want to copy 2nd column's data. How do i do that. I want to use mouse to copy data to Notepad like the normal copy and paste data. When i try to do that i was not able to clicl on it. I can't seem to get this done. Any help is appreciated. Thank you for your time.

Regards
Dheeraj

View Replies !

Export Table From Sql Sever 2005 To Oracle

dear all experts plz kindly give me ur help! i have a table in sql server 2005 and exported it to oracle successfully. i hv no porblem with the following query:

select * from table1

however, when i try to select a specific field from this table, for example:

select cust_name from table1

i fail to do so and it give me an error message that '

OLE DB provider "XXXXXXX" for linked server "(null)" returned message "ORA-00904: "cust_name": invalid identifier".

and the probelm is not just this field, but for every single field that i try to select. can anyone plz help?

View Replies !

Cant Install Sql Sever 2005 Ssmsee.msi File
i was able to download sqlserver2005ssmsee.msi file from microsoft

but when i open it i get an error that the file is in an unkown format or damaged

i've down loaded it several times and save it to my desktop and also have ran it from the download and same message.

i am running windows xp pro

i have also removed all files neccesary, and succesfully downloaded

visual wed developer and it works fine.

i'm trying to use sql sever managment studio, to help me with ecommerce development with databases.

please, all help would be apprieciated.

if you need more info please write back, i need this resolved, Thanks

View Replies !

How To Import Excel Spreedsheet To SQL Sever 2005
is there any easiest way to do it? thanks!

View Replies !

Mssql 2005 Express Sever Authentication
I am new to mssql
I am not sure when I should use windows authentication and when to use sql server authentication
I set it to sql server installation when sql server was installed
I am using it right now on xp-pro platform on my home computer but I also have a website where I would like also to use it
right now I do not have problem accessing the server with windows authentication but I keep getting errors when I switch to sql server authentication
Your help is appreciated
Dory

View Replies !

Sql Sever 2005 - Full Text Search
Full text search is the search functionality that enables a fast and easy way of searching text based data in SQL Server. Although the concept of full text search is not new in SQL Server 2005, there are considerable enhancements in performance and manageability of SQL Server 2005. http://aspalliance.com/1512_Understanding_Full_Text_Search_in_SQL_Server_2005.all

Uday Denduluri
Software Engineer
Refer my articles at http://aspalliance.com/author.aspx?uId=62740

View Replies !

Send HTTP Request Using SQL Sever 2005
I have Lotus Notes Database which stores employee database. If I request following http URL on browser, which fetch data from Lotus Notes Database and response me following XML text. I need to pass some id as a parameter in HTTP request to retrieve particular data.

HTTP Request:
http://kernel.com/global/corp/ecd.nsf/xmlemployeesactivebyguid?readviewentries&StartKey=sesa249&count=1

HTTP Response:
<?xml version="1.0" encoding="UTF-8" ?>
<viewentries toplevelentries="53656">
<viewentry position="14310" unid="FC86BCB9224169F4C12570AD005A775C" noteid="D9FA2" siblings="53656">
<entrydata columnnumber="0" name="GUID">
<text>SESA24941</text>
</entrydata>
</viewentry>
</viewentries>

I need to send this http request programmatically. To do that,

1) Is thr any functionality in SQL Server 2005, which can send http request to any other server like LOTUS NOTES
2) If not,thn do you know how to do it programmatically using c# ?

When U have some time, let me know. Thanks in advance man.

Satyam

View Replies !

SQL Sever 2005 High User Connections With SqlCacheDependency?
Greetings,
I have an application running on SQL Server 2005 (64 bit edition). The website has no traffic, just some occasional testing by me.
I've noticed the user connections (performance counters > Sql Server General Statistics > User Connections) never drops below 40 after I run through my site a few times.
I *am* using SQLCacheDependencies pretty aggressively in certain areas using this function:1 public static DataTable GetDataTable(string strSprocName, SqlParameter[] Params, object[] Values, string cacheKey)
2 {
3 SqlConnection conn = new SqlConnection();
4 SqlCommand cmd = new SqlCommand();
5 string isCacheEnabled = ConfigurationSettings.AppSettings["DataTableCaching"].ToString().ToLower();
6 bool cacheEnabled = isCacheEnabled == "false" ? false : true;
7
8 try
9 {
10 //first check the cache...
11 DataTable dt = new DataTable();
12 if (!string.IsNullOrEmpty(cacheKey))
13 {
14 //if it IS in the cache..grab it and return..
15 if (HttpRuntime.Cache[cacheKey] != null && cacheEnabled)
16 {
17 dt = (DataTable)HttpRuntime.Cache[cacheKey];
18 #if DEBUG
19 Utils.LogHere("SPROC Found " + cacheKey);
20 #endif
21 return dt;
22 }
23
24 conn.ConnectionString = _Connection;
25 cmd.CommandType = CommandType.StoredProcedure;
26 cmd.CommandText = strSprocName;
27 cmd.Connection = conn;
28 conn.Open();
29
30 for (int i = 0; i < Params.Length; i++)
31 {
32 cmd.Parameters.Add(Params[i]).Value = Values[i];
33 }
34 SqlDataAdapter adapter = new SqlDataAdapter(cmd);
35 if (cacheEnabled)
36 {
37 SqlCacheDependency scd = new SqlCacheDependency(cmd);
38 adapter.Fill(dt);
39 adapter.Dispose();
40
41 //insert it into the chache
42 if (dt.Rows.Count > 0 && cacheEnabled)
43 {
44 HttpRuntime.Cache.Insert(cacheKey, dt, scd);
45 #if DEBUG
46 Utils.LogHere("SPROC Inserted " + cacheKey);
47 #endif
48 }
49
50 }
51 else
52 {
53 adapter.Fill(dt);
54 adapter.Dispose();
55 }
56
57 return dt;
58 }
59 else
60 {
61 throw new Exception("Cache key required");
62 }
63 }
64 catch (Exception ex)
65 {
66 throw ex;
67 //HttpContext.Current.Response.Redirect("Error.aspx");
68 //return null;
69 }
70 finally
71 {
72 cmd.Dispose();
73 conn.Close();
74 conn.Dispose();
75 }
76 }
77 I'm wondering if for every depdency I create, does a separate user connection get created and held open until the server restarts? Does anyone know of any good resources I can read up on user connections, I can't seem to find much information in what are acceptable valuesIs there anything else I should be doing with my SqlCacheDependencies? Do I have to put anything in my Application_End event to close them off?

View Replies !

Running Analysis Services 2005 On A Separate Sever
My first question is can I run Analysis Services 2005 on a different server to where the databases are running
If yes, any pointers to some articles.

View Replies !

How Can I Connect To Sql Sever 2005 Express From The Command Prompt.
Iam trying to connect to local copy of sql sever express from the command prompt with this command(sqlcmd) but i get the error below. What should i do to overcome the error. Basically what i want to do is to try out some commandline backup utilities and i deadly want to know how to do a backup from the command prompt. Help is greatly appreciated.
HResult 0x2, level 16, state 1
Named pipes provider: could not open a connection to sql sever [2]
sqlcmd: Error: Microsft sql native client: An error has occurred while estarblishing a connection to the sever. When connecting to sql sever 2005, this failure may be caused by the fact that under the default settings SQL sever does not allow remote connections..
Sqlcmd: Error: Microsoft sql native client: Login time out expired.

View Replies !

SQL Sever 2005 - Full Text FormsOf Inflectional
We have 2 SQL Server 2005 machines. One has the CTP version installed,the other is the RTM.When running the query below, results are returned for the CTP versionbut not the RTM version.select * from table t1inner join containstable(table, column, 'formsof(inflectional,''bücher'')') t2on t1.[id] = t2.[key]I have checked that the same data is present in the tables on bothmachines and also that the FTI has been fully populated with a statusof "idle".Please note that the word used "bücher" is a German word and shouldreturn "buch" as a match.Is this a bug with the RTM version of SQL Server 2005??

View Replies !

Can't Connect To SQL Sever 2005 After Upgrading From SQL Server 2000
I recently upgraded from SQL Server 2000 to SQL Server 2005. I have Oracle databases I need to share data with. I was using the Heterogeneous Services (hsodbc) from Oracle and connected to SS 2000 fine. Since I've upgraded, I can't use hsodbc to connect to my SS 2005 database. I get the following error:

ORACLE GENERIC GATEWAY Log File Started at 2006-09-06T09:40:07

hoainit (3): ; hoainit Exited with retcode = 0.

hoalgon (7): ; hoalgon Entered. name = edw.

DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login

failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)

DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL

Server]Login failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)

nvRETURN (F:WorkConnect_4_6_3srcdrvDRV_BIND.C 356): -2220

nvRETURN (F:WorkConnect_4_6_3srcavNAV_BIND.C 293): -2220

hoalgon (7): ; hoalgon Exited with retcode = 28500.

View Replies !

SQL Sever 2005 - Creating Alias Names Programatically
Is there a way we can programatically create a SQL server Alias name (SQL 2005 - SQL Native client configuration) using either T-SQL, C# etc. - Manmeet

View Replies !

Data Migration From SQL 2000 To SQL Sever 2005 Express
We have a SQL Server 2000 and want to migrate to SQL Server 2005 Express.

It's possible?
SQL Server 2005 Express have support to do this?

View Replies !

What Procedures Need To Be Done On A SQl Sever 2005 Database Before Commandline Backups Can Be Successfull
I have a sql sever 2005 express edition database but when i run my backup command from the command prompt, i get this error message .
The .Net SqlClient Data Provider has received a severity 16, state 11 error number 911 on line 1 of procedure on server KSS15SQLEXPRESS: Could not locate entry in sysdatabases for database 'DATABASE1'. No entry found with that name. Make sure that the name is entered correctly. The .Net SqlClient Data Provider has received a severity 16, state 1 error number 3013 on line 1 of procedure on server KSS15SQLEXPRESS: BACKUP DATABASE is terminating abnormally.
DATABASE one is the name of the database i want to backup. Now it looks there so many databases some of which i have no idea where they are. It looks like there some system stored procedures i have to run first before my database file can be located by my commands. It would be wonderfull if some one pointed me to an article that covers this initial part thoroughly.

View Replies !

Is It Possible To Install SQL Sever 2005 Developer On Vista Home Premium?
During the install, I receive this message:

"Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online."

So, I went to the following and did everything documented about installing IIS 7.0.

http://msdn2.microsoft.com/en-us/library/aa964620.aspx

After installing IIS and verifying that it is serving pages just fine, when I try to install again, I still get the quoted error message above.

I am beginning to think that I cannot install SQL Server Developer on Vista Home Premium.

Does anyone know?

Thanks

View Replies !

How To Setup Sharepoint Portal Server 2003 With SQL Sever 2005
Hello, everyone

I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)...??? I wanna know that How to setup it...

Setapong

View Replies !

SQL Sever 2005 Management Studio - Connect As Different Windows User
I want to connect to a SQL server from my workstation using the application in the Subject, but I need to connect as a different Windows user. Basically, I login to my workstation with my "Joe User" account, but for servers I used my "Joe Admin" account for security purposes. However, the Management console autofills in my workstation username when I select "Windows authentication" for the connection, and grays out the username/password fields so that I cannot specify another set of credentials.

Is there a way to change this behavior? Otherwise I will need to termserv into a server using my administrative account, install the management software there, and then begin the process. That is a lot of unecessary overhead that I would like to avoid.

Thank You,

John G

View Replies !

Installing SQL Server 2005 On Same Machine As An Existing SQL Sever 2000 Instance
Given than once SQL Server 2005 is installed, SQL Server Studio has to
be used instead of Enterprise manager, can both SQL 2000 and 2005 be
used on the same machine, be it development or production? (The second
one to be installed probably would be a named instance.)
Any experiance of doing this or a pointer to a Microsoft recommendation would be appreciated.

View Replies !

SQL Sever 2005 Write XML Data Stored In A Table Out To A XML File On My Local Machine
Hello All
Just wondered if someone could help me with a bit of T-SQL, i have a application in ASP.NET/VB that allows the user to update a message board by clicking a button "update" this in turn triggers my Stored Procedure for inserting this data into a table, which works great.
It inserts the data into its respective fields and also takes The Title, Line 1, Line 2 and so on and creates a XML file (Using FOR XML) which is stored in the same Table under a column call XML_Data. Which again works great.
My problem now is how do i output this XML_Data to an actual XML file that is on my local machine, i.e. It be created in say C:Inetpubwwwrootxmlfiles("xml file name inserted here from another column that holds xml file name").xml
Any help on this would be greatfully apreciated
Thanks In Advance
Neil

View Replies !

Load Severals Table On SQL Sever 2005 With Integrataion Services From Oracle Database
hello,

I want to load some table fromoracle database:

first : i created a datasource link between sql server and oracle database

second : i maked a flow to load data

Thus simple thing works good for one table...

But my question is how can i do for a group of table

In reality we have 30 table to do and i hear about variable, parameters ....

but i don't understand what it mean !!

so if somebody could explain to me the steps to do !!

View Replies !

SQL Sever 2005 Express Move Windowns Authentication Choice To Mixed Authentication
I folks.I Have installed sql server 2005 express and choosed windowsauthentication on instalation, but i make a mistake and now i needmixed authentication, how can i modify this whithout uninstall andinstall again the application?thanks for the help.

View Replies !

ROW_NUMBER() Function Is Not Recognized In Store Procedure.(how To Add ROW_NUMBER() Function Into SQL SERVER 2005 DataBase Library )
Can anybody know ,how can we add builtin functions(ROW_NUMBER()) of Sql Server 2005 into database library.
I get this error when i used into storeprocedure :
ROW_NUMBER() function is not recognized in store procedure.
i used MS SQL SERVER 2005 , so i think "ROW_FUNCTION()" is not in MS SQL SERVER 2005 database library.
I need to add that function into MS SQL SERVER 2005 database library.
Can anbody know how we can add that function into MS SQL SERVER 2005 database library?

View Replies !

ConCat
Hi,

Can anybody help me:

Within a group you have a column of string
values-Say states for example on a group summary
line you want a concatenation of the string state
values for all rows in the group.
so you might have
ID State
AZ
AL
MO

Summary group footer:
1 AZ, AL, MO

This is a little similar to the Sum function but instead of adding numbers I want to
concatenate strings together.

Thanks

View Replies !

Concat?
I am trying to return rows from a query and I want to display the information from 2 columns into one. Here is my query:

SELECT     TOP (100) PERCENT dbo.CASES.CaseID, dbo.CASENUMBERTYPES.CaseNumTypeDesc, dbo.CASENUMBERS.CaseNumber,
                      dbo.SCANNEDDOCUMENTS.TopicID, dbo.EVENTS.EventTypeID, dbo.EVENTS.ev_StartDate, dbo.SCANNEDDOCUMENTS.Doc
FROM         dbo.SCANNEDDOCUMENTS INNER JOIN
                      dbo.CASES ON dbo.SCANNEDDOCUMENTS.CaseID = dbo.CASES.CaseID INNER JOIN
                      dbo.CASENUMBERS ON dbo.CASES.CaseID = dbo.CASENUMBERS.CaseID INNER JOIN
                      dbo.CASENUMBERTYPES ON dbo.CASENUMBERS.CaseNumTypeID = dbo.CASENUMBERTYPES.CaseNumTypeID INNER JOIN
                      dbo.EVENTS ON dbo.CASES.CaseID = dbo.EVENTS.CaseID
WHERE     (dbo.CASENUMBERTYPES.CaseNumTypeDesc IN ('cc', 'dc')) AND (dbo.EVENTS.EventTypeID IN (7048, 6467)) AND
                      (dbo.SCANNEDDOCUMENTS.TopicID IN (2, 3, 4)) AND (dbo.EVENTS.ev_StartDate > CONVERT(DATETIME, '2008-01-13 00:00:00', 102)) AND
                      (dbo.EVENTS.ev_StartDate < CONVERT(DATETIME, '2008-01-19 00:00:00', 102))
ORDER BY dbo.CASENUMBERTYPES.CaseNumTypeDesc, dbo.CASENUMBERS.CaseNumber

I get this for my return

1526959
CC
228762
2
7048
1/16/2008 12:00:00 AM
<Binary data>
CC is my CASENUMBERTYPES and the next column (228762) is CASENUMBERS

How can I get it to return it to where the CASENUMBERTYPES and CASENUMBERS show together in one column?

View Replies !

Concat
Hi peso, hi KH, Hi everyone....

Declare @day int
set @day = 3

select right('0' + @day, 2)

My expected result is : 03
If single integer - will append in the right a '0'.
If 2 digit integer - will return the actual value.

Thanks.

-Ron-

"If you can only access one site on the Internet, make it SQLTeam!"

View Replies !

Concat Rows Help
Hi there, I'm trying to concat the results of a select statement into a single row separated by commas without duplicates. The query and output is something like this:SELECT Specification FROM Cars WHERE Model = 112Which would return something like:Specification------------------Model 1Model 2Model 2Model 4 What I'd like is these to be combined into a single row such as:Specification
------------------Model 1, Model 2, Model 4

View Replies !

Ok To Concat A Uniqueidentifier?
I want to use a NEWID() to generate order numbers, but i dont want to give customers the long uniqueID. so im wondering if i concatinate it to 8 characters, if that would be safe or not...

thx in adv

View Replies !

Concat Ntext
Hi all,

I am new to SQL Server. The concat operator (+) does not work with ntext on SQL Server. So the following statement fails:
update atable set ntextfield = ntextfield + 'more text - more fun'

But how can I append text to an ntext-field? BWT: I can only access the db through jdbc.

TIA,
albrecht

View Replies !

Concat Int With String
Hi,

I am trying to concat an int with an nvarchar in my select:

select distinct(id + name)
from load
where name not like '%test%'

but I am getting an error saying:
Server: Msg 245, Level 16, State 1, Line 1
Syntax error converting the nvarchar value '灪愭楮敭' to a column of data type int.

My question is: how do you concat int and string in MS SQL Server. The equivalent in Oracle would be ||, I think.

Thanks for any help.

Mongo

View Replies !

String Concat
Hello,

I have a string let's say: "123".
I want to convert it to:
-- Start SqlServer
BEGIN
{CALL DBA.applsp_ChangeComments( 'ArtPurchPriceUpdate', 'TRIGGER', 'nl', 'ArtPurchPriceUpdate', '1' + CHAR(13)+ CHAR(10) +
'2' + CHAR(13) + CHAR(10) +
3' )}
END;
-- End SqlServer

-- Start Sybase
BEGIN
CALL DBA.applsp_ChangeComments( 'ArtPurchPriceUpdate', 'TRIGGER', 'nl', 'ArtPurchPriceUpdate', '1' + CHAR(13) + CHAR(10) +
'2' + CHAR(13) + CHAR(10) +
'3' );
END;
-- End Sybase

-- Start Oracle
BEGIN
ish.applsp_ChangeComments( 'ArtPurchPriceUpdate', 'TRIGGER', 'nl', 'ArtPurchPriceUpdate', '1' || CHR(13) || CHR(10) ||
'2' || CHR(13) || CHR(10) ||
'3' );
END;
/
-- End Oracle

This works well for oracle and sybase, for sqlserver I can't concatenate in a parameter of a stored procedure. I really want to do this. To create a variable is a lot of extra programming. Is there anyone who knows how to cancat these strings within the stored procedure call?

thanks beforehand,

Coen Dunnink
The Netherlands

View Replies !

CONCAT Function + SQL Sever 2005

I cant find a clear answer to the syntax of concat in for SQL 2005. Can anyone help.