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... 

Microsoft SQL Server | Forum profile
Forum profile page for Microsoft SQL Server on http://www.dbforums.com. This report page is the aggregated overview from a single forum: Microsoft SQL Server, located on the Message Board at http://www.dbforums.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Microsoft SQL Server" on the Message Board at http://www.dbforums.com is also shown in the following ways:

1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.
Site: dBforums - Database Support Community - Microsoft SQL Server
dBforums - Database Support Community
(site profile, domain info dbforums.com)
Title: Microsoft SQL Server
Url: http://www.dbforums.com/microsoft-sql-server/
Users activity: 31 posts per thread
Forum activity: 94 active threads during last week
 

Posting activity on Microsoft SQL Server:

  Week Month 3 Months
Threads: 94 324 883
Post: 359 1,107 2,736
 

Microsoft SQL Server Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Brett Kaiser
40
user's latest post:
Help me to build this query
Published (2009-11-14 18:34:00)
How many products do you have?
pootle flump
24
user's latest post:
How to hold Database Name in a...
Published (2009-11-12 12:48:00)
You can't do this without dynamic SQL and a loop. I wouldn't use "USE". Instead I would do something like: Code: UPDATE dbo.TotalDatabase SET NoOfTable = (SELECT COUNT(*) FROM [databasename].sys.tables) WHERE DbName = [databasename] That is your base string - use REPLACE to substitute the placeholder ([databasename]) with the actual database name. I wouldn't do this in a cursor - dynamic cursor syntax is a ball...
blindman
24
user's latest post:
Can someone tell me if this...
Published (2009-11-13 22:04:00)
Quote: Originally Posted by Brett Kaiser, 15:50 WAIT TYour calling this from Access? Quote: Originally Posted by blindman, 15:51 Wait. You are doing this through MS Access? You are freakin' me out, man!
gvee
18
user's latest post:
Finding records from control
Published (2009-11-10 19:00:00)
Stuff between single quotes is treated as literal text. I doubt you have a username of "txtusername.text"! Create a sproc and pass txtusername.text as a parameter
mishaalsy
15
user's latest post:
Archiving data - Page 2 - dBforums
Published (2009-11-12 01:27:00)
thank you for your kind concern mr.flump . my likeness for you have greatly blossomed .
Pat Phelan
15
user's latest post:
stored procedure problem
Published (2009-11-14 23:38:00)
Quote the string? -PatP
Wim
12
user's latest post:
Difference between dates in one...
Published (2009-11-13 19:22:00)
Quote: Originally Posted by pootle flump A brief read of this suggests there is a nice solution or two in 2005 and 2008, and a nasty one in 2000. OP - please can you tell us the version of SQL Server? You care to share your solutions?
r937
12
user's latest post:
Convert nested-select into...
Published (2009-11-14 19:47:00)
Quote: Originally Posted by knhcmp Why this did NOT yield x, y, z as in (I) and (II)? i'm guessing it was because of this -- a a b b c c
sullyman
11
user's latest post:
declare the scalar variable
Published (2009-11-11 13:27:00)
Hi Brett, I am using SQL Server 2005, Designing Winform Application through VStudio 2008. I have usernames/passwords in sql table. I have the login part working where the user can login by validating against the username/password stored in the login table but i need to bring back the user's information in a grid view etc. on Form 2 based on their employeeid which is referenced in all other tables. Login Table Username Password Employeeid...
skippy2727
10
user's latest post:
select containing different servers
Published (2009-11-13 03:08:00)
Code: SELECT * FROM [server1].[Items].[dbo].[Properties], [server2].[Items].[SpecialProperties] where Properties.ID=SpecialProperties.ID I am trying to do a select across 2 tables that exist on different servers, that are linked via the network. The above does not work; 1. Should it work like this, i.e have I just made a spelling mistake etc.? 2. ...or am I trying to fit a whale into a mini? Thanks
  

Latest active threads on Microsoft SQL Server::

dBforums - Database Support Community
Started 1 day, 17 hours ago (2009-11-14 18:34:00)  by Brett Kaiser
How many products do you have?
Thread:  Show this thread (3 posts)   Thread info: Help me to build this query Size: 30 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How many products do you have? :: Microsoft SQL Server :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 1 day, 12 hours ago (2009-11-14 23:38:00)  by Pat Phelan
Quote the string? -PatP
Thread:  Show this thread (2 posts)   Thread info: stored procedure problem Size: 40 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Quote the string? -PatP :: Microsoft SQL Server :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 2 days, 16 hours ago (2009-11-13 20:00:00)  by Pat Phelan
What have you covered so far in class? I'd assume by this point in the class session that this would already be "old hat", so I'm having trouble understanding what is confusing you. I'm trying to understand what your problem is so that I can help you learn. Give me a few clues and I can probably help! -PatP
Thread:  Show this thread (7 posts)   Thread info: Convert nested-select into Join's Size: 354 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: What have you covered so far in class? I'd assume by this point in the class session that this... :: Microsoft SQL Server :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 2 days ago (2009-11-14 11:10:00)  by Pat Phelan
Code: UPDATE #TempTotalTable SET NoOfCol = #ColumnPerTable. NoOfCol FROM #ColumnPerTable WHERE #TempTotalTable.TBName = #ColumnPerTable.TBName -PatP
Thread:  Show this thread (7 posts)   Thread info: Update statement get executed but table remains the same Size: 472 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Code: UPDATE #TempTotalTable SET NoOfCol = #ColumnPerTable.NoOfCol FROM #ColumnPerTable WHERE #TempTotalTable.TBName = #ColumnPerTable.TBName -PatP :: Microsoft SQL Server :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 1 week, 4 days ago (2009-11-04 13:24:00)  by PMASchmed
DTS to SSIS ? Unsupported SQL (i.e. old join syntax in where clause vs. ANSI ) "with" in hints etc.
Thread:  Show this thread (10 posts)   Thread info: SQL Upgrade 2000 to 2008 Size: 130 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: DTS to SSIS ? Unsupported SQL (i.e. old join syntax in where clause vs. ANSI ) "with" in hints... :: Microsoft SQL Server :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 2 days, 9 hours ago (2009-11-14 02:22:00)  by tatvasoftseo tatvasoftseo is offline Registered User
in our application that need to create some tables in tempdb. The user (call it APP) is not sa. Everytime that the server need to be rebooted, the db_owner role on tempdb for user APP disappear. So... 1. Is there any setting to ensure that the the db_owner role on tempdb for user APP will remain after server reboot? 2. If not, Is there any solustion to run a script at ...
Thread:  Show this thread (4 posts)   Thread info: role permission of tempdb due to server restart Size: 611 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: role permission of tempdb due to server restart :: Microsoft SQL Server :: dBforums - Database Support Community"
 

Hot threads for last week on Microsoft SQL Server::

Microsoft SQL Server
Started 6 days, 7 hours ago (2009-11-10 04:37:00)  by mishaalsy
"lot of data" then why creating a separate table ? . boolian condition (yes/no) or flag 1/0 is the best method for faster scan .
Thread:  Show this thread (24 posts)   Thread info: Archiving data Size: 170 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: "lot of data" then why creating a separate table ? . boolian condition (yes/no) or flag 1/0 is the... :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 3 days, 3 hours ago (2009-11-13 08:16:00)  by MartinFalch Registered User
Hi there, I have a lot of daily series, with observations on each day. Now I wish to create new tables, containing the same data, but only the last observation of each month. Is there some way to select this ultimo date within SQL, so as to select the 31st when this is the last date, the 30st when this is the last date etc? My code is quite simple, looks like this: ...
Thread:  Show this thread (18 posts)   Thread info: Selecting ultimo dates of a month Size: 716 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Selecting ultimo dates of a month :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 5 days, 7 hours ago (2009-11-11 04:53:00)  by Wim
Can you give the logic behind each and every Diff, like you did for A 18 (24 - 6)? I have no idea where the 6 after 2009-11-06 comes from. Same with most of the Diff's of the B and C groups. What is the Diff when you have two records in a group? Which record gets what value? What is the Diff when you have more than two records in a group? Which record gets what value? What is the Diff of...
Thread:  Show this thread (15 posts)   Thread info: Difference between dates in one column with grouping Size: 1,251 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Can you give the logic behind each and every Diff, like you did for A 18 (24 - 6)?... :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 2 days, 23 hours ago (2009-11-13 12:31:00)  by blindman
How about posting your sql instead? For starters, you should not be using Code: CONVERT(VARCHAR(11), @StartDate, 120) Use Code: dateadd(day, datediff(day, 0, @StartDate), 0) instead (unless your date values are stored as strings, in which case you have a whole other set of problems...).
Thread:  Show this thread (14 posts)   Thread info: Can someone tell me if this execution plan looks ok? Size: 859 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How about posting your sql instead? For starters, you should not be using Code: CONVERT(VARCHAR(11), @StartDate, 120) Use Code:... :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 1 week, 3 days ago (2009-11-06 10:32:00)  by Thrasymachus
common problem. pick your solution... sql server comma separated values to table - Google Search
Thread:  Show this thread (16 posts)   Thread info: Stored Procedure Parameter Size: 269 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: common problem. pick your solution... sql server comma separated values to table - Google Search :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 4 days, 5 hours ago (2009-11-12 06:46:00)  by AndyH2009 Registered User
Hi All... I'm in the process of migrating my Access DB to MS SQL. Now i'm at the point of testing my Classic ASP Application code and have come accross a problem pointing to 'datediff'. Here is my Statement and the error. Can anyone advise please? -------code-------- SELECT a.*, b.FirstName+' '+b.LastName AS FullName, c.OrderStatus FROM (Orders AS a INNER JOIN Customers AS b ON a....
Thread:  Show this thread (10 posts)   Thread info: SQL Statement Help Please Size: 1,058 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQL Statement Help Please :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 2 days, 22 hours ago (2009-11-13 13:24:00)  by asyed01 asyed01 is offline Registered User
Hello experts, I’m trying to insert some values though stored procedure into one of my temporary table but having the following errors again and again. Msg 8152, Level 16, State 2, Line 1 String or binary data would be truncated. The statement has been terminated. Msg 8152, Level 16, State 2, Line 1 String or binary data would be truncated. The statement has been terminated....
Thread:  Show this thread (10 posts)   Thread info: Minor Error During Insert Size: 2,303 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Minor Error During Insert :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 2 days, 22 hours ago (2009-11-13 13:59:00)  by blindman
I lack the patience for guessing games today. Post some actual code, please.
Thread:  Show this thread (10 posts)   Thread info: Subqueries Size: 77 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: I lack the patience for guessing games today. Post some actual code, please. :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 6 days, 22 hours ago (2009-11-09 13:14:00)  by pootle flump
I can explain why 1 and 2 differ from 3 since they are semantically different. I can't explain why 1 and 2 differ. A clue as to how they differ would have been nice but too much to ask I suppose.
Thread:  Show this thread (9 posts)   Thread info: Coalesce Vs IsNull query plan Size: 210 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: I can explain why 1 and 2 differ from 3 since they are semantically different. I can't explain why... :: Microsoft SQL Server :: dBforums - Database Support Community"
Microsoft SQL Server
Started 6 days, 21 hours ago (2009-11-09 14:40:00)  by Brett Kaiser
got ddl? post that please
Thread:  Show this thread (8 posts)   Thread info: where condition oddity SQL 2000 Size: 42 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: got ddl? post that please :: Microsoft SQL Server :: dBforums - Database Support Community"