Hey Everyone, What would be the most efficient way to check for numbers in a field that would contain a few letters? I would like to do this if the where statement as possible. The data would look something like this: 3833N4323 32N907654 5W5840904 ...
What is the path of least resistance in getting an SBCL application running on Windows to connect to a SQL Server instance, using integrated authentication? I have found posts on connecting from CL-SQL to SQL Server using ODBC connections but as far as I can tell, there is no way to this without first manually setting up a DSN. Is ther...
I have an SSRS 2008 report with a sub-report that takes a selected value as a parameter. For example, I have a report that takes in @ProjectID and then selects ClientID. If I pass [ClientID] as a parameter to the sub report I get an error the first time I load the report. However, subsequent loads (clicking refresh) all work fine. I do n...
Creating Comma Separated Lists In SQL Hi All, I am attempting to merge something like this in my SQL Server database: [TicketID], [Person] T0001 Alice T0001 Bob T0002 Catherine T0002 Doug T0003 Elaine Into this: [TicketID], [People] T0001 Alice, Bob T0002 Catherine, Doug T0003 ...
Lets say you have a table as such (SQL SERVER 2005) pairID childID parentID 0 1 2 1 2 3 2 3 4 And you have a CTE that return this dataset: pairID childID parentID level 0 1 2 2 1 2 3 1 2 3 4 0 How do you save the initial child ID so that yo...
is there a sample database for SQL Server 2008 that I can download to practice learning how to develop/use SQL Server...I have downloaded the SQL Server 2008 Express Edition, Visual Studio 2008, MS Web Dev 2008, ASP.NET 3.5..... ...don't think I can download anything else before I start learning how to use this stuff. Thanks guys... p...
Looking to integrate a web application with MYOB. There's not much in terms of documentation out there. I've found a couple of companies that provide middleware, but nothing promising. Just thought I'd see if anyone else out there has had experience with this and might be able to save me a bit of time. Cheers ...
I have a bunch of varchar(255) and varchar(max) fields in a table in MS SQL Server. These are generally formatted messages (email and other). Most of the fields have the actual characters "\n", but actually need a newline character. I don't need to worry about new data going forward, but don't know how to fix the stuff that's currently ...
I have the following table: if object_id(N'dbo.Node') is null create table dbo.Node ( ID bigint identity primary key, ParentID bigint null foreign key references Node(ID) on delete no action, DateCreated datetime not null, LastUpdated datetime not null, [Name] nvarchar(500) not null, ); Now, because SQL Server comp...
DECLARE @t TABLE(Words VARCHAR(100)) INSERT INTO @t SELECT 'Stack Overflow' UNION ALL SELECT 'EQUATORIAL' SELECT * FROM @t WHERE Words LIKE '%[AEIOU]%' I am getting both as the output Words Stack Overflow EQUATORIAL The desired output being EQUATORIAL Thanks ...
back end java 1.4 with EJB 3.2 data base sql server 2000 How to make asynchoronous call to a procedure from java code using jdbc? ...
how can i get all the records from 1st table not present in the 2nd table without using subquery? i would like to use Join... ...
I just downloaded Visual Studio 2008 Express Edition and I want to create a local SQL Server database so I can start local development. How do I get started? How do I create a local SQL Server database? ...
I have a site which has been running perfectly but I have just moved it from Win2003 IIS6 SQLExpress to Win2008 IIS7 on full SQL and randomly the site is going down and all I keep getting is this error? Shared Memory Provider: No process is on the other end of the pipe. Anyone have any ideas on what might be causing it? ...
Why we use CLR procedures. Is there any significance of CLR Procedures or any example where CLR Procedure is the only solution? ...
Hi I want to insert a table values from the same table is it possible? Ex : I'm trying to insert like this insert into emplyeee values (select # * from employee) Thanks in advance ...
Hi guys, Is there any way to send an SMS through SQL Server 2008? ...
If I have data rows in database and want to import data from data file with bcp utility in native mode, is there any solution (specified switch) that override data with same identity value in ID column? ...
Hi, I'm working on a knowledge base project using SQL Server 2008 Full Text Search Engine. Project included in articles and files where each article has multiple files.In those articles whole content is pure html. Right now,I successfully created fulltext catalog and index on SQL Server 2008 and my database is version 10 compatible. H...
I have the following query: SELECT DISTINCT(po.SONumber) AS [Sales Order No_], po.PONumber AS PoNo, ph.[Buy-from Vendor No_] AS VendorNo, ph.[Pay-to Name], ph.[Document Date], 'Ship-to Name' = CASE WHEN sh.[Ship-to Name] > '' THEN sh.[Ship-to Name] ELSE sih.[Ship-to Name] END, 'Ship-to Post Code' = CASE WHEN sh.[Ship-to Post Cod...