Viewing 15 posts - 271 through 285 (of 389 total)
SQLRNNR (7/12/2012)
capn.hector (7/12/2012)
rhythmk (7/11/2012)
SQLRNNR (7/11/2012)
Cliff Jones (7/11/2012)
crookj (7/11/2012)
Possinator (7/11/2012)
SQLRNNR (7/11/2012)
jasona.work (7/11/2012)
EL Jerry (7/11/2012)
SQLRNNR (7/11/2012)
exploding grapesExploding Gremlins
"El" Jerry.
Mogwai
Gizmo
Bright light!
Poltergeist
They're heeeeere!
steak and maggots
Careful
Security
Burden
Donkey
July 12, 2012 at 11:06 pm
Raghavender (7/12/2012)
I have added the data viewer and executed the package but nothing is displayed.
That means data is not flowing from source itself.
Check the configuration for all sources as...
July 12, 2012 at 6:25 am
karen.blake (7/12/2012)
I am hoping that you can help me with a problem I am having using CASE in a query via a linked server.
I have set up a linked...
July 12, 2012 at 4:15 am
vinod.saraswat (7/12/2012)
I need an urgent help on this issue.
I got the problem that I and team not able to connecto the product server giving following error..
A network-related or instance-specific...
July 12, 2012 at 4:07 am
rajawat.niranjan (7/12/2012)
rhythmk (7/11/2012)
No issue.:-)
However one question.You did not mention which record you want.So if you want any specific record tweak the query little bit get the name of column for...
July 12, 2012 at 12:58 am
rimitha.p (7/11/2012)
When i am using SQL Server 2008,im writing update query by using the following query
update PackingHdr set Remarks = 'ABC' where Remarks IS NULL
but it is not possible...
July 11, 2012 at 11:58 pm
sheridan.zhu (7/11/2012)
July 11, 2012 at 11:55 pm
rajawat.niranjan (7/11/2012)
That workedMany Thanks @rhythmk 🙂
No issue.:-)
However one question.You did not mention which record you want.So if you want any specific record tweak the query...
July 11, 2012 at 11:50 pm
SQLRNNR (7/11/2012)
Cliff Jones (7/11/2012)
crookj (7/11/2012)
Possinator (7/11/2012)
SQLRNNR (7/11/2012)
jasona.work (7/11/2012)
EL Jerry (7/11/2012)
SQLRNNR (7/11/2012)
exploding grapesExploding Gremlins
"El" Jerry.
Mogwai
Gizmo
Bright light!
Poltergeist
They're heeeeere!
steak and maggots
Careful
July 11, 2012 at 11:41 pm
rajawat.niranjan (7/11/2012)
I have got following data:
ZIP CITY LATITUDE LONGITUDE
D1Dublin53.34410-6.26749
D1Dublin53.34673-6.22762
D1Dublin53.34844-6.25902
D1Dublin53.34854-6.26882
D10Dublin53.33020-6.29876
D11Dublin53.32524-6.25131
D11Dublin53.36834-6.26759
D11Dublin53.38450-6.31176
D11Dublin53.38590-6.29217
D12Dublin53.32689-6.34291
D12Dublin53.32960-6.33472
D12Dublin53.33205-6.29344
D12Dublin53.33302-6.31857
D13Dublin53.32130-6.26704
D13Dublin53.36324-6.21185
D13Dublin53.36998-6.18986
D14Dublin53.31511-6.25458
D14Dublin53.31539-6.23178
D14Dublin53.31855-6.24850
D15Dublin53.35659-6.28591
D15Dublin53.36291-6.33774
D15Dublin53.36414-6.30097
D15Dublin53.36933-6.32962
D15Dublin53.37165-6.33976
D15Dublin53.41073-6.32775
D16Dublin53.30240-6.29219
D16Dublin53.30449-6.23824
D16Dublin53.31327-6.29392
D16Dublin53.33793-6.22439
D17Dublin53.39741-6.23751
D17Dublin53.39875-6.18809
D17Dublin53.40402-6.17819
D17Dublin53.40577-6.19502
Here I want to select top 1 from each zip and city,
hence my results should look...
July 11, 2012 at 11:11 pm
rhythmk (7/10/2012)
Arman Khan (7/10/2012)
For example:
...
July 11, 2012 at 7:18 am
Kingston Dhasian (7/11/2012)
A quick search on this site gave me the below linkI hope this will be helpfull
http://www.sqlservercentral.com/scripts/Miscellaneous/65769/
Hello Kingston,
If I am not wrong then he wants all columns of tables...
July 11, 2012 at 6:12 am
Raghavender (7/11/2012)
Please find the attachment.
Hi Raghavender,
It is very difficult at our end to tell you what is the problem at your end.
However the only solution is that try out all...
July 11, 2012 at 4:03 am
artcvmna (7/10/2012)
why nvarchar using in sql?
I usually use it to support unicode data string which varchar does not support e.g. you can use it to store multilanguage data in database.
For...
July 11, 2012 at 12:12 am
capn.hector (7/10/2012)
jasona.work (7/10/2012)
SQLRNNR (7/10/2012)
Cliff Jones (7/10/2012)
crookj (7/10/2012)
Daniel Bowlin (7/10/2012)
rhythmk (7/9/2012)
Possinator (7/9/2012)
SQLRNNR (7/9/2012)
Cliff Jones (7/9/2012)
Ray K (7/9/2012)
Revenant (7/9/2012)
rhythmk (7/9/2012)
Brandie Tarvin (7/9/2012)
Daniel Bowlin (7/9/2012)
HeatwaveHeatstroke
Engine
Piston
V6
V8
HEMI
Barracuda
Fearsome
Foursome
Quartette
Beatles!
Monkees
wiener mobile
Hot Dog
July 10, 2012 at 11:21 pm
Viewing 15 posts - 271 through 285 (of 389 total)