There is an XML datatype for this in SQL Server 2008 and I believe SQL Server 2005 (but not 100% of this). Thanks Andy From: SQLQueriesNoCode@yahoogroups.com ...
4684
Travis Truax
truaxt2000
Jun 1, 2011 2:24 pm
Hi Paul, Yes, it's on a MSSQL2008 box. In the cursor-based routine, I've just got a borderline illegible select statement filled with the following: SELECT ...
4685
Damhuis Anton
antondamhuis
Jun 1, 2011 2:37 pm
Ok this is what I worked it out as: --Begin SQL Code -- Drop table Table1 Create table Table1 ( PO int, ID int, Comment varchar(50) ) Insert into Table1 Values...
4686
Travis Truax
truaxt2000
Jun 1, 2011 2:37 pm
I have to plead ignorance of the XML functionality in SQL Server. I knew "something" was there, but I thought that if I left it alone, it might leave me alone....
4687
Damhuis Anton
antondamhuis
Jun 1, 2011 2:38 pm
Oops sorry forgot to add: This linked helped me: ...
4688
Paul Livengood
p_livengood
Jun 1, 2011 2:40 pm
its not going to be pretty no matter what because we will ahve to hard code field names and lenghs. Can you supply all the possible field names and do they...
4689
Travis Truax
truaxt2000
Jun 1, 2011 2:43 pm
Thanks Anton, Something else has come up so I can't work on merging any of the suggested solutions into my code at the moment, but I'll post what worked best...
4690
Travis Truax
truaxt2000
Jun 1, 2011 3:05 pm
This is the entire field list: (please don't bother coding more in detail, I was just looking for suggestions. I know you guys have stuff to do... ) Your...
4691
Arnie Rowland
arnie1568
Jun 1, 2011 4:24 pm
This gets you a comma delimited Name/Value pair list. USE tempdb; GO INSERT INTO TestTable VALUES (1234567890, 1, 'XSHIP TO ADDR2 3500 Amiel Way XCITY...
4692
Travis Truax
truaxt2000
Jun 1, 2011 6:17 pm
Thanks Arnie, I'm actually just parsing the data they've made sausage out of and inserting it into a shipping table to integrate with Fedex & UPS software...
4693
Arnie Rowland
arnie1568
Jun 1, 2011 9:45 pm
Travis, I think that you will find the below to be a far more efficient (and faster) method to concatenate the strings and then parse out the values. The query...
4694
Arnie Rowland
arnie1568
Jun 1, 2011 11:03 pm
(Darn funky formatting...) Travis, I think that you will find the below to be a far more efficient (and faster) method to concatenate the strings and then...
4695
Charles Carroll
charlesmarkc...
Jun 13, 2011 8:52 pm
My work I need to recommend one of the following: http://www.telerik.com/ http://www.Dundas.com http://www.infragistics.com/ http://www.devexpress.com/ ...
4696
Eric Kestler
eric.kestler
Jun 13, 2011 9:00 pm
I'm currently working with DevExpress -- ASPxGridView Editing component and XtraReports....groupings are very easy, and end user can specify within the grid...
4697
Charles Carroll
charlesmarkc...
Jun 13, 2011 9:09 pm
why did you pick it over other competitors? Thanks for your input btw...
4698
Eric Kestler
eric.kestler
Jun 13, 2011 9:18 pm
Our main website is really a CMS (Syscom GM)...they use Telerik...and I've noticed some of our more computer-literate users express frustration (as have I)...
4699
Mohamed A
thegoldenaaa
Jun 15, 2011 2:42 am
Suppose you have table name employee and you want to make a copy from this table including structure and data to another new table name employeeNew , use the...
4700
y_sh_1984
Jun 15, 2011 4:19 am
Hi Everyone I am designing a database and need to keep the changes that users do in database to report to their bosses . For example if they Insert a new...
4701
Joe Fawcett
joe@...
Jun 15, 2011 7:31 am
In SQL Server 2008 there is an auditing feature ( http://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx), this may do what you need. If you're not...
4702
Travis Truax
truaxt2000
Jun 15, 2011 12:02 pm
You can put triggers on the tables that need auditing, and create some other tables to hold the audit records. ... From: "y_sh_1984" <y_sh_1984@...> To:...
4703
John Warner
john@...
Jun 15, 2011 12:18 pm
I think a good question is what tool(s)/application(s) are being used by your users to modify the data in the database to begin with? What method exists for...
4704
Hendra Prakasa
ninja_asakura
Jun 15, 2011 1:56 pm
I think you should consider "Change Tracking" feature from SQL Server 2008, Change tracking in SQL Server 2008 enables applications to obtain only changes that...
4705
King Wilder
king@...
Jun 15, 2011 3:21 pm
If I understand the question, I’ve done this before and it seems as simple as adding some columns to the tables in question: n UpdatedBy – the username of...
4706
Chirag Mewada
chirag.mewada
Jun 22, 2011 11:51 am
@ sign represents parameter and you are creating varialble so first of all remove @ sing bofore the name of variable and if you are using paramenter then find...
4707
Charles Carroll
charlesmarkc...
Jul 12, 2011 12:05 pm
http://tech.groups.yahoo.com/group/DBMSDashBoardsWebReporting/ Devoted to DBMS Dashboarding including any web based reporting but early focus will be on: =>...
4708
Charles Carroll
charlesmarkc...
Jul 12, 2011 2:16 pm
http://tech.groups.yahoo.com/group/WinFormsWPFNativeWinApps/ Focused on building Native Windows Apps that fully exploit the Windows Platform that don't run in...
4709
Rob Richardson
interrobang
Jul 12, 2011 3:25 pm
select foo.x, bar.y from foo left outer join bar on foo.a = bar.a order by y, x In some cases but not all, y will be null. Can I count on all records with...
4710
Paul Livengood
p_livengood
Jul 12, 2011 3:30 pm
i recommend using ISNULL and specifying a value for when bar.y is null. this helps you control the results. Â Â select foo.x, bar.y from foo left outer join...
4711
Rob Richardson
interrobang
Jul 12, 2011 3:34 pm
Thank you. That will help. RobR ... From: SQLQueriesNoCode@yahoogroups.com [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Paul Livengood Sent:...
4712
Rob Richardson
interrobang
Jul 12, 2011 3:42 pm
The ISNULL() function is not available in PostgreSQL. A quick Google search told me that ISNULL() is a Microsoft-specific addition to SQL Server. The...
