Viewing 15 posts - 301 through 315 (of 389 total)
Also the configuration of tempdb database may have impact on performance of temp tables. If you have 1 million records, you should create indexes on these temp tables on fields...
...and your only reply is slàinte mhath
March 5, 2008 at 8:13 am
seems that you use alias 'c' when you generate column name, but do not use this alias for the table name in the query.
...SELECT @Line = @Line + 'c.'+...
...and your only reply is slàinte mhath
February 29, 2008 at 10:58 am
Yoou can update only one table at a time. I imagine that kind of functionality that you'd like would create quite interesting effects regarding transactions.
Wrap two updates into one transaction...
...and your only reply is slàinte mhath
February 29, 2008 at 10:52 am
You can't use local system account to get to another machine using integrated authentication. Try to run this daemon under a domain account that will be granted access to database...
...and your only reply is slàinte mhath
February 29, 2008 at 9:25 am
Why do you have two MPG fields in the query? Seems that one is taken from table (and is NULL) and the second is calculated and aliased to the same...
...and your only reply is slàinte mhath
February 29, 2008 at 9:17 am
Besides, maybe it would be better to use linked server to excel?
Piotr
...and your only reply is slàinte mhath
February 22, 2008 at 6:47 am
it's same query then, just different role_id in it.
Piotr
...and your only reply is slàinte mhath
February 22, 2008 at 6:45 am
I agree, using COM in server environment is tricky. The least can happen when something goes wrong is stealing memory - after some time - day, week or month, serwer...
...and your only reply is slàinte mhath
February 22, 2008 at 4:00 am
This code presented by Adam should return rows in normal way, provided there are data for given combination of parameters.
How many columns do you have? If a few only, I...
...and your only reply is slàinte mhath
February 22, 2008 at 3:36 am
Heh sorry, I was unclear 🙂
I also asked about clipboard as this kind of errors often occurs when you copy and paste code 🙂
Piotr.
...and your only reply is slàinte mhath
February 19, 2008 at 9:44 am
select DATEPART(year, GETDATE())
copy and paste? 🙂
Piotr
...and your only reply is slàinte mhath
February 19, 2008 at 7:23 am
Don't know if it is applicable in your case, but I would ask about any linked servers that database might require. 64bit oledb drivers can be a pain..
...and your only reply is slàinte mhath
February 18, 2008 at 6:26 am
how did you restore the database? maybe you have used NORECOVERY or STANDBY modifier?
Piotr
...and your only reply is slàinte mhath
February 18, 2008 at 6:23 am
[font="Courier New"]alter database yourdb collate new_collation[/font] will change database collation, which will be used for new objects created in this database. Yet if you want to change collation of existing...
...and your only reply is slàinte mhath
February 18, 2008 at 6:20 am
Won't
SELECT * FROM openquery(My_Excel, 'SELECT * FROM A5:B20')
work once you have the server configured? Openrowset is an ad hoc linked server after all.
Piotr
...and your only reply is slàinte mhath
January 30, 2008 at 8:33 am
Viewing 15 posts - 301 through 315 (of 389 total)