Viewing 11 posts - 76 through 86 (of 86 total)
ok Joe no worries
Could you tel lme what SSMS is
Thanks
Alan
March 6, 2013 at 9:21 pm
Ok Lynn if thats what you want to do and move on and help someone else then thats fine.
I am new to SqlServer so I dont know how to do...
March 6, 2013 at 9:09 pm
Sorry Lynn
The BigTable.software_name_raw contains
SOFTWARE_NAME_RAW
Microsoft Office 2003 Professional Edition, Office 2003 Professional
Microsoft Office 2003 Professional Enterprise Edition, Office 2003 Professional
Microsoft 2003 Office Professional, Office 2003 Professional
and the RefTable contains a further...
March 6, 2013 at 8:56 pm
Hi Brad.
The software_name_raw on the RefTable is the Primary Key
Does that help
March 6, 2013 at 8:34 pm
hi guys sorry for the confusion, all i want to do is concentrate on the first 3 columns
so if the data shows this
Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,bla
Adobe Inc,Version 1.3.1,Licensable,bla,bla,bla,different bla
Sun Microsystems, Version...
March 5, 2013 at 4:29 am
I figured out why it was because of the data I was importing.
I have used that query thank you very much for your assistance
March 4, 2013 at 3:56 pm
ok guys I think I best show you the full query to see where I am going wrong. OH bare in mind some of the values in the columns have...
March 3, 2013 at 9:48 pm
ok guys I have gone with the case statement it seems to be working but I am getting quite a few columns with the value
unknown.x in it even the the...
March 3, 2013 at 9:11 pm
thanks guys thats very helpful, just one thing, the second query you provided how does that cover anything else just to provide the original value
March 3, 2013 at 8:48 pm
dwain
fantastic that seems to work fine, will that also cover any null values
much appreciated
alan
my next post is going to be on a bulk insert I am having a problem with...
February 22, 2013 at 4:12 am
ok uys, firstly thanks for your prompt response I have noticed one error in that I am not trying to update with the software name amended when i should be
secondly...
February 22, 2013 at 3:18 am
Viewing 11 posts - 76 through 86 (of 86 total)