Viewing 15 posts - 7,411 through 7,425 (of 18,926 total)
SELECT SUM(DATELENGTH(ColName)) As Bytes FROM dbo.table
December 21, 2010 at 10:11 am
I only see this error when the server is restarted or someone / something killed my connection.
December 21, 2010 at 10:11 am
sqlchanakya (12/21/2010)
December 21, 2010 at 10:05 am
Just to be the devils advocate...
1 - this is a local temp table. So only this connection is going to read from it which eliminates joining another active read...
December 21, 2010 at 9:50 am
Actually yes, forget SQL for 2 seconds and write the pseudo code with simple ifs.
I think your problem is that you can't express the business rule, not that you don't...
December 21, 2010 at 9:20 am
No, that's the solution I had to come up with.
Make an asp .net report project, compile to dll and only deploy the dll.
As for performance I think I get that...
December 21, 2010 at 9:15 am
want to see a really long query????
Just one last question. Are all those dashes (-) part of formatting for this message or is it part of the data?
Maybe something...
December 21, 2010 at 8:53 am
Look up charindex, left and substring in books online.
December 21, 2010 at 8:47 am
Luke L (12/21/2010)
December 21, 2010 at 8:47 am
Happy hunting ;-).
December 21, 2010 at 8:34 am
pwalter83 (12/21/2010)
Okay guys, No worries..thanks for your suggestions...I guess I have to go about it on my own..
No need to.
What you need to do is make us understand what...
December 21, 2010 at 8:25 am
Reo (12/21/2010)
what does mean by "You owe me 5.95$" Please make clear.
I was just joking. That's the price of the subscription for the article you cannot read.
But I...
December 21, 2010 at 8:22 am
gissah (12/21/2010)
Thanks all for your cordial advice i will be even willing to work 2 weeks for free
That looks desperate.
I would go with let me work with you for free...
December 21, 2010 at 8:19 am
SELECT
Whatever
FROM
dbo.tbl
WHERE
1 = CASE WHEN Col LIKE '%your string here%' THEN 1
...
December 21, 2010 at 8:17 am
I seriously don't understand why you cannot simply do
SELECT * FROM Tbl
where [Region/trade] = 'EURO MED'
Then join to other tables if you're missing data.
December 21, 2010 at 8:00 am
Viewing 15 posts - 7,411 through 7,425 (of 18,926 total)