Programming SQL
in [Microsoft SQL Server]
|
First
|
Prev |
Next
|
Last
Pages: 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232
Querying web service data from SQL Hi All, I have a number of web services which deliver a tabular data stream I would like to access this data from SQL within SQL Server. Ideally I would like to dynamically query this to provide for real time access to the data from the web service. Please kindly point me the right approach to implementing thi... 25 Jul 2008 11:28
Error handlers? Returning from? I'd like to write a generic block of T-SQL at the end of a long stored proc that I can "GoTo" whenever I want to log an event or an error. This way, if if I ever want to change/enhance the logging (right now I'm just inserting info into a log table but I might want to insert to a file and/or send an email, etc... 25 Jul 2008 13:31
Linked Navision 4 server I'm looking to link a SQL 2005 server to a Navision 4 datasource. Could someone provide an example on how to do that? ... 7 Aug 2008 10:23
Deadlock when executing concurrent updates of one table I have a table and 2 transactions. One of the transactions selects a few times from the table and then tries to udate the table. The other transaction works with other tables and then tries to update the table. The updates run concurrently (guessing from the server trace log). Different rows of the table are up... 30 Jul 2008 17:55
SP to summarize data I have an sp that selects data at a detail level. Can I create an sp to summarize the data in the detail sp (by calling it), or do I need to create a single sp that selects and summarizes the data? Essentially, can one sp call another sp? ... 25 Jul 2008 16:36
Sony Acer Laptop Batteries 4 Less http://www.gusdeluxe.info/Catalog/laptop-battery-c-28_42_43_70.html <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P class=Style1 align=center><FONT size=6>If you need laptop batteries welcome to visit our store</FONT> </P> <P> </P> <P> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TR> ... 25 Jul 2008 09:24
is there _ANY_ way to show the row that is throwing an error in a query? On Thu, 24 Jul 2008 18:10:25 -0700 (PDT), scottedwards2000 <scottedwards2000(a)gmail.com> wrote: I have the query below that is throwing the error 'Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int.': I know I am way late on this one, but an approach I have f... 25 Jul 2008 08:23
Spot the formula I've done the factor column as a CASE expression, but want to find a formula for it? Can anyone spot the formula here? The test column is my example. ;WITH cte AS ( SELECT 1 x UNION SELECT 2 x UNION SELECT 3 x ) SELECT a.x a, b.x b, CASE WHEN b.x In ( 1, 2 ) THEN b.x WHEN a.x = 1 THEN 2 ELSE 4 END AS ... 4 Aug 2008 06:25
SQL Server can fetch information on Install server ? Hello, SQL Server can fetch (server HDD serial number or SQL Server unique Id (if there is one) ) ? For the licensing purposes Thanks ... 25 Jul 2008 10:26
Get data from AS/400 into SQL Server 2005 Hello, I am a new user to SQL Server 2005. Currently I have the task in producing a report using Crystal Report and viewing data thru ODBC to get data from AS/400. It is a cumbersome process, extracting the data Many times I do not need a report, but a query or view. Is it possible to get data from AS/400 ... 25 Jul 2008 09:24 |