First of all, in the OP the example is using a...

I'm sorry that I didn't wade through the details of your code. But if you need to run one compplex query that produces output that you want to use in...

...duplicate post

I know this seems after-the-fact now, but if you don't have sufficient administrator privileges (such as on a public shared server like GoDaddy) you can still copy the tables and...

I think this may do what you are trying to do. If the search term is in both tables then the matching row only from Table A displays, otherwise ALL...

duro654321 (11/17/2012)

---

hello,

right now on my search page the sql query i am using is similar to:

select * from table where name like '%search%'

and it returns the exact phrases perfectly

however...

Here's a method to parse the string by using a second delimited string of the keywords themselves used as the delimiting values. The strings are split using the DelimitedSplit8K function.

DECLARE

...

Lowell beat me to it...use temp tables.

Stored Procedure 3 calls Stored Procedure 1 which puts the results1 into #TempTable

Stored Procedure 3 calls Stored Procedure 2 which puts the results2 into...

I'll take a flyer having just scanned briefly the stored procedure in the OP.

Ideas to consider:

1. As someone said above: "divide and conquer" -- that is, see if you can...

You could try:

Right-click on db name, select Tasks -> Generate Scripts

There you have a number of scripting options including scripting out Users, Roles, and Schemas. There is an advanced options...

poratips (11/1/2012)

---

Hi,

We have Sql server 2008 R2 and i would like to set up my new test server and copy production DB to new test Server.

Could you please show me...

The output appears to be sorting exactly as specified. It's ordered first by SeqNum and then within each group...

Create a stored procedure like this (I will assume you have already created the splitter function):

CREATE PROCEDURE dbo.GetTypeDesc

@strTypes VARCHAR(255)

,@strDelimiter CHAR(1)

AS

BEGIN

...

I can't tell from the query plans or your posts if your temp table has a primary key. If not, create a primary key when declaring the table and perhaps...

Use Jeff Moden's splitter function (copied below for convenience).

/* Sample Data */

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

DROP TABLE #TempTable

CREATE TABLE #TempTable (

[ID] INT IDENTITY(1,1) NOT NULL,

...