Viewing 15 posts - 121 through 135 (of 405 total)
ams00601 (5/27/2016)
looking at the example data below, is it possible to sum up just those rows where ProductID = 1 and leave these plits for the other rows...
May 27, 2016 at 5:01 am
Not enough information to figure out whats happening. What you could do is import both results to two different tables and figure out the the row the first 4 columns...
May 27, 2016 at 4:53 am
Assuming your source is flat file, what is your row terminator?
Is the row terminator is present in those column values?
May 27, 2016 at 3:31 am
Reading the question I too thought why not you use a like '% %' or a '% % %' if they are not adjacent. Unless we are not understanding...
May 26, 2016 at 5:47 am
declare @dbname varchar(50),@objname varchar(20),@sql varchar(1000)
set @dbname='XYZ'
Set @objname='TMP'
Set @sql=N'Select * from '+@dbname+'.sys.objects where name = '''+@objname+''''
Execute (@sql)
May 26, 2016 at 5:28 am
John Mitchell-245523 (5/26/2016)
May 26, 2016 at 5:20 am
richlion2 (5/26/2016)
Attached is a real example from one of my databases (not my design BTW). It shows a table with 2 first...
May 26, 2016 at 4:30 am
eldosepd (5/24/2016)
Even...
May 24, 2016 at 11:12 am
No, You cannot use a different name for same database since it is designed as a fail over technology.
May 20, 2016 at 8:30 am
After the first insert you need to get the inserted value and use it in second insert query.
Search on SCOPE_IDENTITY() for more info.
May 20, 2016 at 7:06 am
You can get some info from DMV, if the instance hasn't been restarted in between.
https://sqlserverperformance.wordpress.com/2010/04/20/a-dmv-a-day-%E2%80%93-day-21/
May 16, 2016 at 9:11 am
My thought is same as Phil's. If its a new database start by creating indexes for all FKs. If its a proper normalized design, most of these FKs need to...
April 25, 2016 at 10:07 am
john,
Ben has mentioned from newer to older version. So backup restore wont work for him.
Ben,
You can create a generic script but you might need a lot of work in that...
December 8, 2015 at 3:16 am
Grant Fritchey (12/2/2015)
December 2, 2015 at 2:42 am
Viewing 15 posts - 121 through 135 (of 405 total)