Viewing 15 posts - 2,311 through 2,325 (of 15,381 total)
mike 57299 (9/15/2015)
Here is the setup...
Standard Order header / Order detail records (1-m). Each order detail has a product id, order detail and ship detail.
Product info is...
September 15, 2015 at 1:08 pm
lmarkum (9/15/2015)
September 15, 2015 at 1:05 pm
squvi.87 (9/15/2015)
This new set of data is not the same as the one you posted earlier. Is this giving you the correct results? If not, what should they be from...
September 15, 2015 at 12:40 pm
sgmunson (9/15/2015)
Sean Lange (9/15/2015)
sgmunson (9/15/2015)
September 15, 2015 at 12:39 pm
sgmunson (9/15/2015)
Lowell (9/15/2015)
i know that once a user type is in use, to change it,...
September 15, 2015 at 12:38 pm
Here is an excellent place to start. http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/%5B/url%5D
September 15, 2015 at 11:08 am
sgmunson (9/15/2015)
September 15, 2015 at 11:07 am
freyes (9/15/2015)
column as alias, alias=column and column alias.
The other variants are diferent ways to write the alias...
September 15, 2015 at 9:56 am
elmnas (9/15/2015)
I am total new to SQL server query programming.
I need to gather information by writing a own query to our SQL server,
I using LinQpad 4,
But I have less...
September 15, 2015 at 7:52 am
squvi.87 (9/15/2015)
So you can reference it by either substream1 or substream2? Regardless this is pretty much a typical recursive cte. There are thousands and thousands of examples of how...
September 15, 2015 at 7:27 am
_simon_ (9/14/2015)
if exists update ... else insert ...... September 15, 2015 at 7:21 am
mw112009 (9/14/2015)
Select A.name, B.name
FROM
SYS.tables A
inner join
SYS.columns B on ( A.object_id = B.object_id )
ORDER BY 1 , 2
What I need is a 3rd column which...
September 14, 2015 at 12:54 pm
mar.ko (9/14/2015)
One to define the table via string, the other to call a function to convert it...
September 14, 2015 at 12:17 pm
mar.ko (9/14/2015)
However, I don't agree that using comma-delimited lists violates any rules of relation theory.A list is a list....whether it's in table form or a string.
BWAHAA!!! No offense but that...
September 14, 2015 at 11:04 am
mw112009 (9/14/2015)
Can you put together a SQL statement and using the variable please ?
uummm....
select ORIGINAL_LOGIN()
You could try reading Books Online (BOL), the manual that comes with sql server. It is...
September 14, 2015 at 10:38 am
Viewing 15 posts - 2,311 through 2,325 (of 15,381 total)