Viewing 15 posts - 391 through 405 (of 670 total)
I'm not sure where the 'sample' label is coming from, but you can use a pivot to get your results
declare @vs_string varchar(max) = 'create table #T (Name varchar(10), Code varchar(10),...
May 6, 2011 at 6:18 am
IMHO, I think using one table for all lookups gets real ugly real fast. I'd much prefer having a separate lookup table for each lookup. It is easier...
May 5, 2011 at 1:39 pm
Dan,
we have a very similar process. Our heavy loads average around 1000 inserts/second and have never had an issue with the primary ley violation. Can you post the...
May 5, 2011 at 10:32 am
Your results don't match the sample data. I looked at itemid 1105 and I'm not sure where your numbers are coming from. I also don't understand what results...
May 5, 2011 at 8:33 am
CREATE TABLE #Customer
(CustID INT, CustLastName VARCHAR(30), DOB DATETIME
, Addr1 VARCHAR(30), Addr2 VARCHAR(30),...
May 5, 2011 at 8:07 am
Chuck,
I'm not sure I understand what you are saying. I ran this against the AdventureWorks database and the sorting was as I expected. Hardcoded or dynamic. Can...
May 5, 2011 at 7:47 am
what exactly is your question? Have you tries BOL?
May 5, 2011 at 7:33 am
One of the scripts that we use is to create and load data into a work table with the same layout as the partitioned table. Then when the loading...
May 4, 2011 at 8:24 am
It would be alot easier for us to help you if you provided some table layouts, sample data and expected results. From what I can see, you're going to...
May 4, 2011 at 7:10 am
How about getting the first record in the temp table since the identity column is being used. Something like this
declare @TopElementClassCode varchar(30)
...
May 3, 2011 at 1:28 pm
I modified your temp table and then performed a 'quirky update' to get the DataRowID. You'll have to test this with the volume of data you described.
DECLARE @p_FileData ...
May 3, 2011 at 8:42 am
don't forget the where clause or all of your records will be the same 😉
March 6, 2011 at 5:01 pm
Did you try using the machine name or DNS Alias instead of the IP Address? You should use the IP Address if possible, since they can change. If...
February 10, 2011 at 12:29 pm
Hai
Select [Quarter Name], Region, [Provider Name],
SUM([Total Visisits Count]) as SumofVisitCounts, sum([100% reconciled]) as [100% Reconciled],
0 as tot_100pervisitscnt, 0 as PercentRecon
into #Final_table
from #SemiFinal_Table
cast the PercentRecon and tot_100pervisitcnt to 0 will make...
February 10, 2011 at 12:05 pm
can you post the table script and some sample data?
February 10, 2011 at 10:18 am
Viewing 15 posts - 391 through 405 (of 670 total)