Viewing 15 posts - 1 through 15 (of 126 total)
ScottPletcher (3/4/2015)
LEFT(family, CHARINDEX('--', [family] + '--') - 2)Edit: Added the "- 2".
when I add this, its removing the text before the [--].
March 4, 2015 at 5:08 pm
Jeff Moden (3/4/2015)
What's wrong with just doing a replacement?
UPDATE tgt
SET Family = REPLACE(Family,'--','')
FROM dbo.yourtable
WHERE Family LIKE '%--%'
;
there are other apps...
March 4, 2015 at 3:30 pm
I get:
Query:
SELECT Jobs.JobFamily, JobDescriptions.[description]
FROM Jobs t1
INNER JOIN JobDescriptions t2 ON
t2.ParentRole = t1.JobFamily + '_' + t1.[description]
Error
Msg 4104,...
March 3, 2015 at 5:23 am
Luis Cazares (3/2/2015)
SQL_NuB (3/2/2015)
ScottPletcher (3/2/2015)
SELECT ...
FROM table1...
March 2, 2015 at 2:26 pm
ScottPletcher (3/2/2015)
SELECT ...
FROM table1 t1
INNER JOIN table2...
March 2, 2015 at 2:13 pm
since you can't open it, I would kick it back to the sender requesting them to separate the data some how so it can be more manageable to work with.
As...
May 23, 2013 at 6:33 am
Is there a way to break it up? If not maybe doing the import out of SQL, such as using a .NET app or something to do the import.
that's...
May 23, 2013 at 6:20 am
Single fixed query can only select the same fixed number of columns.
As you select all columns from both ends, so you will get all values.
Nulls can be values...
March 20, 2013 at 6:45 am
the values that are different so for example
if Active is true in DB2 and now coming in as FALSE in DB1, I need that.
as for NULL values, I never...
March 20, 2013 at 6:32 am
you can use SSIS to migrate your data from 1 db to another. You can create a DB with that tables you need, then create an SSIS package and point...
March 18, 2013 at 6:06 am
i'm creating the query/process to do the data compare, I was wondering if this could be done using SSIS or do queries have to be written.
March 13, 2013 at 2:09 pm
really?
I have someone else looking at it.
Anyway, salesman, FromMonth, FromYear, ToMonth, ToYear are variables that are passed into it so it returns data.
October 4, 2012 at 7:32 am
the function is a select statement that pulls from 2 tables, it should be a view, its just pulling back months, name, and sales figures.
the select shown is pulling the...
October 4, 2012 at 7:07 am
i'm not able to post data. the query is present.
if its easy to accomplish, how can I accomplish it?
October 4, 2012 at 6:23 am
Andy Hyslop (9/14/2012)
What is the data that is contained within the TimePeriod table in your WHERE clause?
Huh? The data is the model and the timeFrame.
the data is stored in the...
September 14, 2012 at 9:31 am
Viewing 15 posts - 1 through 15 (of 126 total)