it can be eiter TSQL, SSMS, SQLCMD...

I have to create those tables locally, the files are already located on the local machine that i need.

I went back to basic...

i needes to ad the PK on the row that Im using as a where (IdRow)

it took 10minutes to process..

Thank you

sometimes arent that complicated, we...

this is my table definition:

CREATE TABLE [dbo].[ServiceGroupMappingII](

[IdRow] [bigint] NULL,

[MacAddress] [varchar](32) NULL,

[SG300] [int] NULL,

[SG500] [int] NULL,

[SG800] [int] NULL,

[SG1000] [int] NULL

) ON [PRIMARY]

I changed that code for this to scan only one...

Thank you all 🙂

I made it work !

Thank you all for your help.. 🙂

always a pleasure to be guided for the experts !

Okay.. I started to do the transaction replication (since I only need the changes for those tables) Ive my server on a Cluster and SQL is Standar version. Both databases...

I need to sync every 5 minutes the data of few tables from one database to another..i guess I shoudl use Replication right ?

omg! that it was pretty simple. I really couldnt find it before 🙂

Thank you so much! it really save me a lot of time

😀

that what I thought ! :crying:

I was trying to avoid to storage the BoxId becasue I will have millions of rows..

thank you tho 🙂

Yes, in my Fact Table I only storage totals by category (or Keys).. My Report is coming from the FactTable. am I clear?

My problem is that in my FactTable I dont have the BoxId, because there are million of boxes present for category. In my Fact Table I have my categories or...

Im pulling my data from SQL database inserting into the data warehouse. I update if the total change if i process the same day.

Thank you 🙂

Exactly.. how can I do it in daily process to populate my fact table..

You are right. I'm missing one part of the problem. Each HD Box can be in different category. so the daily process "group by" de boxes in different categories., so...

I created a Script in SQL to do it.

I used SSIS to load the FlatFiles into my tables and I run this script.

Declare@TableName varchar(60)

, @min-2 int

, @max-2 int

, @ColumnName varchar(60)

,...