Eugene Elutin

Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 2,894 total)

RE: From SP to Excel

Jeffery Williams (9/29/2010)
Right....
...Not sure how my job title plays into this however any recommendations on the coding FROM a SP would be great.
...
Sorry mate, your job-title has quite a play...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 29, 2010 at 8:43 am

#1229100
RE: From SP to Excel

Looking into your job-title I can recommend hiring some programmer with SQL and/or SSIS skils.
This work can be done in Excel using Excel VBA or any other programming language which...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 29, 2010 at 7:53 am

#1229024
RE: Optimization strategy?!

frfernan (9/29/2010)
...
as far as I know a clustered index is best for sequential reading. If you create a clustered index using Attrib_Z, any query like
SELECT * FROM Widgets WHERE Attrib_Z...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 29, 2010 at 7:45 am

#1229015
RE: Optimization strategy?!

one more url:
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/cf9121b2-38e0-4735-b765-4eab91bb443b
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 27, 2010 at 10:02 am

#1227792
RE: Optimization strategy?!

scott.pletcher (9/27/2010)
I wouldn't create a clus index on an ident column. That will not help your queries. In fact, you will reduce the chance of using a nonclus...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 27, 2010 at 10:00 am

#1227790
RE: slow insert

You have primary key clustered index on your table, is it incremental?
What your triggers do?
"forever" is relative term. What is your "takes forever" means? does it time-out? Takes seconds?...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 27, 2010 at 9:43 am

#1227782
RE: Find the printer makers which also produce PCs with the lowest RAM and the highest-speed processor among PCs with the lowest RAM

Which table contains producers/makers?
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 27, 2010 at 8:54 am

#1227747
RE: Eliminating duplicate data in just one column

Happy to Help!
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 27, 2010 at 7:48 am

#1227689
RE: Eliminating duplicate data in just one column

umanpowered (9/26/2010)
...
The goal is to eliminate the duplicate data in C1. So if it was
B | X
B | Y
A | Z
The goal would be for the query to return
B...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 27, 2010 at 7:13 am

#1227674
RE: Bulk Insert Missing Data Row

check what is row delimiter in your header row, is it the same as for your daa rows?
Note: by default BCP uses (new line character) for row terminator...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 27, 2010 at 5:14 am

#1227616
RE: How can i bring this result,without using dynamic query

It does look like the table in your eample is populated by some PIVOTING query. I would recommend to have a look it and see where data is comming from...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 27, 2010 at 5:06 am

#1227608
RE: case statements

bitmask "nerd-kind" variation :-D:
;with stbb
as ( SELECT 5 AS Status, 1 AS BitMask UNION
SELECT 6 AS Status, 2 AS BitMask UNION
...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

September 15, 2010 at 4:04 am

#1221209
RE: Sp_ExecuteSQL headache

BTW, I've tried your script - it works for me.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

August 26, 2010 at 11:04 am

#1212440
RE: trouble with foreign key

krypto69 (8/26/2010)
...
The DELETE statement conflicted with the REFERENCE constraint "FK_Security_UserClientSignature_Security_UserClientMetaData". The conflict occurred in database "ASPNETDB", table "dbo.Security_UserClientSignature", column 'UserClientMetaDataId'.
The statement has been terminated.
Works fine if I delete the FKey
The...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

August 26, 2010 at 11:00 am

#1212435
RE: Sp_ExecuteSQL headache

Ness (8/26/2010)
...Execute Sp_executeSql stmt does not run the sql. The printed version looks right but it does not run against the db (verified via profiler). Any ideas?
...
What it returns to...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

August 26, 2010 at 10:52 am

#1212429

Viewing 15 posts - 2,356 through 2,370 (of 2,894 total)