Viewing 15 posts - 14,296 through 14,310 (of 26,486 total)
For a test server (non production) you can purchase the Developer Edition for about $50.
If the testers are not changing anything in the database, just running the application to ensure...
October 7, 2011 at 11:06 am
Should be doable, but not until I get home.
Could you put together a test suite, table(s), sample data, expected results?
Should be able to do this in SQL, looks like something...
October 7, 2011 at 11:04 am
In the property pages for the databases, what is shown for the paths to the database files?
October 7, 2011 at 9:55 am
Sean Lange (10/7/2011)
paul.t.silvey (10/6/2011)
October 7, 2011 at 9:34 am
drew.allen (10/6/2011)
You can't do an index seek on cssdt_date until you know the values for wrkcpl_date. You can't...
October 6, 2011 at 3:11 pm
The key to your problem is the spaces in the database name. You need to surround the name with [], just like you would with column names that contain...
October 6, 2011 at 3:08 pm
Patti Johnson (10/6/2011)
Hey Lynn, while I gotcha. What does quotename do?
Would you get mad if I asked you to look it up in BOL?
October 6, 2011 at 3:04 pm
Based on the sample data what is your expected results and what are the criteria?
October 6, 2011 at 2:51 pm
Tried this?
SET @strSQL = 'ALTER DATABASE ' + quotename(@strDatabaseName) + ' SET SAFETY OFF'
October 6, 2011 at 2:50 pm
Finding more people dealing with Oracle data in one form or another. I'm walking away before I have an episode of some sort.
October 6, 2011 at 2:46 pm
If you have indexes on the columns in the where clause, this might be faster:
select a1, clsdt_date,wrkcpl_date
FROM wt
WHERE
clsdt_date = wrkcpl_date
UNION ALL
select a1, clsdt_date,wrkcpl_date
FROM wt
WHERE
...
October 6, 2011 at 2:36 pm
Stefan Krzywicki (10/6/2011)
Lynn Pettis (10/6/2011)
Based on that, it could simply be someone not familiar with T-SQL porting Oracle code and not...
October 6, 2011 at 2:29 pm
Yes, Oracle does, and thankfully I'm forgetting Oracle rather quickly.
Based on that, it could simply be someone not familiar with T-SQL porting Oracle code and not recognizing what could be...
October 6, 2011 at 2:18 pm
Didn't know SSRS used money to store data. Interesting. The word you wanted is cache.
Other than that, can't help as I'm not familiar with SSRS (yet).
October 6, 2011 at 2:13 pm
GilaMonster (10/6/2011)
Lynn Pettis (10/6/2011)
Did some testing and it looks like you do want to ANDs in the NOT EXISTS statement.Okay, boolean logic doesn't always work as you think in T-SQL.
Boolean...
October 6, 2011 at 2:01 pm
Viewing 15 posts - 14,296 through 14,310 (of 26,486 total)