Viewing 15 posts - 1,021 through 1,035 (of 4,080 total)
To import your file into a table:
From SSMS, make sure you have the object explorer open and your database name displayed on the left hand side.
Right click on...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 12, 2011 at 9:41 am
First things first. You need to get your file of numbers into SQL. If there are a huge number of them, they will need...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 12, 2011 at 7:58 am
Ninja is wise.
With a calendar table you can also do things like add columns for each country you might be working with, so you can define...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2011 at 8:26 pm
Yes, i have values in Puma which are not integers(that's why i am casting my ID in Masada table to varchar)....
Although I feel certain this comes too late, I feel...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2011 at 3:00 pm
You might also look at full-text searches and full-text indexing.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2011 at 2:19 pm
Define a CTE for the PUMA table which eliminates rows containing any characters other than 0-9. Then join to that CTE as shown below. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2011 at 2:05 pm
sandyinfowave (7/11/2011)
Here is the queryselect c.ID
from
Masada c with (nolock),
Puma r with (nolock)
where right('000000' + cast(c.ID as varchar(7)),7) =r.ID
Masada table has around 2 million records
Try this:
select *
from Masada...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2011 at 1:24 pm
Jason,
Although we often use hate language when we joke about cursors, blind hatred is not our motivation. The simple fact is they are far too often used...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2011 at 1:00 pm
I wouldn't expect padding to add two seconds unless millions of rows were involved.
Could you possibly publish the actual code you are running, the schema of the tables, and the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2011 at 12:11 pm
WHILE loops are not necessarily faster than cursors and in fact may be slower than some cursors.
The problem with both WHILE loops and cursors is that they retrieve...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 11, 2011 at 7:09 am
I may have to set up a test tonight. I'm curious about how the sorts play out as the volume ramps up.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 10, 2011 at 5:49 pm
Yes, it does.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 10, 2011 at 1:31 pm
Please do check again ... I changed my data slightly and am seeing unexpected results with the new WHERE clause. But you are definitely on the right...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 10, 2011 at 12:28 pm
Paul, I tried your code against the data from my example and no rows were returned. I think the proper WHERE clause should be
WHERE...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 10, 2011 at 12:16 pm
Doesn't look like you can do it that way.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319138
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
July 9, 2011 at 3:48 pm
Viewing 15 posts - 1,021 through 1,035 (of 4,080 total)