Viewing 15 posts - 136 through 150 (of 1,183 total)
Does ID_old need to hold the previous ID's value after migration?
And the foreign key is ...
BirdsCensusSpeciesInfroM.BirdsSiteInfro_ID ties to BirdsSiteInfroM.ID
And I assume you'll be able to do this when there is...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 27, 2012 at 8:37 am
Right click on the tables and select SCRIPT TABLE AS > CREATE > New Query window. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 27, 2012 at 8:08 am
Jason Selburg (1/25/2012)
Jumping in because I want to know too. 😀Statistics?
I must admit, I only just now "re-found" the Subscribe To Topic under Topic Options. Man it's been a long...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 26, 2012 at 5:37 pm
ORDER BY
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 26, 2012 at 4:53 pm
Post some DDL (Data Definition Language) a.k.a CREATE TABLE scripts of the source and target tables please.
I have some code handy that will help. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 26, 2012 at 4:15 pm
I was taking the approach that if the OP had to type out the requirements, that it might help them see the error in their ways. :-/
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 26, 2012 at 6:29 am
SQL Kiwi (1/25/2012)
DougG (1/25/2012)
I am having trouble getting this update correct:
Whoa! This is a stop-and-start-again situation I am afraid. The code looks like it is based on some...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 25, 2012 at 7:19 pm
kirkdm01 (1/25/2012)
I tried you're second approach and i get no results if i put in 13, 12 or 1
Read the article referenced in my signature please.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 25, 2012 at 5:24 pm
kirkdm01 (1/25/2012)
Will that select 1 and 12 where the parameter could just be 1 because i just would like it to select 1
OOPS!
SELECT ID, AddedBy, Title, Path_String
FROM MyTable
WHERE...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 25, 2012 at 5:14 pm
SELECT ID, AddedBy, Title, Path_String
FROM MyTable
WHERE
Path_String Like @Paramter + '%'
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 25, 2012 at 5:06 pm
Jumping in because I want to know too. 😀
Statistics?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 25, 2012 at 5:01 pm
I assume the report actually renders fine, but doesn't return the expected results.
Have you ran profiler? 😛
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 25, 2012 at 4:54 pm
Some DDL and sample data would help. 🙂
EDIT: And what are your expected results?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 25, 2012 at 4:31 pm
So what time is 1065 ?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 24, 2012 at 2:00 pm
DECLARE @times TABLE
(timeValue VARCHAR(5))
INSERT @times (timeValue)
SELECT '745'
UNION ALL SELECT '1115'
UNION ALL SELECT '330'
SELECT CONVERT(DATETIME, '1/1/1900 '...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJanuary 24, 2012 at 1:36 pm
Viewing 15 posts - 136 through 150 (of 1,183 total)