Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Discussions in... - www.microsoft.com/communities/newsgroups... | Site profile

Site profile page for http://www.microsoft.com/communities/newsgroups.... This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups.... This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:

1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.

Title: Discussions in microsoft.public.sqlserver.programming - http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.programming Discussions in microsoft.public.sqlserver.programming
Url: http://www.microsoft.com/communities/newsgroups...
Users activity: 3 posts per thread
site activity: 143 active threads during last week
Site rank: 7,895 (go to rank page)
Domain info for: microsoft.com
 

Posting activity table on Discussions in microsoft.public.sqlserver.programming:

  Week Month 3 Months
Threads: 143 344 935
Post: 382 940 2,724
 

Authority Badge:

Discussions in microsoft.public.sqlserver.programming | Forum Authority Badge

Discussions in microsoft.public.sqlserver.programming posting activity graph:

Posts by:  day  week  month 
 

http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.programming Alexa graph:

Top authors on Discussions in microsoft.public.sqlserver.programming during last week:

Name
Posts
Plamen Ratchev
28
user's latest post:
Invalid length parameter passed...
Published (2009-11-25 11:26:00)
  The problem is that you have a description value that does not contain a '-'. Try this: SELECT CASE WHEN CHARINDEX('-', descr) > 0 THEN LEFT(descr, CHARINDEX('-', descr) - 1) ELSE descr END AS descr FROM inventory;
Erland Sommarskog
14
user's latest post:
2005 - Integer may not be NULL...
Published (2009-11-24 15:36:00)
  Rich Lawson (nospam@nospam.com) writes: > I have some fields that are being imported with SSIS which are integers. I > have tried to tell SQL 2005 to default to 0, zero, but when it is imported > with SSIS, the blank field becomes NULL. Since I don't know SSIS, I cannot help you, but why are the columns nullable in the first place? Overall, the table seem have a lot of nullable columns. I don't know...
Tom Cooper
14
user's latest post:
Need help with Indexed View that...
Published (2009-11-25 11:16:00)
  I agree with Michael, you probably will get acceptable performance with a regular view. Of course, the only way to know is to simulate your system with realistic amounts of data and query volumne. If you do that, you may well find that performance is fine, or that you have a performance problem, but the bottleneck is somewhere else in your system. If you do decide that you need an indexed view, I don't think it is possible to...
Uri Dimant
12
user's latest post:
data from Excel into SQL Server...
Published (2009-11-25 07:26:00)
  Yes, one option if I understood you correctly is to use Multiflatfile connection manager, see details in the BOL "Doug Howell" <douglasehowell@gmail.com> wrote in message news:3e4fdbdc-7bad-4114-8359-0419941a8ca5@m26g2000yqb.googlegroups.com... > I've never used SSIS wizard before, but it seem like a "one time" data > import tool. > > The current...
Kalen Delaney
10
user's latest post:
column with UNIQUE and NOT NULL...
Published (2009-11-17 23:36:00)
  Hi AliRezaGoogle You are mixing up logical and physical constructs. Keys are a logical construct, just an expression of the behavior you want. Physical constructs are the actual method of implementation. If you declare a primary key, SQL Server will implement that with a non-null unique index. The default is to make it a clustered index, but that is not necessary. (The non-null and unique IS necessary. ) In fact, in many cases...
--CELKO--
10
user's latest post:
Localized Tables in...
Published (2009-11-23 17:16:00)
  >> Well, this is my idea and questions. Am I planning this correctly?<< No. There are ISO codes for languages, so do not invent your own. Depending on the article's area of study, you will find an industry standard identity (and it is never a silly IDENTITY). For example there is the ISSN (International Standard Serial Number) for magazines. Do not talk to database people; talk to a librarian. This...
Michael Coles
9
user's latest post:
Need help with Indexed View that...
Published (2009-11-25 08:46:00)
  If you put the query I gave you in a table-valued function or stored proc and pass in the SKU as a parameter, and add the SKU to the WHERE clause predicate you will probably see acceptable performance. The key is that you're doing this for one SKU at a time, so with a little index-tweaking on your tables I would imagine your performance would be good. "Sam" <Sam@discussions.microsoft.com> wrote...
Phil Brammer
8
user's latest post:
Round-ding... in...
Published (2009-11-25 06:56:00)
  "JeffP->" <JeffP@discussions.microsoft.com> wrote in message news:8DBB559C-705A-4DDC-A81C-F5E539952728@microsoft.com... > a penny. It just irks me that Excel is the defacto calculator, not a real > calculator or real math but Excel math. Perhaps someone should stop using Excel... ;) .  
Keith G Hicks
8
user's latest post:
update trigger question in...
Published (2009-11-25 09:31:00)
  That's what I thought. Just wanted to be sure I wan't missing something. Thanks. "Plamen Ratchev" <Plamen@SQLStudio.com> wrote in message news:V9WdnRQ1WocM2JDWnZ2dnUVZ_opi4p2d@speakeasy.net... > Collation defines how strings are compared and sorted (as well as the > character set for non Unicode data), so it will have no effect on values > like INT and date. >...
TheSQLGuru
8
user's latest post:
Select Query Problem in...
Published (2009-11-24 15:56:00)
  how about multiple EXISTS clauses? select * from table t1 where name like 'roma%' and exists (select * from table t2 where t2.name = t1.name and t2.address = t1.address and t2.skills = 'manager') and exists (select * from table t2 where t2.name = t1.name and t2.address = t1.address and t2.skills = 'engineer') I note that that query would be simple if you had a surrogate key such as an identity column...
 

Top 10 active forums on Discussions in microsoft.public.sqlserver.programming during last week:

microsoft.public.sqlserver.programming - 301 new posts microsoft.public.sqlserver.programming - forum profile
 

Top 10 forums on Discussions in microsoft.public.sqlserver.programming:

microsoft.public.sqlserver.programming - 42,316 posts microsoft.public.sqlserver.programming - forum profile

Latest active threads on Discussions in microsoft.public.sqlserver.programming:

Discussions in microsoft.public.sqlserver.programming
Started 1 day, 18 hours ago (2009-11-25 11:26:00)  by Plamen Ratchev
The problem is that you have a description value that does not contain a '-'. Try this: SELECT CASE WHEN CHARINDEX('-', descr) > 0 THEN LEFT(descr, CHARINDEX('-', descr) - 1) ELSE descr END AS descr FROM inventory;
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (2 posts) Thread info: Invalid length parameter passed to the SUBSTRING function in
microsoft.public.sqlserver.programming Size: 513 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Invalid length parameter passed to the SUBSTRING function in
microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
Discussions in microsoft.public.sqlserver.programming
Started 2 days, 10 hours ago (2009-11-24 19:19:00)  by Michael Coles
Here's a query to get you started. It grabs 2 of your vendors for each product with the lowest prices. Note that if the 2nd and 3rd vendors offer the same product for the same price there's no way to guarantee which one will be returned since no business rule is defined for that: SELECT * FROM ( SELECT ROW_NUMBER() OVER (...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (6 posts) Thread info: Need help with Indexed View that shows lowest prices in
microsoft.public.sqlserver.programming Size: 1,231 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Need help with Indexed View that shows lowest prices in
microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
Discussions in microsoft.public.sqlserver.programming
Started 1 day, 19 hours ago (2009-11-25 10:31:00)  by Plamen Ratchev
You can use FOR XML PATH to concatenate the values: SELECT DISTINCT A.LicenseId, STUFF(S.states_list, 1, 1, '') AS states_list FROM #Temp AS A CROSS APPLY (SELECT ',' + B.StateCd FROM #Temp AS B WHERE B.LicenseId = A.LicenseId FOR XML PATH('')) AS S(states_list);
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (2 posts) Thread info: Query Help. in microsoft.public.sqlserver.programming Size: 576 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Query Help. in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
Discussions in microsoft.public.sqlserver.programming
Started 1 day, 20 hours ago (2009-11-25 09:31:00)  by Plamen Ratchev
When you use aggregate functions you have to use the GROUP BY clause to list the grouping columns. Try the following query (notice the predicates on the Customer table are moved from the WHERE clause to the JOIN conditions, otherwise they turn the outer join to inner join): SELECT sp.FirstName + ' ' + sp.LastName AS SalesPersonName,...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (3 posts) Thread info: tough sql statement help please in microsoft.public.sqlserver.programming Size: 1,630 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: tough sql statement help please in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
Discussions in microsoft.public.sqlserver.programming
Started 2 days, 10 hours ago (2009-11-24 18:51:00)  by Plamen Ratchev
The UPDATE function evaluates to true if the column is listed in the SET clause of UPDATE statement. It does not necessary mean that the value is changed. You can join the Deleted and Inserted virtual tables on NameID and then check if FirstName or LastName is different, then update the FullName column. Below is how it may look. But ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (7 posts) Thread info: update trigger question in microsoft.public.sqlserver.programming Size: 1,124 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: update trigger question in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
Discussions in microsoft.public.sqlserver.programming
Started 1 day, 20 hours ago (2009-11-25 08:46:00)  by tnichols333
2005 - thanks for any help you can provide!!! Uri Dimant wrote: >What is the version of SQL Server are you using? > >> Howdy - and thank you in advance for any help!!! >> Here is what I have so far: >[quoted text clipped - 29 lines] >> g.beginingdate >> g.endingdate ....
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (2 posts) Thread info: tough sql statement help please in microsoft.public.sqlserver.programming Size: 727 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: tough sql statement help please in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
Discussions in microsoft.public.sqlserver.programming
Started 1 day, 22 hours ago (2009-11-25 07:06:00)  by Uri Dimant
Hi Use SSIS Package "Doug Howell" <douglasehowell@gmail.com> wrote in message news:8f4372b8-e019-40e9-b507-273bc0b2881d@j19g20 00yqk.googlegroups.com... >I currently have some code in an Excel 2007 workbook which takes data > out of a worksheet and creates records in two different Access 2007 > tables. > > I ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (5 posts) Thread info: data from Excel into SQL Server 2008 via VBA in
microsoft.public.sqlserver.programming Size: 4,317 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: data from Excel into SQL Server 2008 via VBA in
microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
 

Hot threads for last week on Discussions in microsoft.public.sqlserver.programming:

microsoft.public.sqlserver.programming
Started 2 days, 22 hours ago (2009-11-24 07:11:00)  by TheSQLGuru
1) what do you mean "retry"? can you explain the objective a bit better? 2) if possible, I recommend moving the person information to one table with a primary key. then put the skills (0-n of them) in a separate table that has the PK from the person table. this is basic data normalization, which is something you probably should ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (10 posts) Thread info: Select Query Problem in microsoft.public.sqlserver.programming Size: 695 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Select Query Problem in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 1 week, 1 day ago (2009-11-18 08:16:00)  by Plamen Ratchev
On SQL Server 2008 you can use a table-valued parameter: CREATE TYPE store_type AS TABLE (storeid INT); GO DECLARE @t store_type; INSERT INTO @t (storeid) VALUES(1); EXEC sp_executesql N'SELECT storeid FROM @t', N'@t store_type READONLY', @t; GO...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (8 posts) Thread info: Dynamic SQL againest a table variable in
microsoft.public.sqlserver.programming Size: 665 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Dynamic SQL againest a table variable in
microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 4 days, 6 hours ago (2009-11-22 23:21:00)  by Balaji
Hi Sam, You query may be some thing like this... select * from table where datetimecol >= convert(varchar(30),dateadd(mi,-30,GETDATE()),108) Regards, Balaji "sam0204" <u56410@uwe> wrote in message news:9f87af27dfbf3@uwe... > Hi all, > > I have a database which is similiar to > > id ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (8 posts) Thread info: Display data every 30 minutes interval in
microsoft.public.sqlserver.programming Size: 1,698 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Display data every 30 minutes interval in
microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 1 week ago (2009-11-19 06:46:00)  by Erland Sommarskog
Tony Johansson (johansson.andersson@telia.com) writes: > I just wonder if I use window autentisering for a SQL server on a server > where I can log in to how can SQL Server let me do so. I assume that SQL > Server will not insert any kind of window account into the SQL Server > database. So I can't understand how SQL Server can use my ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (7 posts) Thread info: about autentisering in microsoft.public.sqlserver.programming Size: 2,337 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: about autentisering in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 1 week, 1 day ago (2009-11-18 09:32:00)  by Tom Cooper
select * from #tmp1 where (right(pwd,1) = ' ' and datalength(pwd) > 0) Or (right(login,1) = ' ' and datalength(login) > 0); Tom "Rich" <Rich@discussions.microsoft.com> wrote in message news:72FF1EC0-902C-4916-9273-BB9B2D8D4B14@micros oft.com... >I need to isolate/retrieve rows from the following sample data where ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (7 posts) Thread info: isolate rows where varchar columns contain a trailing space in
microsoft.public.sqlserver.programming Size: 2,418 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: isolate rows where varchar columns contain a trailing space in
microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 2 days, 4 hours ago (2009-11-25 01:16:00)  by Uri Dimant
Hi Do you have lastest service pack? What if you insert the data via query builder rather than SSMS? "Jan Karel Pieterse" <jkpieterse@netscape.net> wrote in message news:VA.00000623.17985d40@netscape.net... > Hi, > > Using SQL Server 2005. > > I have a table with one required field (key ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (7 posts) Thread info: Unable to insert record in table in microsoft.public.sqlserver.programming Size: 2,324 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Unable to insert record in table in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 2 days, 10 hours ago (2009-11-24 18:51:00)  by Plamen Ratchev
The UPDATE function evaluates to true if the column is listed in the SET clause of UPDATE statement. It does not necessary mean that the value is changed. You can join the Deleted and Inserted virtual tables on NameID and then check if FirstName or LastName is different, then update the FullName column. Below is how it may look. But ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (7 posts) Thread info: update trigger question in microsoft.public.sqlserver.programming Size: 1,124 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: update trigger question in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 6 days, 21 hours ago (2009-11-20 08:19:00)  by Linchi Shea
Whatever answers you get here are no substitute for the detailed description in the Books Online on this subject. I suggest you take a read there. That said, with the full recovery mode, the most significant advantage is that you can recover to a point in time if you back up your transaction log regularly and preserve the log ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (6 posts) Thread info: recovery mode in microsoft.public.sqlserver.programming Size: 1,143 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: recovery mode in microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 2 days, 13 hours ago (2009-11-24 15:36:00)  by Erland Sommarskog
Rich Lawson (nospam@nospam.com) writes: > I have some fields that are being imported with SSIS which are integers. I > have tried to tell SQL 2005 to default to 0, zero, but when it is imported > with SSIS, the blank field becomes NULL. Since I don't know SSIS, I cannot help you, but why are the columns nullable in the first ...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (6 posts) Thread info: 2005 - Integer may not be NULL but is in
microsoft.public.sqlserver.programming Size: 788 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: 2005 - Integer may not be NULL but is in
microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."
microsoft.public.sqlserver.programming
Started 2 days, 10 hours ago (2009-11-24 19:19:00)  by Michael Coles
Here's a query to get you started. It grabs 2 of your vendors for each product with the lowest prices. Note that if the 2nd and 3rd vendors offer the same product for the same price there's no way to guarantee which one will be returned since no business rule is defined for that: SELECT * FROM ( SELECT ROW_NUMBER() OVER (...
Forum:  microsoft.public.sqlserver.programming microsoft.public.sqlserver.programming - forum profile
Thread:  Show this thread (6 posts) Thread info: Need help with Indexed View that shows lowest prices in
microsoft.public.sqlserver.programming Size: 1,231 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Need help with Indexed View that shows lowest prices in
microsoft.public.sqlserver.programming :: microsoft.public.sqlserver.programming :: Discussions in microsoft.public.sqlserver.programm..."