Eugene Elutin

Forum Replies Created

Viewing 15 posts - 1,621 through 1,635 (of 2,894 total)

RE: insert 100 rows without using loop or union etc.,

I asked one candidate "what do you think are the 5 most important things to remember when working with SQL server?"
Sorry, I hate such questions. They are generic and very...

May 8, 2012 at 9:42 am

#1484617
RE: Need help with SQL statement using COUNT function

michael vessey (5/8/2012)
mldardy (5/8/2012)
Well I tried something a little different with the difference formula and I get a 'Divide by zero error encountered'. This is on the bolded line below
SELECT...

May 8, 2012 at 9:32 am

#1484602
RE: Query Performance issue.

ggjjbb1983 (5/8/2012)
Thanks.
Can you tell me how Full Text Indexes are stored please? I know how clustered indexes are stored. How are Full Text Indexes stored in comparison?
Thanks
That will let...

May 8, 2012 at 9:27 am

#1484597
RE: insert 100 rows without using loop or union etc.,

Jeff Moden (5/8/2012)
michael vessey (5/8/2012)
i see my humour is lost on you jeff
Nah... I had a smiley face there. 🙂 I just didn't want a newbie reading that to...

May 8, 2012 at 9:13 am

#1484590
RE: Dynamic Joins

lanky_doodle (5/8/2012)
Any thoughts guys?
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Not everyone here have a desire to setup everything from scratch. If you could follow tips from the above link, you will get more relevant help in...

May 8, 2012 at 9:06 am

#1484585
RE: Need help with SQL statement using COUNT function

mldardy (5/8/2012)
I am using a Select statement where I get the difference between two columns (ForecastQtyContainers and LastYearQtyActualContainers). I'm able to get that fine but I want take the Difference...

May 8, 2012 at 8:59 am

#1484577
RE: How to use table column values as such for calculations?

It's possible with use of dynamic SQL
BUT! It's a crazy desire!
p.s. you can draw using T-SQL too...

May 8, 2012 at 8:05 am

#1484525
RE: case statement

The best what you can do is:
;with r1 as (select ROW_NUMBER() over (order by field2) rn, field2
...

May 8, 2012 at 7:53 am

#1484519
RE: case statement

michaelyarbrough1975 (5/8/2012)
When I run the query in sql server management studio I need it to return 3 columns (type1, type2, type3) with 3 records each.
column type1 has the following...

May 8, 2012 at 7:37 am

#1484511
RE: how to separate value columns my matching two flag

imex (5/4/2012)
Hi,
Try:
select
s.FLAG1 as INBOUND,
s.AMOUNT as BASE_AMOUNT,
Coalesce( (select i.AMOUNT from @Sample as i
...

May 4, 2012 at 6:20 am

#1483487
RE: Issue with duplicate data

Good Luck!

May 4, 2012 at 5:55 am

#1483478
RE: how to separate value columns my matching two flag

yingchai (5/4/2012)
Hi Eugene,
There is really no rule to make 'aaa' to be only "inbound" but 'bbb' and 'ccc' only "outbound.
If there is an amount for 'aaa' to 'bbb' (FLAG1 to...

May 4, 2012 at 5:52 am

#1483474
RE: Write all the records of a table to a text file on the local disk with in T-SQL (SP)

BCP: still needs tursted connection, we have many 100s of customer with different authendication, the solution has to work in all situations.
And, you will want that file be created on...

May 4, 2012 at 3:49 am

#1483443
RE: how to separate value columns my matching two flag

What makes 'aaa' to be only "inbound" but 'bbb' and 'ccc' only "outbound"?
You should have some kind of flag/rule.

May 4, 2012 at 3:32 am

#1483437
RE: insert 100 rows without using loop or union etc.,

Jeff Moden (5/3/2012)
michael vessey (5/2/2012)
does the following count as a loop?
INSERT INTO dbo.yourTable default values
go 100
??:-P??
BWAAAA-HAAAA!!!!! Ask that question on the receiving end of an interview and see what...

May 4, 2012 at 3:27 am

#1483435

Viewing 15 posts - 1,621 through 1,635 (of 2,894 total)