data mining

Forum

Discussion, comments, and ratings of items posted to SqlServerCentral.com by Mattias Fagerlund

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-12-09

2 reads

Global Variables

by Steve-Johnson

SQL Server Magazine

Topic

I am having problems assigning global var, if I write a simple query such as: " select getdate() " and set it to an output parameter assign the output to a global var it works fine but if I use a little more complex query such as: " select sum(idh_hist.idh_qty_inv * idh_hist.idh_list_pr) as Inv FROM […]

2001-11-27

2 reads

how can i merge two datafiles in different filegro

by patilds

MSDN Communities

Topic

I would like to merge two datafiles, but they are in different filegroups. Would you know how to merge two datafiles from different filegroups. I could use DBCC SHRINKFILE then ALTER DATABASE, but this can only work if the files are in the same filegroup or I can move the tables by creating a clustered […]

2001-10-30

4 reads

replicating over WAN's

by GlennBrown

SQLServerCentral.com

Topic

Hi, I require some assistance on structuring my DB tables for replication. We (hypothetically) have a client with 2 branches, one each side of the country, linked over a WAN and replicating at an unspecified period (1 day OR 1 hours OR ..and so on ). Branch A produces a client record with the primary […]