Viewing 15 posts - 1,471 through 1,485 (of 2,458 total)
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
-- Itzik Ben-Gan 2001
May 19, 2015 at 2:05 pm
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...
-- Itzik Ben-Gan 2001
May 19, 2015 at 1:17 pm
Angel DBA Mex (5/19/2015)
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),...
-- Itzik Ben-Gan 2001
May 19, 2015 at 12:51 pm
Or something like
ON
(Project_Code = Manager.Code AND Project_Code <> '')
OR
(Project_Code = '' AND Project_cost_center = Manager.Code)
-- Itzik Ben-Gan 2001
May 19, 2015 at 5:05 am
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...
-- Itzik Ben-Gan 2001
May 19, 2015 at 4:54 am
Jason A. Long (5/18/2015)
Alan.B (5/18/2015)
If the collation that the table is stored in is Case Insensitive then...
-- Itzik Ben-Gan 2001
May 18, 2015 at 9:48 pm
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...
-- Itzik Ben-Gan 2001
May 18, 2015 at 9:09 pm
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...
-- Itzik Ben-Gan 2001
May 18, 2015 at 8:59 pm
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...
-- Itzik Ben-Gan 2001
May 18, 2015 at 8:41 pm
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...
-- Itzik Ben-Gan 2001
May 18, 2015 at 8:29 pm
Make org_id an int.
declare @invoice table (inv_id int,inv_amt money,org_id int /*numeric(10,0)*/)
-- Itzik Ben-Gan 2001
May 18, 2015 at 8:41 am
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,
...
-- Itzik Ben-Gan 2001
May 16, 2015 at 10:58 am
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.
-- Itzik Ben-Gan 2001
May 15, 2015 at 4:42 pm
For a great tutorial try the Stairway to SQL Server Reporting Services[/url] right here on SSC.
-- Itzik Ben-Gan 2001
May 15, 2015 at 4:27 pm
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...
-- Itzik Ben-Gan 2001
May 15, 2015 at 4:14 pm
Viewing 15 posts - 1,471 through 1,485 (of 2,458 total)