Viewing 15 posts - 346 through 360 (of 2,894 total)
Jeff Moden (6/6/2013)[/b
...it would be a real pleasure if someone actually did it right, for a change...
Why not open the competition here for most generic FizzBuzz implementation (without dynamic SQL).
I...
June 7, 2013 at 8:10 am
Hi and welcome to the forum.
It's possible, but in order to assist we need a bit more details about your chelenge.
Please provide DDL of tables invloved and some test data...
June 7, 2013 at 7:45 am
You can do it in few ways.
Create vb or javascript which will connect to database, execute your procedure and output its results into existing Excel document or you can write...
June 6, 2013 at 2:58 am
Yep you can, something like
SELECT ... all you need columns ...
,CASE WHEN [condition] THEN 'Red' ELSE 'Black' END as RowColour
FROM...
May 31, 2013 at 10:40 am
You cannot change the "colour" of records in T-SQL. It's up to UI application to format and display results of the query.
May 31, 2013 at 10:35 am
can you see these values in SSIS when configuring data source?
May 31, 2013 at 10:33 am
no need to escape double quote, try passing this:
N'<?xml version="1.0" encoding="utf-16"?><IDLIST><ID VALUE="d4c810ba-36ea-4872-84d0-8c4cfe956e3c" /><ID VALUE="62d6159f-809f-4b5e-9071-8058f47e57fc" /></IDLIST>'
May 31, 2013 at 10:01 am
thbaig1 (5/31/2013)
yes, but I have to add some other conditions and they worked with your logic 🙂I would thank you both for valuable suggestions
If it's not a secret, what kind...
May 31, 2013 at 8:33 am
Is there any formula in this column?
May 31, 2013 at 7:49 am
Formatting has nothing to do with your problem. Most likely you defined a wrong range.
You can try SSIS for getting date from Excel to SQL. Using SSIS, you will see...
May 31, 2013 at 6:35 am
Simple aggregate will do the same:
select Attribute, MIN(StateVal) AS StateVal
from #tblA
group by Attribute
May 31, 2013 at 5:00 am
Luis Cazares (5/30/2013)
Michael Valentine Jones (5/30/2013)
Luis Cazares (5/30/2013)
GilaMonster (5/28/2013)
WangcChiKaBastar (5/28/2013)
our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).
Use one of the...
May 30, 2013 at 10:51 am
Michael Valentine Jones (5/30/2013)
Luis Cazares (5/30/2013)
GilaMonster (5/28/2013)
WangcChiKaBastar (5/28/2013)
our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).
Use one of the snapshot isolation...
May 30, 2013 at 10:15 am
WangcChiKaBastar (5/30/2013)
When I run the Scalar Valued function
select dbo.f_ScalarFunction (@Param1, @Param2, @Param3) and check Inlude Actual execution plan..
I...
May 30, 2013 at 10:06 am
Luis Cazares (5/30/2013)
Eugene Elutin (5/30/2013)
Luis Cazares (5/30/2013)
GilaMonster (5/28/2013)
WangcChiKaBastar (5/28/2013)
our database is not financial, our use of NOLOCK hint was to increase concurrency and limit contention (deadlock).
Use one of the snapshot...
May 30, 2013 at 9:56 am
Viewing 15 posts - 346 through 360 (of 2,894 total)