form some article i wrote: this is just one way to do it, there are other techniques as well, ig you search SSC, there was another recent thread on the...

on the dbserver, are there any other services going on in it is it doing Exchange as well as SQL, or web hosting?

does the server also host, say, the company's...

if you look at edmunds.com, they have a typical search fro autos/old and new; i would avoid allowinging raw text/data entry for fields if possible; much easier to use predefined...

i've always done this with the user interface/web page building a dynamic SQL;

something like this (assuming all data entry comes from drop down lists, and vb.net as far as syntax:

...

you'll need to edit or rebuild your plan, i think.

I just created a new main plan, and when i look a tthe details, depending on how you set it up...

kramaswamy (7/11/2011)

---

I'm curious, why is it that using UNION instead of OR makes for performance increases? For most situations like this, the query optimiser is usually smart enough to do...

this seems to work for me:

SELECT

SUBSTRING(text150,1,60) AS text60_1,

SUBSTRING(text150,61,60) AS text60_2,

SUBSTRING(text150,121,60) AS text60_3

FROM YourTable

SELECT

SUBSTRING(text150,1,60) AS text60_1,

SUBSTRING(text150,61,60) AS text60_2,

SUBSTRING(text150,121,60) AS text60_3

FROM (SELECT 'EG

SABRE a CIRCUIT BREAKER...

I'm pretty sure it's the OR.

with a single value, it can do a SEEK, but with the OR, it has to scan to check the values that don't match the...

if you have to do this via bcp and not SSIS, then there are two ways that i can think of.

one exports a global temp table, and the other uses...

i'm very eak on this, never implemented it, but i thought there was a "Force Encyption" property on the server that could do that; otherwise it's an optional client connection...

a view is just a stored SQL statement. it gets run or rerun on demand whenever you select from it.

if you think about how indexes work, you can't put an...

yep that's what i figured; my model that i posted last will do what you are asking, but of course you have to adapt it.

I don't think you ever posted...

in SSMS, you just put everything between single quotes, lines and all: you might need to find and replace single quotes with two single quotes

DECLARE @sql varchar(max)

set @sql = '

CREATE...

there's afew posts out there that describe how the driver scans the first 8 rows to determine the data type;usually you can set the extended property "IMEX" of provider to...

do a PRINT @sql before you EXEC(@sql); that gives you the statement so you can run it independantly;

look at the costruction in the middle where you inserted EXECUTE:

...EXECUTE USE ......