Viewing 15 posts - 1,561 through 1,575 (of 2,458 total)
This is what I came up with:
SELECT
ab.AddressCode,
AddressInstance = ROW_NUMBER() OVER (Partition by ab.AddressCode ORDER BY (SELECT (NULL))),
ab.PostCode,
AddressLine1 = title_1,
...
-- Itzik Ben-Gan 2001
April 22, 2015 at 11:13 am
super48 (4/21/2015)
I have total 2.6 years experienced in ssis,ssrs,ssas.still I don't feel I have enough experience on these tools.
even though I have knowledge I didn't worked on many features...
-- Itzik Ben-Gan 2001
April 22, 2015 at 8:25 am
Hello and welcome to SSC. I am not clear about what the purpose of the billing table is again. How does this table get updated and what's it's purpose?
Just...
-- Itzik Ben-Gan 2001
April 21, 2015 at 1:42 pm
caojunhe24 (4/21/2015)
so month should be reset in the first loop before second loop starts.
While (@year...
-- Itzik Ben-Gan 2001
April 21, 2015 at 12:35 pm
No problem. Glad to help.
-- Itzik Ben-Gan 2001
April 21, 2015 at 11:18 am
This is a job for a Tally Table! Read this article and it will change your life:
The "Numbers" or "Tally" Table: What it is and how it replaces a...
-- Itzik Ben-Gan 2001
April 21, 2015 at 11:01 am
I'm with Sean - this is a bizarre requirement. This will get you started...
WITH
E1 AS (SELECT N FROM (VALUES (1),(1),(1),(1),(1),(1)) t(N)),
E2 AS (SELECT TOP 26 N = ROW_NUMBER() OVER...
-- Itzik Ben-Gan 2001
April 21, 2015 at 9:15 am
Minnu (4/21/2015)
The solution provided by are working fine..
but there is a change in my result.
my request is
if a record_1 is in Table_A and Table_B, then
output : record_id_1...
-- Itzik Ben-Gan 2001
April 21, 2015 at 8:41 am
dwain.c (4/20/2015)
Sean Grebey (4/20/2015)
dwain.c (4/20/2015)
With regards to your thread's subject:The only stupid query questions are the ones you don't ask.
Lol I feel like it was an easy question but I'm...
-- Itzik Ben-Gan 2001
April 20, 2015 at 9:19 pm
I used to have all of the functions and stored procs but can't find them at the moment.
If you create the Master Data Services DB (#1) you just need to...
-- Itzik Ben-Gan 2001
April 20, 2015 at 9:14 pm
ScottPletcher (4/20/2015)
Alan.B (4/17/2015)
What's wrong with this?
SELECT
DbName = db.name,
FileType...
-- Itzik Ben-Gan 2001
April 20, 2015 at 3:24 pm
I have run into the exact same thing. I can say that I have had some (limited) success with secondary XML indexes. XML indexes are are kind of a black...
-- Itzik Ben-Gan 2001
April 20, 2015 at 3:21 pm
. I figured I'd add my take since I was already looking into it. Often there are more than a few ways to skin the proverbial cat. ;-)
I think it's...
-- Itzik Ben-Gan 2001
April 20, 2015 at 2:34 pm
Take a look at this: SQL Server failover cluster rolling patch and service pack process[/url]
-- Itzik Ben-Gan 2001
April 20, 2015 at 2:21 pm
The logic you are looking for would look like this:
DECLARE
-- possible values: 'Starts With', 'Is Equal to', 'Not Equal to'
@filterType varchar(20) = 'Starts With',
@filterValue varchar(100) = 'abc';
SELECT *
FROM...
-- Itzik Ben-Gan 2001
April 20, 2015 at 2:13 pm
Viewing 15 posts - 1,561 through 1,575 (of 2,458 total)