Viewing 15 posts - 58,051 through 58,065 (of 59,048 total)
That's because all the good guys are on this forum ![]()
You can get rid of the trailing...
June 28, 2006 at 1:01 am
If you can read it (dang, that's small print
), Tim's WHILE loop works just fine on the straight output... so I'll concentrate...
June 28, 2006 at 12:29 am
Yep... not enough coffee there... you can do it with a table but not a proc.
June 27, 2006 at 11:42 pm
I didn't read the column name... Serqiy is correct. I don't allow folks at work to store XML in any database at anytime. I make the rip it apart and...
June 27, 2006 at 5:53 am
Or...
IF OBJECT_ID('dbname.dbo.objectname') IS NOT NULL
DROP objecttype dbname.dbo.objectname
June 26, 2006 at 8:49 pm
Get External Data cannot see sprocs or results of sprocs. You will need to make a "pass through" query. See the Excel documentation for help on that.
June 26, 2006 at 8:40 pm
CHAR adds trailing spaces until the column is full. When you convert to VARCHAR, those spaces are retained and that's probably what is making the join fail.
June 26, 2006 at 8:38 pm
Lookup the following in Books Online (Transact-SQL Help from Query Analyzer)...
sp_addlogin
sp_grantdbaccess
June 26, 2006 at 8:35 pm
Two tables with a common key will be much much easier than a Text column... put the VARCHAR(8000) column in the second table along with the primary key of the...
June 26, 2006 at 6:38 pm
How big is the numerator? Do you want the quotient with or without decimal places? If so, how many do you want or are you willing to put up with...
June 26, 2006 at 6:35 pm
Thought I'd take a bit more time to show what you can do with a template (this also correct's a minor logic error in the WHERE clause of the...
June 25, 2006 at 1:34 pm
Aye. Thank you for the tips... there have been several discussions over temp tables and table variables and most have involved some form of blood-letting
June 24, 2006 at 6:37 pm
Thanks Brian... looking forward to it. Enjoying my weekend, too! Slept the whole day! First time in more than a year! ![]()
June 24, 2006 at 4:11 pm
Viewing 15 posts - 58,051 through 58,065 (of 59,048 total)