Programming SQL

Parse Name Field into First Name Last Name
I have a field called [Patient Name] that I want to parse out into a First Name Field and Last Name Field. I am using the Charindex() to find the comma that seperates the First and Last Name, I am then passing the Charindex value to the Left Function to grab the Last Name. Below is what the code looks like: LEF... 8 Dec 2009 16:27

Collation conflict when executing stored procedure
Hi A few years back some programmers in India wrote me a VB application to export data from a sql 2k db. One part of this programme involves invoking a stored procedure. Earlier this year my host compulsorily upgraded my db to sql 2008 and since then this part of the app is broken. When I start the export it... 8 Dec 2009 18:42

Newbie Installing AdventrueWorksDW2008 in another Drive
Hello I looking forward to learn SQL Server running some tutorials but I got stuck when installing AdventureWorksDW2008 given that my SQL files are in a drive different than C: THis is the error I get, which seems to be a linking problem TITLE: Microsoft SQL Server Management Studio ------------------------------ ... 8 Dec 2009 00:00

Help with Update statement
Hi, I am from Access background. I am stuck with write store procedure in SQL. How do I convert Access update statement below into SQL update one UPDATE tblProject INNER JOIN tblProjectWorkplan ON tblProject.Pr_ObjectID = tblProjectWorkplan.Pjw_Pr_ObjectID SET tblProjectWorkplan.Owner = "Ratha" WHERE (((tblP... 8 Dec 2009 00:00

xp_cmdshell sql 2008
sql 2008 enterprise I'm getting the following message from a user that needs access to xp_cmdshell. I "think" I've properly created a proxy account and assigned it to the user, but I'm not 100% sure. Are there step-by-step directions for setting this up, or can someone help with this error? xp_cmdshell is ... 7 Dec 2009 19:38

Different content types
Hello, At the moment I am working on a web application and I have a Assets table as follows: create table dbo.Assets ( Id int not null, Content varbinary(max) filestream constraint DF_Assets_Content default(0x), [Key] uniqueidentifier not null rowguidcol constraint U_Assets_Key unique, MimeId int ... 7 Dec 2009 12:56

Create Adjancency Model From Flat Data?
Gurus, I have some book club categories in a text file. I need to fit them into an adjacency-model structured table. After playing around with a lot of procedural-class code, I would like to make this as set-based as possible. I don't know if it's better to send each line of the text file to a proc at a time,... 13 Dec 2009 14:19

re sql result set where value increments
Sorry for the delay in responding: Raw data set looks like (compressed): DT Temp Seq 08:00:01 27 2 08:00:02 29 2 08:00:03 31 3 08:00:04 33 3 08:00:05 35 4 08:00:06 32 2 08:00:07 31 3 08:00:08 32 3 08:00:09 34... 6 Dec 2009 22:47

Lock_timeout with ADO.NET?
I have found how to set the SQL lock_timeout setting with the connection string using JDBC, but it appears it's impossible with ado.net. Is there a way and I am just overlooking it? ... 11 Dec 2009 02:39

Send Unlimited Free sms World Wide
http://www.smsvoip.co.cc ... 6 Dec 2009 09:32