|
More site info...
microsoft.public.sqlserver.programming | Forum profile
|
|
Forum profile page for microsoft.public.sqlserver.programming on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.sqlserver.programming, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
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.public.sqlserver.programming" on the Message Board at http://www.microsoft.com/communities/newsgroups... 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.
|
|
|
|
|
Posting activity on microsoft.public.sqlserver.programming:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
131
|
358
|
1,207
|
|
Post:
|
406
|
1,065
|
3,581
|
|
|
microsoft.public.sqlserver.programming Posting activity graph:
|
Top authors during last week:
user's latest post:
I need help with Trigger Syntax...
Published (2009-01-08 00:45:00)
Alex Kuznetsov (alkuzo@gmail.com) writes: > On Jan 7, 5:19pm, Erland Sommarskog <esq...@sommarskog.se> wrote: >> Oops, trigger no longer working! Test? Why on Earth should one test the >> introduction of a standard error handler? Which might even be added on >> broad scale with some change-replace tool? > > Why? Just because I have unit tests executing...
user's latest post:
YTD through last friday in...
Published (2009-01-07 20:44:00)
You can use WHERE predicates like this: WHERE date_column >= DATEADD(YEAR, DATEDIFF(YEAR, '19000101', CURRENT_TIMESTAMP), '19000101') AND date_column < DATEADD(DAY, (DATEDIFF (DAY, '19000105', CURRENT_TIMESTAMP) / 7) * 7, '19000105') The first filter defines dates greater than or equal to the first of the year (the 1/1/1900 date is used just as reference date for calculations),...
user's latest post:
constrain a 2 char column to...
Published (2009-01-07 13:54:00)
But this will work if you use integers in the check constraint instead of varchars create table bla (col CHAR(2) NOT NULL CONSTRAINT ck_digits2 CHECK (col between 0 and 99) ) --fine insert bla values ('01') insert bla values ('99') insert bla values ('') insert bla values (' ') --these all fail insert bla values ('1a') insert bla values ('B') select * from bla Denis The...
user's latest post:
Numbering the rows in a dataset...
Published (2009-01-06 15:33:00)
>> To CELKO - I agree that there is some sloppiness on my part here but most of what you were talking about has nothing to do with me. The source tables I am using are from an accounting system that was originally written over 15 years ago so it seems they weren't following "best practices" at the time. Even though this system is still updated, they would not risk changing table names or fields...
Aaron Bertrand [SQL Server MVP]
14
user's latest post:
YTD through last friday in...
Published (2009-01-07 20:40:00)
DECLARE @now SMALLDATETIME, @fFri SMALLDATETIME, @fdty SMALLDATETIME, @lastFriday SMALLDATETIME; SELECT @now = DATEDIFF(DAY, 0, CURRENT_TIMESTAMP) + 1, @fFri = '20090102', -- pick ANY Friday in the past @fdty = DATEADD(YEAR, DATEDIFF(YEAR, 0, @now), 0), @lastFriday = @fFri + (7*(DATEDIFF (DAY, @fFri, @now)/7)); SELECT [datetime_column] FROM dbo.[table] WHERE [datetime_column] >= @fdty AND [datetime_column] <...
user's latest post:
Problem inserting rows with...
Published (2009-01-07 14:30:00)
OK. Now it is working! Thanks for the help. Maybe I edited the constraint incorrectly when I added it. "SQL Menace" wrote: > Did you try the code in my first reply? It works for me > > Here it is again > > create table #bla([myCol] char(2)not null > CONSTRAINT ck_digits > check ([myCol] like '[0-9][0-9]' or [myCol] = '') ) > >...
user's latest post:
Slow opening a table and query...
Published (2009-01-07 15:06:00)
On Wed, 7 Jan 2009 14:45:30 -0800, Pelican wrote: >Hugo, > Thanks for your reply. > There is no clustered index for this table. This temp table takes in data >from a text file every 30 minutes by a SQL SSIS package (run by a SQL Server >Agent job scheduler) . That is why I am keeping the table there instead of >creating it inside the query each time. > There must be a way to remove...
user's latest post:
Importing list of registered...
Published (2009-01-07 22:45:00)
Abba http://msdn.microsoft.com/en-us/library/ms190711.aspx "Abba" <SQL_Help@aaa.com> wrote in message news:%23$Fv3SVcJHA.1336@TK2MSFTNGP02.phx.gbl... > Hello, > > Has anyone tried to import the list of registered servers from a SQL2005 > machine to a SQL2008? I am getting a xml node error. Also tried this > article, but it didnt work. > > TIA, >...
user's latest post:
Search for a value in any table...
Published (2009-01-07 07:19:00)
I have had similar requests in the past. One of the approaches I have taken is to use Profiler to view what is happening in the application when certain requests are made. This is useful if the business are looking for reports based on what they see in the front end. It is especially useful if you have one of those applications I have come across where they don't use the database for much besides storage, so you have no...
user's latest post:
I need help with Trigger Syntax...
Published (2009-01-07 17:58:00)
On Jan 7, 5:19pm, Erland Sommarskog <esq...@sommarskog.se> wrote: > Oops, trigger no longer working! Test? Why on Earth should one test the > introduction of a standard error handler? Which might even be added on > broad scale with some change-replace tool? Why? Just because I have unit tests executing every single piece of T- SQl, including triggers, and because in my system they run...
|
|
|
|
Latest active threads on microsoft.public.sqlserver.programming::
Started 1 day, 11 hours ago (2009-01-07 14:18:00)
by Ian Boyd
Consider the results set: Thickness DropHeight ======= ======= 1.75 0 1.75 6 1.75 7 2.00 7 2.00 8 4.50 0 i want to eliminate rows which a DropHeight of zero, ONLY if there are other rows for the same Thickness. Desired output: Thickness...
Started 1 day, 11 hours ago (2009-01-07 14:38:00)
by jwallison
Help??!! What is the "source" of the MvID returned by ASSEMBLYPROPERTY(<assemblyName>, 'MvID') ? Put another way, the MvID returned by ASSEMBLYPROPERTY definitely appears to NOT be the MVID as described by Assembly.ManifestModule.ModuleVersionId as confirmed using ilDASM, so, it comes from... ????...
Started 1 day, 10 hours ago (2009-01-07 15:41:00)
by DBA
I have a primary server that I log ship transactions to on a secondary server. Can we update and tables views etc to the db on the secondary server?
Started 3 days, 17 hours ago (2009-01-05 08:20:00)
by Al
I have a table called “tblTracking” which has the following fields: TrkID ( Primary Key), DateSent, Comments I have another table called “tblFollowup” with the following fields: FlupID (Primary Key), TrkID (Foreign Key), FollowUp_Date, Comments I am trying to accomplish the following through a Trigger: 1) ...
Started 1 day, 1 hour ago (2009-01-08 00:37:00)
by wholesalegb@163.com
discount Air max 95 shoeswww.gotoorder.cn wholesale Air Max 87 shoes discount Air MAX LTD shoes sell Air max 90 shoes discount Air Max 88 shoeswww.gotoorder.cn discount Air MAX 89 shoes discount Air max tn shoes discount Air Max tn8 shoes discount Air MAX tn9 shoeswww.gotoorder.cn discount MEN'S WOMEN'S Shox R5 ...
Started 1 day, 9 hours ago (2009-01-07 15:50:00)
by c_shah
is there any alternavite of XP_CMDShell in SQL 2005 or up? for running OS command or executables. It is disabled and can be enabled through surface area configuration tool (I understand that for security reasons) Just curious that may be there is a new feature or way to do it....
Started 1 day, 15 hours ago (2009-01-07 10:48:00)
by Raj
We are presently using SQL DMO with SQLServer2000 & SQLServer2005 in our VB6 application. We are planning to migrate to SQL2008. It looks like SQLDMO is not supported in SQLServer2008. So, what is the best way to use our existing SQLDMO with the new SQLSMO?
Started 1 day, 3 hours ago (2009-01-07 21:51:00)
by Abba
Hello, Has anyone tried to import the list of registered servers from a SQL2005 machine to a SQL2008? I am getting a xml node error. Also tried this article, but it didnt work. TIA, Abba
Started 1 day, 5 hours ago (2009-01-07 19:54:00)
by Middletree
I'm trying to do a weekly report where it will total the number of rows of this year through last Friday, no matter what day of the week I am pulling the report. Can someone direct me?
Started 1 day, 15 hours ago (2009-01-07 10:10:00)
by NAVIN.D
<HiringForecast> <HForeCast> <HForeCast ID="1"> 1 68 <FTE>2</FTE> <CTR>2</CTR> </HForeCast> <HForeCast ID="2"> <HForeCast>2</HForeCast> <Month /> <FTE /> <CTR /> </HForeCast> <...
|
|
Hot threads for last week on microsoft.public.sqlserver.programming::
Started 3 days, 17 hours ago (2009-01-05 08:20:00)
by Al
I have a table called “tblTracking” which has the following fields: TrkID ( Primary Key), DateSent, Comments I have another table called “tblFollowup” with the following fields: FlupID (Primary Key), TrkID (Foreign Key), FollowUp_Date, Comments I am trying to accomplish the following through a Trigger: 1) ...
Started 1 day, 16 hours ago (2009-01-07 09:37:00)
by Rich
Using Sql Server 2000 - how can I constrain a char column char(2) to only allow digit characters (0 thru 9) without having to say col = '00' or col = '01' or col = '02' or ... col = '10' or col = '11' or ... as this would have too many combinations? Isn't there some kind of Regex function - how to implement? ...
Started 2 days, 1 hour ago (2009-01-07 00:23:00)
by unknown
Started 2 days, 19 hours ago (2009-01-06 06:01:00)
by Keith G Hicks
I have a relatively complicated value I need in a separate column. RIght now, it's value is figured out in a trigger and stored there because that's what the previous programmer did. But I'm thinking it would be better to do this as a computed column. I tried it out as computed and it seems like this would be faster. And of course it ...
| |