Viewing 15 posts - 5,461 through 5,475 (of 13,874 total)
how to query dynamic values to include only row that match ALL items.
'Select *...
July 3, 2017 at 10:22 am
I see that you have built the package with 64 bit runtime on and...
July 3, 2017 at 10:13 am
July 3, 2017 at 10:06 am
Please note that you have posted in the SQL Server 2016 forum, and that your comment about lag/lead is therefore somewhat puzzling. Why did you not post in the forum...
July 3, 2017 at 7:08 am
June 30, 2017 at 5:58 pm
June 30, 2017 at 11:03 am
June 30, 2017 at 8:25 am
Please take heed of the requests for sample data, in a consumable format (see the link in my signature for details).
And when you provide desired results, make them match...
June 30, 2017 at 7:31 am
June 30, 2017 at 6:54 am
A question about distributed databases. After a migration to SQL2016, we used a DWH...
June 30, 2017 at 6:04 am
Just to clear things up a little. An object variable is used to hold a full result set and this is what drives the number of iterations of the FOREACH...
June 30, 2017 at 5:54 am
fairly new still to SSIS (Using Visual Studio 2010) to get data into a SQL...
June 30, 2017 at 5:47 am
June 30, 2017 at 5:43 am
Did you even try? It's not a great leap from what I posted.CREATE TABLE dbo.NPI100
(
NPI VARCHAR(10) NOT NULL
, EntityTypeCode VARCHAR(1) NULL
);
June 29, 2017 at 1:56 pm
After removing all the 'fluff', it would look something like this:
CREATE TABLE dbo.NPI100
(
NPI VARCHAR(10) NOT NULL
, EntityTypeCode VARCHAR(1) NULL
);
GO
ALTER...
June 29, 2017 at 1:42 pm
Viewing 15 posts - 5,461 through 5,475 (of 13,874 total)