Viewing 15 posts - 3,076 through 3,090 (of 15,381 total)
sunitkrishna (4/6/2015)
Hi..Is there a way to hide all those columns with all zero values(zero value for all rows) in a dynamic pivot query?
Sunitha
Sure with a WHERE predicate? Or maybe a...
April 6, 2015 at 7:02 am
Eirikur Eiriksson (4/3/2015)
Further on Sean's answer, seriously suggest you look into some database design patterns, what you got there is just awful😎
Oye!!! I didn't even actually look at the table...
April 3, 2015 at 2:06 pm
Holy cow. Why so many varchar max columns? You need to use appropriately sized columns. You are never going to exceed 8,000 characters for ANY of those columns.
Here is where...
April 3, 2015 at 1:10 pm
SqlSanctum (4/3/2015)
Brandie Tarvin (4/3/2015)
Don't you just love it when you go to post a question to the forums (after banking your head against a wall for several hours / days)...
April 3, 2015 at 9:30 am
Brandie Tarvin (4/3/2015)
Don't you just love it when you go to post a question to the forums (after banking your head against a wall for several hours / days) and...
April 3, 2015 at 9:29 am
Tac11 (4/3/2015)
April 3, 2015 at 9:25 am
Tac11 (4/3/2015)
I want to get results of 'adventureworks' database But I want those results inserted into 'size' table in 'mydatabase'.
I already have created a table 'size' with 3 columns...
April 3, 2015 at 9:07 am
What is the question here?
Here is your query formatted so we can read it.
-- Taken from sp_spaceused:
SELECT database_name = Db_name()
, database_size =...
April 3, 2015 at 8:45 am
Brandie Tarvin (4/3/2015)
Koen Verbeeck (4/3/2015)
SqlSanctum (4/3/2015)
April 3, 2015 at 8:30 am
Koen Verbeeck (4/3/2015)
SqlSanctum (4/3/2015)
April 3, 2015 at 8:25 am
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
Grant Fritchey (4/3/2015)
Sean Lange (4/3/2015)
Grant Fritchey (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
OK. Funny, very funny, but a little uncool.
I found it a rather fitting response...
April 3, 2015 at 7:54 am
Or take a look at the two links in my signature about cross tabs. This is another way to do the same thing.
April 3, 2015 at 7:45 am
sqlquery29 (3/25/2015)
I need to use some conditional query :
Scenario is:
I have a customer table(customer_number is Primary key) and Contact table , i need to join these to get customer...
April 3, 2015 at 7:44 am
tomsharp85 (4/3/2015)
Did you mean from information schema columns?
No that is what they meant. You need to provide DDL (create table statements) and some sample data (insert statements). Without knowing...
April 3, 2015 at 7:39 am
Grant Fritchey (4/3/2015)
Sean Lange (4/3/2015)
Grant Fritchey (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
OK. Funny, very funny, but a little uncool.
I found it a rather fitting response to somebody who clearly...
April 3, 2015 at 7:35 am
Viewing 15 posts - 3,076 through 3,090 (of 15,381 total)