Search results for query: *

I'm stymied how to parse some XML. Specifically, I seek to parse the following XML: DECLARE @XMLText xml = '<result> <record> <field name="usid" id="usid" value="9876" /> <field name="namel" id="namel" value="Jon" /> <field name="namef" id="namef" value="Anderson" /> </record>...

I have the following query the runs very slowly. The sample below is just a few XML records. The actual data contains ~11,000 records and takes ~13 minutes to execute. Surely, I'm doing something wrong here. I seek guidance on how to speed up my query. TIA! DECLARE @xml XML SELECT @xml =...

This may be simple, but so is my brain. So I seek assistance with the following. I need to compare a field in each of two tables to create an "is equal" where not equal. For example, "USA" in table one would be considered equal to "United States" in table two, "CAN" in table one would be...

I'm missing something simple, I'm sure. I can't seem to find a way to do a simple SELECT statement to get this: fn1 fn2 129 DA 129 LV 129 NY 291 NJ 302 AL 302 FA 302 GD from this: <result> <record> <field name="fn1" id="fn1" value="129"/> <field name="fn2" id="fn2" value="DA"/> </record>...

T-SQL Script for a list of increment times My goal was to create an efficient T-SQL script with the following criteria: - create a list of incremented times (in minutes) of a 24-hour period - one column for the actual value - one column for a "friendly" display value - one column to select the...

I don't quite know how to express what I'd like to do without providing an example of before/after. Here goes: How do I turn this: ID1 ID2 Col_Type Col_Capture 25 14 t.01.id Item_01 25 14 t.01.resp Dr. Robert 25 14 t.01.value Lennon 25 14 t.01.dt 2011-09-01 16:00 26 14 t.07.id Item_05 26...

I am trying to figure out how to convert a BIGINT to a DATETIME. At first I thought they were Unixtime, but they aren't. (I tried with and without offsetting for our timezone: CST.) I know the following: 3127196040 = '2003-01-30 12:48:00' 3113983920 = '2000-01-10 15:04:00' I know this...

When I import a CSV into SQL Server 2005, my import is missing about half of the records. I know why it's doing this, but not how to fix it. I found that [Field5] of the first record in the CSV is an integer. However, about half of the records have alphanumberic values in that field and SQL...

Greetings. I am having difficulty with the ASPError Object and I scoured other sources to no avail. (IIS5, ASP 3.0, Windows 2000 Adv Server) My goal is to display a more intuitive error as part of an ASP page, but it seems I can only get back a limited number of parameters. I commented out a...

Greetings! The column [ColumnC] contains multiple values. The values are comma separated numbers. My variable is MyID. Example record1: ColumnA: Hello ColumnB: Excellent ColumnC: 1, 15, 23, 35 Example record2: ColumnA: Hi there ColumnB: Fabulous ColumnC: 12, 33, 105 The SQL example: StrSQL...

I have a table whose Primary Key is a Text column. I wish to display the PREVIOUS and NEXT values. If the Primary Key column were a Number this would be easy. But since it's a String I would have to poll the table to discern the preceding and following values. The question is how do I get...

Here's what I wrote: strsql = &quot;&quot; strsql = &quot;SELECT * from [Table1] WHERE &quot; strsql = strsql & &quot; [Column1] NOT in ('abc','def','ghi')&quot; strsql = strsql & &quot; AND [Column2] = &quot; & variable1 strsql = strsql & &quot; OR [Column3] = &quot; & variable1 strsql =...

OS: XP Professional Software: Windows Messenger 4.7 All MS updates: current When logged into the OS as Administrator: - On a computer at home I can't login to Windows Messenger. - With the same UserID and Password I can login from work. - On another computer at home running the same OS and...

I would like to present the total number of records of 2 MS Access tables on one page. That is to say that I'd like to display 2 response.writes: 1 record count of all records for each table. How would I go about this? Thank you in advance! Dave [idea] [http://flashspot.com]

Greetings, Gurus: I created an .ASP with this in it: Response.ContentType = &quot;application/vnd.ms-excel&quot; When running this page the Excel document succeeds if I select SAVE. Problem 1: The saved document creates a new row for each record AND for each carriage return within a memo...

Greetings, Gurus: I need to allow some .ASP pages to only show to users of certain IPs. I cannot use the IIS security for this since some pages would have this protection, but others not. Ideally I could just have a line of code for each IP I wish to include. Thank you! Dave [idea]...

Hi, Gurus: Response.Cookies(&quot;Login&quot;).Expires = Now() + 30 Means it will timeout in 30 days. How can I do this so that it will timeout in 8 hours instead? Dave [idea] [http://flashspot.com]

Gee, it'd be cool to be able to Copy/Paste an Event (all the fields) to create a new one. The toolbar options don't have these Edit functions. Same is true of Tasks. Ideas? SPTS TIA, Dave %-)

OK. Sounds simple, but Microsoft's licensing requires a doctorate to understand. The whole CALs (Client Access Licenses) is, IMO, a completely stupid software model. Worse yet is Microsoft's lack of clear information and methods for acquiring CALs. So, with exasperation, I ask qualified...

(also posted in IIS forum with no responses) We have an SSL site that worked fine until we did the latest Windows 2000 Server updates. Now the HTTPS site does not work, but the HTTP site does. When I try to go to the HTTPS site, it gives me the standard &quot;Site not found&quot; page. Any help...