| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | update PendingDiary
SELECT doc, totovrs, totpnds, totovr, SUM(totpnd) AS totpnd
FROM Pendingdiary
GROUP BY doc, totovrs, totpnds,...
jj297
|
05-20-2010 07:58 AM
jj297  | 11 | 279 |
| | | Dear Candidate,
Title: Teradata DBA
Location: Richmond, VA
Duration: 12 Months.
Description:
Maple MRS
|
05-18-2010 12:00 PM
Maple MRS | 0 | 159 |
| | | Dear Experts,
I would like to explicitly prevent SQL Server 2005 from rewriting a
query in my WHERE clause because the rewrite slows things down by...
Emin
|
05-13-2010 05:29 PM
Erland Sommarskog | 8 | 207 |
| | | Hi -
I have questions on deadlock tracing and hope someone can help.
I enabled deadlock trace with dbcc traceon (1222, 1204, -1), and I
want to...
xo
|
05-13-2010 04:16 PM
Erland Sommarskog | 1 | 157 |
 | | Title: Software Developer
Location: Princeton,NJ
Duration: 6+ months
Description:
The candidates filling these Developer positions will be...
Maple MRS
|
05-13-2010 03:06 PM
Maple MRS | 0 | 147 |
| | | Title: SAP ABAP LEAD
Location: Syracuse,NY
Description:
2-3 years of Lead Experience
5-8 years of SAP ABAP
Maple MRS
|
05-13-2010 02:42 PM
Maple MRS | 0 | 138 |
| | | Title: EssBase Architect with OBIEE
Location: Chicago,IL
Description:
EssBase Architect, with OBIEE,
someone who can design EssBase Cubes
Maple MRS
|
05-13-2010 10:31 AM
Maple MRS | 0 | 145 |
| | | Dear candidate,
Title: Senior Business Intelligence consultant
Location: NYC ,NY
Duration: 6 Months.
Description:
Maple MRS
|
05-13-2010 10:16 AM
Maple MRS | 0 | 154 |
| | | Dear Candidate,
Title: Hyperion Planning Developer 9.3/11.3
Location: Chicago, IL
Duration: 6 Months.
Description:
Maple MRS
|
05-12-2010 05:54 PM
Maple MRS | 0 | 137 |
| | | Title: Active directory with Netware exp
Locaion: Richmond,VA
Description:
Looking for somebody with solid experience in the following...
Maple MRS
|
05-12-2010 03:59 PM
Maple MRS | 0 | 144 |
| | | Title: 2 QA Analyst and 1 QA Lead
Location: New york city,NY
Description:
a large finance/banking corporation is currently looking at...
Maple MRS
|
05-12-2010 03:14 PM
Maple MRS | 0 | 143 |
| | | Title: Data / Information Anlyst III
Location: Dallas\plano, TX
Description:
Skills: Teradata, Data analyst
Responsible for the design,...
Maple MRS
|
05-12-2010 10:45 AM
Maple MRS | 0 | 141 |
| | | The evolution of reporting and analytics has seen dramatic changes in
recent years. Starting with static “green bar” reports in the mid-to-
late...
JTP PR
|
05-12-2010 07:08 AM
JTP PR | 0 | 124 |
| | | Hello.
I’m an Oracle transplant to the SQL Server 2008 adjusting and enjoying
many new features but missing some Oracle features I can’t find...
George Lewycky
|
05-05-2010 07:10 PM
George Lewycky | 5 | 172 |
| | | Dear Candidate,
Title: Hyperion Financial Management (HFM)
Location: Jersey city, NJ
Duration: 6 Months.
Description:
Maple MRS
|
05-05-2010 03:08 PM
Maple MRS | 0 | 128 |
| | | I am having trouble executing command line to transfer files via an
SFTP server from a call in T-SQL (version 2005) where putty is the
client...
DennBen
|
05-05-2010 02:52 PM
Dennis | 4 | 163 |
| | | Dear Candidate,
- Client is seeking a Sr. Cognos Developer for the Business
Intelligence Center.
- The Business Intelligence Center (BIC) is...
Maple MRS
|
05-05-2010 10:50 AM
Maple MRS | 0 | 134 |
| | | Yellowfin is set to redefine what BI users and IT Departments will
expect from Business Intelligence vendors
Leading Business Intelligence software...
JTP PR
|
05-04-2010 07:48 AM
JTP PR | 0 | 84 |
| | | Position / Jobs Systems Database Administrator DBA - SQL Scripting - VMWare
- ESX 4.0 TV Network Operations and Traffic Group 75% Database and...
SQL Jobs SQL Database Administrators
|
05-03-2010 06:20 PM
SQL Jobs SQL Database Administrators | 0 | 83 |
| | | Hello again,
unfortunately it doesn't work as expected. SQL CE says, it can't find
column C.Metric
So I think it's time to find another solution....
Benjamin Kalytta
|
05-01-2010 10:29 PM
Plamen Ratchev | 8 | 118 |
| | | <http://www.filcro.com/SQL-Database.html>
· Installing, configuring, troubleshooting and maintaining MS SQL
environments
· Experience working with...
SQL Jobs SQL Database Administrators
|
04-30-2010 09:19 PM
SQL Jobs SQL Database Administrators | 0 | 83 |
| | | Hello,
I had no luck with building an sql query to eliminate all rows except
that with MIN(column - @parameter)
Example Table:
RouterId ...
Benjamin Kalytta
|
04-30-2010 10:34 AM
Benjamin Kalytta | 0 | 67 |
| | | Yellowfin Business Intelligence is offering customers,industry
professionals, developers, OEMS and Vendors a chance to get a walk
through of the new...
JTP PR
|
04-29-2010 08:04 AM
JTP PR | 0 | 94 |
| | | I'm trying to merge to records. All of the fields are the same except
for dbo.MaterialProducedActualEpa.EpaName. I'm able to use a 2nd
field to...
mcolson
|
04-27-2010 05:31 PM
Erland Sommarskog | 1 | 103 |
| | | Yellowfin has released its latest Business Intelligence Whitepaper,
this time on "In-memory Analytics"
* No signup or email handover required, just...
JTP PR
|
04-26-2010 06:57 AM
JTP PR | 0 | 108 |
| | | How would I join these statements together into 1 sql statement? They
all have the same criteria for timestamps, but the locations are
different and...
mcolson
|
04-22-2010 03:31 PM
mcolson | 4 | 136 |
| | | Leading web-based BI provider, Yellowfin, will unveil their milestone
5.0 release in May 2010. This release includes significant
enhancements;...
JTP PR
|
04-22-2010 09:40 AM
JTP PR | 0 | 82 |
| | | Prasad (calmsqurill (AT) gmail (DOT) com) writes:
As far as I can tell, you don't destroy the object, if you connect
successfully.
Is this SQL...
Erland Sommarskog
|
04-22-2010 06:58 AM
Prasad | 4 | 97 |
| | | Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.0...
Martijn Tonies
|
04-22-2010 05:46 AM
Martijn Tonies | 0 | 95 |
| | | This is my data. Salesman is the key. I want to select them and then
change them to another...
Faye
|
04-20-2010 05:00 PM
Faye | 8 | 136 |
| | | hi friends,
can any one help me pl!!
m using visual studio 2005 n ms sql server 2005 as backend.actually, i
have created a table with a column name...
rek
|
04-18-2010 05:34 PM
Erland Sommarskog | 1 | 103 |
| | | There is a good article at ASPFAQ on how to calculate median in a SQL
table....
HumanJHawkins
|
04-18-2010 05:25 PM
Erland Sommarskog | 3 | 99 |
| | | hi there. i need some help with a query please. my table has two
fields:
family_id {identity} - uniqueidentifier
family_name - nvarchar
I have a...
Suraj Shah
|
04-15-2010 05:58 PM
Plamen Ratchev | 1 | 92 |
| | | Dear Experts,
I have a query of the form SELECT * FROM A WHERE X=1 which runs in
under a second and returns about 800 records. But when I add...
Emin
|
04-13-2010 12:19 PM
Plamen Ratchev | 3 | 106 |
| | | Hey everyone, I have a rather unique set of security rules to follow
here and cannot seem to enforce them and keep my SQL Agent jobs
running on the...
Tonagon
|
04-09-2010 03:43 PM
Jack Vamvas | 3 | 151 |
| | | I set up a Precedence Constraint on my SSIS Package. I created this
script:
Public Sub Main()
Dim fi As System.IO.FileInfo
fi = New...
jj297
|
04-07-2010 02:43 PM
jj297 | 1 | 94 |
| | | We have an application uses SQL Server 2005's sqlagent job feature to
runs around 20 jobs which a frequency of every 1, 2, 5, or 10 minutes
depending...
Mark D Powell
|
04-07-2010 09:44 AM
Mark D Powell | 3 | 136 |
| | | I added a script task to my ssis package to check last file modified
in Explorer. Here's the code:
Public Sub Main()
Dim fi As...
JJ297
|
04-06-2010 11:03 AM
JJ297 | 0 | 99 |
| | | We are s/w development company with a number of installations that use
SQL Server. We are looking for a qualified individual who will help...
migurus
|
03-30-2010 05:10 PM
migurus | 0 | 106 |
| | | Quick demo on the power of Location Intelligence to visualise your
data
http://www.youtube.com/watch?v=uhD1NtNdj8E
JTP PR
|
03-30-2010 07:55 AM
JTP PR | 0 | 112 |
| | | You can set Autoshrink by using following system stored procedure.
Exec Sp_dboption 'Tempdb', 'Autoshrink', 'True'
From...
Giri
|
03-27-2010 05:09 AM
Erland Sommarskog | 1 | 127 |
| | | Originally I had 2 tables in my DB, and .
Each employee can have 1 "Home Property" so the employee table has a
HomePropertyID FK field to...
wackyphill@yahoo.com
|
03-18-2010 07:30 PM
wackyphill@yahoo.com | 8 | 170 |
| | | SQL 2005
I have a linked MySQL server. I have written a script which updates
the MySQL server correctly when run from the Management Studio...
Iain Sharp
|
03-17-2010 05:45 PM
Erland Sommarskog | 4 | 119 |
| | | Hello.
I am have trouble getting the above to work. MS IE (Ver 6 SP2) does
not access;
http://localhost/reports/
correctly. I expect to get the...
jc
|
03-16-2010 09:26 AM
jc | 0 | 93 |
| | | Hello,
Does anybody know, MSSQL 2005 T SQL language, are variables or keywords case
sensitive or not?
Regards
m
|
03-13-2010 08:14 AM
--CELKO-- | 9 | 105 |
| | | I have one machine with an application running that many users need to log
in and out of quickly. Logging off the machine, logging in and...
Matthew Wells
|
03-12-2010 08:25 AM
Matthew Wells | 4 | 132 |
| | | We are using SQL Server 2008.
As an administrator on the box (part of the admin group), I assumed I
could use Windows authentication to log into sql...
Justin
|
03-10-2010 03:11 PM
alen teplitsky | 2 | 138 |
| | | I am trying to create a stored procedure to write out to a text file.
I would like it to write a line for each instance of a select
statement. Any...
mcolson
|
03-08-2010 06:03 PM
Erland Sommarskog | 2 | 118 |
| | | Hello
I have an ASP/SQL Server 2008 client management application. An ASP
textarea submits data to a varchar(max) field. In some cases the...
ContainsCaffeine
|
03-08-2010 04:23 PM
ContainsCaffeine | 2 | 119 |
| | | I am not clear why SQL Server eliminates dups from my query below
declare @s table ( id int );
insert into @s (id)
select 1 union
select...
migurus
|
03-03-2010 10:48 PM
Plamen Ratchev | 1 | 221 |
