Viewing 15 posts - 4,576 through 4,590 (of 15,381 total)
SQLRNNR (6/5/2014)
Luis Cazares (6/5/2014)
TomThomson (6/5/2014)
Luis Cazares (6/5/2014)
Koen Verbeeck (6/5/2014)
SQL is delicious (6/5/2014)
June 5, 2014 at 2:39 pm
vasuarjula (6/5/2014)
June 5, 2014 at 1:56 pm
ps_vbdev (6/5/2014)
our products can be listed on our website as Live or Draft status.
Live product are...
June 5, 2014 at 1:34 pm
This looks a lot like the question from yesterday. http://www.sqlservercentral.com/Forums/Topic1577193-3077-1.aspx
We are however starting to see some details about what you want to do. Perhaps if you can post the tables...
June 5, 2014 at 1:32 pm
centerman99 (6/5/2014)
Sorry about that it was real a Noob thing to do 🙂
No biggie. I would however suggest you actually do read that article. What we would like to see...
June 5, 2014 at 1:24 pm
If you can tell us the entire story of what you want we don't have to keep coming back with more questions. So far we know you want a 7...
June 5, 2014 at 1:02 pm
The Dixie Flatline (6/5/2014)
Grant Fritchey (6/5/2014)
Sean Lange (6/5/2014)
http://www.sqlusa.com/bestpractices/%5B/url%5D
Don't worry there is soap for your eyes. Then if you read some of the content...
June 5, 2014 at 12:59 pm
samita1123-956737 (6/5/2014)
How to generate a seven digit number randomly in sql server 2008
This is a bit vague. We can show you how to generate a 7 digit number but I...
June 5, 2014 at 12:52 pm
SQL Guy 1 (6/5/2014)
SELECT FLOOR(RAND() * 10000000)
That will also return 6 digit values.
June 5, 2014 at 12:51 pm
Hi and welcome to the forums. In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form...
June 5, 2014 at 12:45 pm
I am just going to leave this here...
http://www.sqlusa.com/bestpractices/%5B/url%5D
Don't worry there is soap for your eyes. Then if you read some of the content you may want to find a shotgun...
June 5, 2014 at 12:42 pm
SQLRNNR (6/5/2014)
Sean Lange (6/5/2014)
Ed Wagner (6/5/2014)
crookj (6/5/2014)
Ed Wagner (6/5/2014)
JAZZ Master (6/5/2014)
SQLRNNR (6/5/2014)
trotsalotSir Barton (First US Triple Crown winner 1919)
Browning
shotgun
Sporting Clays
PULL
boom
shakalaka
June 5, 2014 at 12:31 pm
djj (6/5/2014)
Sean, I got to the your second t-sql and decided something was missing, as you need to associate a person with a course. 🙂
Agreed. Something is missing...the junction table...
June 5, 2014 at 12:30 pm
Ed Wagner (6/5/2014)
crookj (6/5/2014)
Ed Wagner (6/5/2014)
JAZZ Master (6/5/2014)
SQLRNNR (6/5/2014)
trotsalotSir Barton (First US Triple Crown winner 1919)
Browning
shotgun
Sporting Clays
PULL
June 5, 2014 at 12:19 pm
djj (6/5/2014)
You need to associate course to the person.
How would we know??? We can't see your screen and have no idea what your data structures are like. I would think...
June 5, 2014 at 12:19 pm
Viewing 15 posts - 4,576 through 4,590 (of 15,381 total)