You could do this:

DECLARE @ipaddresses TABLE (ip varchar(30));

INSERT @ipaddresses VALUES

('175.139.45.127'),

('175.139.45.12'),

('175.139.45.1'),

('10.10.10.100'),

('10.10.10.10'),

('10.10.10.1');

SELECT ip = PARSENAME(ip,1)+'.'+PARSENAME(ip,2)+'.'+PARSENAME(ip,3)+'.0'

FROM @ipaddresses

Always this:

I want to find out if this is a good idea or I should design a transactional database for the application and a Data warehouse separate for the...

Angel DBA Mex (5/19/2015)

---

thanks SSC-Insane

but already I´ve found the mistake, it is when the information has imported from a txt file, this has a special character, Char(13), Char(10),...

Or something like

ON

(Project_Code = Manager.Code AND Project_Code <> '')

OR

(Project_Code = '' AND Project_cost_center = Manager.Code)

Avoid ad-hoc sql and use stored procs to drive your ssrs data. Faster queries mean faster reports; tune your queries - make em fast.

For your slowest reports consider...

Jason A. Long (5/18/2015)

---

Alan.B (5/18/2015)

---

I'm not 100% sure about this and hope someone corrects me if I'm wrong...

If the collation that the table is stored in is Case Insensitive then...

In Ben-Gan's T-SQL Fundamentals 2012 (Ch. 6) he dedicates a whole chapter to set operators. I would encourage anyone to trying to get a grasp on this topic to...

Use the parameters to create the URL like you specified and a message or something on how to create a bookmark, favorite, whatever using that string (that's just me thinking...

Note the article in my signature about how to best get help here. Sample data and some DDL would really help. That said...

This wont be too hard: the solution will...

I'm not 100% sure about this and hope someone corrects me if I'm wrong...

If the collation that the table is stored in is Case Insensitive then you use a Case...

Make org_id an int.

declare @invoice table (inv_id int,inv_amt money,org_id int /*numeric(10,0)*/)

This is a job for patexclude8K.

CREATE FUNCTION dbo.PatExclude8K

(

@String VARCHAR(8000),

@Pattern VARCHAR(50)

)

/*******************************************************************************

Purpose:

Given a string (@String) and a pattern (@Pattern) of characters to remove,

...

As others said, more details: good, cursor for this: bad.

It sounds like you can accomplish what you are trying to do with two update statements.

For a great tutorial try the Stairway to SQL Server Reporting Services[/url] right here on SSC.

Using this DDL and sample data:

USE tempdb

GO

CREATE TABLE dbo.[ACTION]

(

actionid int not null,

actionvalue varchar(100) not null

);

CREATE TABLE dbo.ACTIONRESULT

(

resultid int primary key,

actionid int not...