Eugene Elutin

Forum Replies Created

Viewing 15 posts - 1,501 through 1,515 (of 2,894 total)

RE: Select Related Fields Data Issue

Right now your query returns:
COMPANYCATKWcntcmpcntcatcntkw
PIZZA HUTPIZZAPIZZA555
PIZZA HUTPIZZAPIZZAggg555
PIZZA HUT ADPIZZA ABCPIZZA555
PIZZA HUT PKPIZZA INDOPIZZA555
PIZZA HUT SINGAPORE PTDLTDPIZZAPIZZA555
PIZZA HUT SINGAPORE PTE LTDPIZZAPIZZA555
PIZZA HUT UAEPIZZA PHPPIZZA555
Could you please show what exactly do you...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 6:16 am

#1492462
RE: General Qestions

Loundy (5/24/2012)
THANK YOU EVERYONE!
i was having a crap day but this has totally cheered me up!! 🙂
Give us your address and we will send you our invoices. It will cheer...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 5:50 am

#1492443
RE: Select Related Fields Data Issue

I can only suggest you to follow this:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 5:30 am

#1492429
RE: String Manipulation - Please help

select STUFF(s,4,len(s)-3,replicate('*',len(s)-3))
from
(
select 'Lokesh' s
union select 'Gowda' s
) q
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 5:27 am

#1492427
RE: cmd file name with space between each string

river1 (5/24/2012)
It's as you told:
C:\Program Files\WinRAR\WinRAR.exe x -u "c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - T - 1118.rar" "c:\import\PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - ...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 5:24 am

#1492425
RE: How to insert the records by group

select GROUP_ID, EMP_ID, NTILE(4) OVER (partition by [GROUP_ID] order by [EMP_ID]) AS GROUPLIST
from [dbo].[EMP_REC]
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 5:22 am

#1492422
RE: Need to merge date functions to render date

CELKO (5/23/2012)
...
Why do you want to do formatting in the database?
...
Because MS introduced FORMAT function into SQL2012 . May be they done it to pick on you...
:hehe:
... Besides missing...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 5:19 am

#1492421
RE: Problem with Default Date

You should always use ISO format (YYYY-MM-DD) when converting string values into datetime (or date). This will work regardless of server locale.
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 5:01 am

#1492405
RE: cmd file name with space between each string

river1 (5/24/2012)
This is how the command tries to execute:
"C:\Program Files\WinRAR\WinRAR.exe" x -u c:\import\"PastaExportacao SGCTlocal - 4.01 - 20120523 112426 - T - 1118.rar" c:\import\"PastaExportacao SGCTlocal - 4.01 -...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 4:49 am

#1492396
RE: cmd file name with space between each string

try using double quotes around file name:
set @NomeFinal ='"file1 codp meta2.rar"'
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 4:28 am

#1492386
RE: General Qestions

Eugene Elutin (5/24/2012)
Koen Verbeeck (5/24/2012)
Jup
https://twitter.com/JanosBerke/status/205519876062842880
It's been retweeted a few times and we had some good laughs 🙂
If it's followed on twitter now, I just wonder if the OP did try...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 4:26 am

#1492384
RE: Select Related Fields Data Issue

Not very clear what the problem is. You have duplicate records which you don't want to show?
Use : SELECT DISTINCT.
Otherwise, please provide DDL and sample data as per link at...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 4:16 am

#1492377
RE: How to insert the records by group

insert into [dbo].[EMP_SUMMARY]
select GROUP_ID, EMP_ID, NTILE(4) OVER (ORDER BY [GROUP_ID], [EMP_ID]) AS GROUPLIST
from [dbo].[EMP_REC]
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 4:09 am

#1492375
RE: General Qestions

Koen Verbeeck (5/24/2012)
Jup
https://twitter.com/JanosBerke/status/205519876062842880
It's been retweeted a few times and we had some good laughs 🙂
If it's followed on twitter now, I just wonder if the OP did try my favoured...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 24, 2012 at 4:04 am

#1492373
RE: Why to stored procedures run slower from SQL Server Agent than through SSMS?

colin.counsell (5/22/2012)
Ok, thanks guys.
On my connection I get '5496', whereas in the job it is '5176.
The diff being that my connection has ARITHABORT and QUOTEDIDENTIFIER switched on.
I'll try and change...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 22, 2012 at 6:53 am

#1491038

Viewing 15 posts - 1,501 through 1,515 (of 2,894 total)