SQL Server database programming

Can you LOOP through records with 2005 T-SQL?

D. Patrick - 29 Jul 2006 9:09 PM - 4 messages

I want to do a loop inside a stored procedure, such as: FOR EACH record in (SELECT * from table) PASS FIELD A, B TO ANOTHER STORED PROCEDURE END Is this possible with 2005 now? If yes, how? ...

Understand CREATE PARTITION FUNCTION/ SCHEME syntax.

ChrisR - 29 Jul 2006 8:16 PM - 4 messages

Howdy all. I was wondering if someone could please (gently) help me to understand the syntax below? My specific question is that apparently values for the smalldatetime column below that are NULL will go into the PRIMARY filegroup. But I don't understand how? I'm not telling it to put NULL's in ...

sys.dm_exec_query_plan

newscorrespondent - 29 Jul 2006 7:33 PM - 3 messages

This SQL2005 function returns the query plan in XML format. Is there any existing function that will take that XML and produce the plan in a presentable format? perhaps like what you get when using Server Management Studio? Thanks Tom ...

Accumulating Aggregator?

Andrew - 29 Jul 2006 2:50 PM - 19 messages

WHY! WHY? WHY!?!?!

Mike Labosh - 29 Jul 2006 2:43 PM - 15 messages

WHY IN GOD'S NAME do people write stored procedures that are like 12 pages of code, doing such bizarrely convoluted looping and cursoring, all lower case, no white space except for where it's required, no carriage returns, and not a single comment about what it's for, or what it means or what it ...

Using rownum in SQL Server 2000

SAM - 29 Jul 2006 1:13 PM - 10 messages

Is there a way to use rownum without using a temp table? ...

Query Optimisation

Eckhart - 29 Jul 2006 7:46 AM - 4 messages

DearAll, I applied the modifications by implimenting the joins,created indexes on relevent columns which are acting as optimizer hints-result positve improvement in the query processing,apart from that there is one more issue thats supposed to be considered for code reusablity, ...

Deep SQL .Net integration question

Sean - 29 Jul 2006 3:49 AM - 12 messages

Is it possible for SQL 2005 to be holding an old sproc signature to a specific table as it relates to ADO.Net or other .net functionality? My short story is that I have made a net gain in the number of columns on a ...

Stress Testing

Agi - 29 Jul 2006 1:00 AM - 4 messages

Hello, theres, I set up a simple environment, 2 machines, one for sql 2000 EE(2 HT CPUs, 2G RAM) , one for IIS + .net 2.0 (2 CPUs, 1G Ram) In sql server,I create a simple table UserPwd (20000 records) to ...

Odd behavier

plan9 - 28 Jul 2006 10:32 PM - 6 messages

Hello The situation is I have two select situations one with a count and the other with a SUM, The COUNT instruct goes well, the SUM instruct is a little picky I had to make a date convertion to char to solve the 156 error that I had. ...

Standard naming convention for index and triggers?

tshad - 28 Jul 2006 10:28 PM - 2 messages

Is there a standard naming convention (best practice) for indexes, triggers and keys? I've seen indexes as: Table name + Column name(s) + Unique/Non-uniqueness + Clustered/Non-clustered OrderDetails_OrderIDOrderDetailID_U_Cidx This is fine if it is only one column, but what if their are multiple ...

Help with Update and logging

KT - 28 Jul 2006 9:54 PM - 2 messages

Is there a way to run an update without it increasing the log size. I have to do this on 2 million records and log file grows from 6GB to 25GB. Thanks in advance. ...

Server & DTS question

Blasting Cap - 28 Jul 2006 9:21 PM - 3 messages

We're having to move SQL to a new server, which must be a new name. Previously, I had been using an old name, and when the server was replaced, we just gave the new one the old one's IP and name when we ...

Create Rule

HP - 28 Jul 2006 9:04 PM - 3 messages

Can you create a rule on more than one column? I want to create a rule for the following condition, fldname1 != '' OR fldname2 != ''. Is it possible? if so how? Your help will be greatly appreciated. THanks! ...

SQL distance between Latitude and Longitude?

John Baima - 28 Jul 2006 8:50 PM - 2 messages

Does anyone have a script for calculating the distance between two different points expressed in Latitude and Longitude? I thought that we had that in our database, but we were not actually storing Latitude and Longitude but some calculated values and I would like to change it ...

Select Data from a stored procedure from within a stored procedure

Ed - 28 Jul 2006 8:29 PM - 7 messages

Hi, hopefully this is an easy question to answer (I don't mind feeling dumb). I have a stored procedure that calls a remoted stored procedure that is selecting data (ie. select name from tblNames) So my question is: How do I access the data from within my stored ...

Displaying output parameter in query analyzer

jerryk - 28 Jul 2006 8:08 PM - 3 messages

Hi, Sorry for the basic question, but how does one user and display the value of a stored procedures output parameter in Query Analyzer. I tried the following: Declare @ID int exec myproc 1, 45, @ID select @ID I got NULL, when the result should have been a number. ...

Question about summing up different fields in different records

herman404 - 28 Jul 2006 7:54 PM - 2 messages

Hi everyone, I have some trouble writing a SQL stored procedure that can do the following: We have data in one table in numeric form, but we want to sum the data in this table based on the values of two different alpha fields. To ...

any performance diff using -Between- or >= and <= ?

Rich - 28 Jul 2006 7:21 PM - 13 messages

Hello, I need to run several queries that use 3 date args. Is there any significant different between the following select statements? Performance? what you capture? Select .... Where (date1 between @a and @b) and (date2 between @c and @d) ...

Stored Procedure executed from DTS

Fergus - 28 Jul 2006 6:41 PM - 4 messages

How can I access the Package Object which is executing my Stored Procedure. I see lots of examples of running DTS from stored procedure. What I want is to find out which package is executing my stored procedure (via exec sql) so ...

Too slow updates in a large table - Please help

Jay - 28 Jul 2006 5:49 PM - 5 messages

I have a very standard UPDATE query wherein I am updating a column in one table-1 with data from column in another table-2 using a INNER JOIN - standard stuff. Now, I have several identical table-1s which I am updating with the ...

Query Profiler

Mark Goldin - 28 Jul 2006 5:19 PM - 2 messages

Would it be possible to monitor for a few days every query's execution and collect the longest execution time (just that) for each different query? Thanks ...

Query to reconcile data

Timothy.Rybak - 28 Jul 2006 4:18 PM - 6 messages

I have a table with 3 columns: Processdate ReportingPoint SerialNumber When my customer starts construction on a part, they send a broadcast to me that contains a date/time stamp, the serial number of the part, ...

CLR and datatable

Curtis - 28 Jul 2006 4:11 PM - 3 messages

I am getting this error when I run my function System.Data.SqlClient.SqlException: Invalid use of side-effecting or time-dependent operator in 'SET ON/OFF' within a function. System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, ...

Database with many tables or multiple databases with lesser tables

Naveen - 28 Jul 2006 4:10 PM - 5 messages

We are building a large application (a financial system) that, after normalization, would approximately need 1500 or so tables. The question is should we build this as one database or should we separate it out into multiple databases. There is a case for separating out into 5 or so databases based on ...

Spreadsheet totals

Blasting Cap - 28 Jul 2006 4:08 PM - 12 messages

I have a query that I need to do subtotals on. The query is as follows: select ba, rg, sum(order_qty) as oqty, sum(order_val) as oval from sales_ord_curr_yr a inner join sales_product on sales_product.prod_cd = a.prod_cd inner join tblproducthierarchy on ...

Use SSIS For split record

Anja - 28 Jul 2006 3:16 PM - 2 messages

Hi, I've many rows and I want to split them in many columns, with SSIS. I've this scenario: INPUT TABLE id date -------------------- 1 2006-02-04 ...

SQL Server not responding.

kpraoasp - 28 Jul 2006 3:00 PM - 2 messages

Hi, I have SQL Server running on my local PC and that has around 40 Gig assigned to it. I am running a stored procedure using isql from MS-DOS prompt. this stored procedure inserts millions of rows into a table ...

Exec in TSQL (SQL Server 2000)

Norbert Meiss - 28 Jul 2006 2:37 PM - 8 messages

Hi, I need to know the result of a formula which contains placeholders for actual values. It works with writing the value to a table and read it again from there into a variable. But it must be an easier way to get the value to ...

parse again

Roger - 28 Jul 2006 2:15 PM - 4 messages

Hi MICROSOFT Platform: Windows 2003 R2 64 bit 32 GB RAM Sql Server 2005 Enterprise 64 bit with SP1 and all fixes applied Executing Parse in Sql Server 2005 Management Studio I get the following ...

Problem with UPDATE and IF

mario.kornmesser - 28 Jul 2006 1:36 PM - 2 messages

Hello, I have problems to arrange a proper SQL-statement. We are using SQL-Server 2000 and Win 2003 Server It seems that the failure is located in the "WHERE-clause". Especially the IF-statement produces some errors (Runtime) Maybe someone can check the syntax for a SQL-newbie. ...

Save Schema Only

David - 28 Jul 2006 1:05 PM - 4 messages

How can I save a database schema without the table data but include views and stored procedures? Thanks. David ...

data from production to test

Robert Bravery - 28 Jul 2006 12:15 PM - 3 messages

HI all, Whats the easest way of getting data from the production database into the test database, overwriting the junk in the test database Thanks Robert ...

sql ERROR

Microsoft - 28 Jul 2006 11:41 AM - 3 messages

Hi, I'm getting [Must declare the variable '@CNT'.] error while executing the below query. Please help. CREATE PROCEDURE [SSA_CATEGORY_ADDENTRY] @TABLENAME VARCHAR(250), @NEWENTRY VARCHAR(250) AS DECLARE @TMP NVARCHAR(250) DECLARE @SQL NVARCHAR(250) ...

Foreign Key may cause multilple cycles

gdonald20 - 28 Jul 2006 10:52 AM - 14 messages

Hi I have a background in access and am relatively new to SQL. I have migrated a database from access 2000 to SQL 2000 and experienced a problem in the relationships i didn't previously have. I have four tables A B C D each of these tables has a one field primary key. ...

Bulk Insert from Excel

Manuel - 28 Jul 2006 10:48 AM - 17 messages

IÂ´m new to this subject. As a matter of a fact, the first time IÂ´m trying this. I need to run a BULK INSERT query where the datasource is an Excel file and the destination is a table in SQL 2000 Server. ...

Filter Problem

ricky - 28 Jul 2006 10:30 AM - 10 messages

Hi This is somewhat a trivial question, but I have query with some Date Params in the WHERE clause, to filter on a certain period, or up to a certain period (for historical analysis). e.g SELECT SUM(Payment) AS Payment, ...

Random Numbers

Bharathi Kumar - 28 Jul 2006 7:49 AM - 3 messages

Hi, I have a requirement in my project: ex: User is running a scenario for 350 days. within this period some events may occur. Each event has some duration. for ex: within the 350 ...

Sort Numbers in Nvarchar As Numbers

Andrew Hayes - 28 Jul 2006 6:10 AM - 15 messages

I've read several posts and articles about this, but they all see to revolve around replacements and substrings and other paraphernalia. In my case the nvarchar field can contain any type of numbers/letters in any combination, but strings that are numbers should be sorted as such. ...

Query Optimisation

Eckhart - 28 Jul 2006 5:57 AM - 3 messages

Dear All, I am facing a problem with the following query,taking lot of time to fetch the data, calling the data using multi selects. CREATE proc Rolexi36Sync as DECLARE @date varchar(50),@ydate varchar(50) print CONVERT(char(11),(GETDATE()-1),100) ...

CLR - User Defined Type - Variable Storage or Other ??

ITContractor - 28 Jul 2006 3:13 AM - 5 messages

Greetings, Premise: * Several SQL Server Native data types have parameters e.g. varchar(x) * We can, easily, create a User Defined Type for SQL Server 2005 with a CLR - Assembly using VB or C# .Net in Visual Studio 2005. Question: ...

Dynamically import Outlook .pst file into table

Sandy - 28 Jul 2006 2:30 AM - 2 messages

Hello - Our organization has an up-to-date Outlook .pst file that lists all users, first name and last name, and their Windows user names in our area. I need a list of all users and user names in a table in my Sql Server 2000 database. ...

Stupid permissions question

Jesse - 28 Jul 2006 2:12 AM - 9 messages

Here's an easy question I can't seem to answer: I restored a SQL Server 2005 database from a backup made on another server, and I can't figure out how to create a user that has access to it without ...

I want to take a Data Warehouse home.

Mike Labosh - 28 Jul 2006 1:40 AM - 10 messages

Business rule: I am a dev-guy, and they pay me for 40 hours a week, but they expect me to do 8192 hours of production time. So I have to get a "copy" of the data warehouse. But the stupid company issue "craptop" doesn't have that kind of storage. ...

As an Aside

Mike Labosh - 28 Jul 2006 12:02 AM - 2 messages

Some of us over on the MS MCT secret server have been arguing about stome stuff, and one of the posts made me remember this: The September, 1986 issue of Byte Magazine had a long article about abstract mathematical art. The "1-Dimensional Cellular Automaton" algorithm is ...

How do I filter out unwanted rows by only one different column?

StefanD - 27 Jul 2006 11:38 PM - 10 messages

Hello, this might be easy but I have no idea how to do it: I have a table like with entires like this: Column1 Column2 Column2 12 name1 user1 ...

Problem replicating table has the same data (primary uniqueidentify) in both publish & subscriber

John - 27 Jul 2006 11:37 PM - 2 messages

I can replicate most of my tables between two servers, the only problem is on some of the meta data tables where publisher and subscriber both has the same data (including the primary key ) before the replicate, it failed with following error: ...

Orders Per Hour Count

Lontae Jones - 27 Jul 2006 10:56 PM - 17 messages

Hello, I have a table with 3 columns ProductID int, Product varchar(30), OrderDate datetime I have orders in this table from January to July I want to get a query that will display how many orders I am getting per day and per hour. ...

Re: Pass table name as parameter in stored procedure

--CELKO-- - 27 Jul 2006 10:44 PM - 4 messages

Just over 35 years in the trade. I have outlived many of my programming languages :) That is why I recognize the re-invention of old, failed techniques with new, modern tools. Wrong question. The right question is why anyone would build temp ...

sql 2k5 compatibility level option...

=== Steve L === - 27 Jul 2006 10:15 PM - 5 messages

if I back up a database in sql2k then restore it on sql2k5, does it make the database sql2k5 automatically? wihen looking at the database properties, there is compatibility level option for sql2000 and sql2005, what is the difference? i noticed the default is sql2000. ...

Count Customers FOr each month

Lontae Jones - 27 Jul 2006 9:34 PM - 4 messages

Hello, I have a table with 3 columns ProductID int, Product varchar(30), OrderDate datetime I have orders in this table from January to July I want to get a query that will display how many orders I am getting per month and per week. ...

automating database migration

bringmewater - 27 Jul 2006 9:16 PM - 5 messages

I have a dev tier and q tier of servers. Is there a way to automate it so I can have a specific database ("mydb") copied (i assume a detach is required) from my dev tier server to a q tier server? I need whatever ...

Getting an average

KatMagic - 27 Jul 2006 9:15 PM - 4 messages

I have a query that returns a sum of payments for each year for one client. What I need is an average of that sum, and I cannot figure out how to do that. Can anyone help? This is my query to get the sum for each year: ...

Moving Users from one server to another in 2005

Jim - 27 Jul 2006 8:53 PM - 3 messages

Is there an easy way to script out all of a users permissions (at all levels)? I have a user on a dev database on Server1 that I want to move to a test database on Server2. I would like to have something that would ...

using BCP to create file inserts NULL fields

mdscorp - 27 Jul 2006 8:49 PM - 3 messages

I have a table that I use BCP to dump it to a file, the file must be PIPE delimited so I am using the -t "|" parameter to make the file pip delimited. I am having the problem that whatever empty fields the table ...

bulk insert issue (appeding next row data to previous row)

jose.mendez22 - 27 Jul 2006 8:43 PM - 3 messages

I'm trying to bulk insert data from a tab deliminated txt file onto a table, however some of the rows within my txt file are are empty (e.g., last 5 of 8 fields are empty). My bulk insert is appending the next ...

top of group

vincent - 27 Jul 2006 8:39 PM - 2 messages

hello, I have a detail table that contains 100000 records. The account code field contains an account#. The date field contains various dates that transactions occurred against my account. Iâ€™ve used the order by clause to sort by account_code and date which has ...

Declare and Set

john d - 27 Jul 2006 8:32 PM - 2 messages

Is it possible to set a variable to equal what is in a database field for each row? I asked a similiar question previously but I was not clear on what I wanted. With this example how can I set the @datestring = whatever is in the Notes ...

Newbie update question-- take from one table into another

Steve Hershoff - 27 Jul 2006 7:58 PM - 5 messages

I have two tables, TBL_PARENT and TBL_CHILD. TBL_PARENT has a primary key (call it parentkey), while TBL_CHILD uses it as a foreign key. The tables share a one-to-many relationship, with TBL_PARENT acting as the one and ...

Date calculation

Hitesh - 27 Jul 2006 7:43 PM - 5 messages

Hi, I have a table named tblLog with following columns and example data: ID TimeStamp DateStamp UserID Version 1 10:00:01 2006-01-01 abc1 1.0.3.1 ...

master..sysaltfiles in 2000 vs 2005

Matthew - 27 Jul 2006 7:16 PM - 3 messages

I have this little snippet of code that I am using to get some information on database growth sizes, in SQL 2005 the code runs correctly. But when I take the same code and run it on a SQL 2000 ...

Several text datatype fields in a table

Christian Perthen - 27 Jul 2006 7:02 PM - 2 messages

Hi, I am wondering if there is any performance penalty, (or design flaw) in having more than one text datatype field in a table? The text datatype fields in my case doesn't hold any excessive amount of text, up to about 15,000 characters. ...

Grouping data...?

VMI - 27 Jul 2006 6:36 PM - 3 messages

Here's an example recordset because explaining it will be very long... I have the following recordset. The records EMP_ID equal to 001 are exactly the same except for the INSTANCES. There's only one EMP_ID 002 and 004 with ...

Configure default date/time parameter in query

Timothy.Rybak - 27 Jul 2006 6:33 PM - 8 messages

I have a query that depends on the user entering a start and end date/time string to return the desired results. I want to create a new version that will run automatically in Reporting Services and email itself to some users. I need the query to default to: ...

ID's as an array

Gervaise - 27 Jul 2006 6:21 PM - 9 messages

I have a field in a db, in one table it is the id field. TABLE.LOCATIONS ID NAME 1 VALLEY 2 MOUNTAIN 3 LAKE ...

sp_testlinkedserver

Dan - 27 Jul 2006 5:59 PM - 7 messages

Has anyone been able to get a return code of 1 using this new proc in SQL2k5? I have a SQL2k5 server that I am setting up a linked server to a SQL2k server and have been able to successfully query against tables on the SQL2k ...

OPENQUERY and ADO.NET

Jay.Paolucci - 27 Jul 2006 5:03 PM - 3 messages

I am having an issue with calling the following stored procedure from a .NET application and need some help: CREATE Procedure SelectMatchingCSUIDs ( @SSNs varchar(8000) ) AS SET NOCOUNT ON DECLARE @qry varchar(8000) set @qry = 'SELECT * FROM OPENQUERY(BANPROD, ''SELECT SUBSTR(CSUG_GP_XPID_V.PID, 2, ...

extracting data

john d - 27 Jul 2006 4:56 PM - 14 messages

I have the following char field called NOTES data examples: source field ...

Message to Email

Carlos - 27 Jul 2006 4:50 PM - 4 messages

I need to create a SP that send a message to the Order register Operator, when the price for some article are lower than a value, can someone help me with this ?? The query is SELECT Preco FROM OrdLin WHERE Art LIKE 'E123%' AND ...

View performance when using UNION

Matthew Brealey - 27 Jul 2006 4:15 PM - 4 messages

I have a view, which loosely looks like this create view vwWidgetPermissionEmployee as select WidgetId, PermissionId, EmployeeId from Widget join WidgetGroupPermission on WidgetId = Widget.Id join GroupEmployee on GroupId = Group.Id If I query this as follows: select WidgetId, PermissionId , EmployeeId ...

Error with sp_OAMethod

Everton - 27 Jul 2006 4:08 PM - 2 messages

Hi, I have a COM Object at my Server and when I export this COM as Proxy and Install in another server, the sp_AOMethod raise a error message. If a execute the code in my local server, ok, but when execute the code in ...

TRUSTWORTHY

rculver - 27 Jul 2006 3:46 PM - 2 messages

As I understand it TRUSTWORTHY is new to SQL 2005. What is the equivalent in SQL 2000? Or, more specifically, I cannot get a SQL Job to pull data from a Linked SQL 2000 server to an SQL 2005. I've tried setting the 2K database's ...

Wildcards

robdken - 27 Jul 2006 3:40 PM - 5 messages

Hi I was just wondering if anyone can clear something up for me... I am trying to write a SELECT query of the form: DECLARE @var as varchar(5) SET @var = (SELECT col1 FROM table1 WHERE id = 3) SELECT * FROM table2 ...

Using encryption with a user defined function

Dave - 27 Jul 2006 3:38 PM - 3 messages

How do I use encrypt/decrypt functionality within a user defined function? For example, I want the function to return a decrypted value similar to this: SELECT @OutString=convert(varchar(60), convert(varchar, decryptbykey(@deText))) But I need to open a symmetric key to decrypt and a a user defined functions ...

req. SELECT STATEMENT

Kalyan - 27 Jul 2006 3:33 PM - 4 messages

Following are two colmns in a table, I want to get only rows where column type value is in group_type column Example TYPE GROUP_TYPE V V,RX A V,RX,RD,F ...

An Urgent help required on Performance tuning

Sathian - 27 Jul 2006 3:10 PM - 6 messages

Dear All, We use SQL Server 2000. Inorder to increase the performance archived about 2.5 million records. However after the archival, the performance is found to be reduced as you can see in the below comparison details. This downsizing of almost 2.5 ...

How Can I Update DBF foxpro Table From Sp

Taha - 27 Jul 2006 2:17 PM - 2 messages

Hi all How Can I Update DBF foxpro Table From Sp Tankes ...

Trying to match lowercase

Stephen Howe - 27 Jul 2006 2:14 PM - 11 messages

Hi Using SQL Server 2000, SP4 On our database currently we have some bad data and it turns out the only distinguishing feature is that bad records never contains lowercase character - only uppercase, numbers, punctiuation characters. The field in question is a SQL Server fixed-length ASCII char type, 50 ...

Junction tables

Curtis - 27 Jul 2006 1:27 PM - 3 messages

I have the following tables and I am unsure of the benefits of using a junction table to join (for lack of a better word) the two tables. table 1 ClientID StateID table 2 StateID State I am in the development stages, so I can do it either way. I just want to ...

Client-Side Database Mirroring Details

GMouzourou - 27 Jul 2006 12:43 PM - 2 messages

Hi, I've been tasked with investigating different methods of achieving database redundancy. In doing so, I'm currently in the process of writing a test application to prove that Database Mirroring in SQL Server 2005 is a suitable solution. ...

too long...

Marco - 27 Jul 2006 12:09 PM - 14 messages

hello all, this is my request: declare @id_min_inscrit int declare @id_max_inscrit int select @id_min_alerte = min(cast(IDas int)) from TABLE select @id_max_alerte= max(cast(ID as int)) from TABLE set @cpt_id = @id_min_alerte while @cpt_id < = @id_max_alerte Begin set @cpt_id=@cpt_id+1 ...

i need one query

saurabh - 27 Jul 2006 12:06 PM - 9 messages

Hey i have a tabel which has 3 coloumns 1)ID (primary key) 2)product 3) value (can be either p or q) I need to write the querry which gives the result as Product, count when value=p for this product, count when value=q for ...

Index Tiff images using Sql Server 2000

Sohaib - 27 Jul 2006 11:45 AM - 2 messages

I want to Index Tiff images by using Sql Server 2000. But i couldn't find any IFilter for indexing Tiff Images. Can anyone help? ...

.Net SqlException, RAISERROR and Remote machines.

mehdi - 27 Jul 2006 11:26 AM - 2 messages

Hi, Consider a client machine running a .NET application. The app is configured to access a remote SQL Server 2005, though a connection string. Now consider an SQL Insert statement that fails (for whatever reason). This produces (normally) an SqlException if both client and ...

LIKE and IN

Simon Woods - 27 Jul 2006 11:22 AM - 4 messages

Hi I wonder if someone could explain, or direct me to an explanation, of what happens under the hood when a LIKE statement executes and an IN statement. Theoretically, should using an IN be faster on a non-indexed field than ...

total number of items selected

Tlink - 27 Jul 2006 9:27 AM - 6 messages

Is it possible to perform a select statement with a top 1000 and still count how many records meet the criteria without having to select without the top ? Any help would be appreciated. I am looking to achieve a result where I can inform the user of the real ...

Querying a remote server

JoÃ£o Costa - 27 Jul 2006 9:05 AM - 4 messages

Hello all, When I issue the following statement from query analyzer select * from [\\Server1].BD.dbo.TABLE1 I get the following message: Server: Msg 7202, Level 11, State 2, Line 1 Could not find server '\\Server1' in sysservers. Execute sp_addlinkedserver ...

datetime between problem

Mike P - 27 Jul 2006 8:50 AM - 12 messages

Can anybody tell me why this query returns nothing when I have a load of records between the dates specified? declare @InstallationDateFrom datetime declare @InstallationDateTo datetime set @InstallationDateFrom = '01-01-2000 00:00:00' set @InstallationDateTo = '01-01-2007 00:00:00' ...

Acessing database on another server from an SP

JoÃ£o Costa - 27 Jul 2006 8:45 AM - 2 messages

Hello all, Is it possible to do something like? declare @database varchar(100) set @database = '\\server1.dbo.db.tableA' select * from @database thanks in advance ...

SQL Join question - getting most recent value in a history table

Chris Strug - 27 Jul 2006 8:34 AM - 13 messages

Hi, My question concerns three tables: - tblHeader - containing general information such as product ID, description etc HeaderID HeaderDescription HeaderSerialNumber lstLocations - lookup table containing location IDs LocID LocDescription ...

float and mismatch between real data and sql server

Andrea - 27 Jul 2006 7:36 AM - 3 messages

Hi, i have a prb, sometimes when i put some number into float field, sqlserver put sometimes the correct number other a loss precision, for example: real input 90525.34 --->> 90524.339999999997 KO real input 123.12 --->>123.12 OK ...

Pros and Cons of Using GUIDs for Primary Keys

Will - 27 Jul 2006 6:26 AM - 4 messages

What are the advantages and disadvantages of using GUID for primary keys of tables in SQL Server? One major advantage that occurs to me is that you can make human readable backups of data in each table, and then be able restore one or more copies ...

Parameters in the IN clause

Ryan - 27 Jul 2006 3:49 AM - 3 messages

Hello, With the new SQL Server 2005 are there any changes for making an array / list of items to place in an IN clause. For example something like: (I know the syntax isn't correct) DECLARE @Items INT; ...

Indexing a view -- help!

Jesse - 27 Jul 2006 3:12 AM - 6 messages

I'm trying to index two columns, and can't figure out a clean way to do it. Any help would be much appreciated. Here's the table: CREATE TABLE companies ( name varchar, ...

Select problem Msg. 156

plan9 - 27 Jul 2006 2:31 AM - 16 messages

Hi I'm trying to do this select but I'm having a error 156, i'm stuck with this. Can anyone help? set @periodo_temp2 = (select SUM(nValorJuro4) from #TAB2 where dteDiaJuro between @periodo_inicio and @periodo_fim) Thanks ...

Get stored proc or SQL from sysprocesses pre SQL2000 SP3

newscorrespondent - 27 Jul 2006 2:14 AM - 2 messages

Is there a way to get some hint about what sql is running for a given entry in sysprocessess for an SQL2000 PRE SP3 system? I seem to recall that I used to do it but can't find how I did it. Perhaps I ...

unable to rollback transaction help!

JP - 27 Jul 2006 12:06 AM - 4 messages

I have a SP where the first line of the code is BEGIN TRANSACTION and a single COMMIT TRNASCTION at the end if @@TRANCOUNT=1. It then goes though several UPDATE INSERT and DELETE processes. All along the way each U/I/D process checking to make sure @@ERROR=0 before moving to ...

Getting records in pages from a table with Guids

nvamshi - 26 Jul 2006 11:50 PM - 3 messages

I have a large table(over 3 million records) with the primary key column defined as uniqueidentifer (guid). I want to iterate thorugh the table in increments of 50,000 rows and update the rows based on certain business rules.How do I do that? ...

What happens to rows when RETURN is invoked?

clintonG - 26 Jul 2006 11:26 PM - 5 messages

A typical SELECT loads rows into memory and a determination is made that invokes a RETURN. I assume the rows are left in memory? If so is there a statement(s) to remove the rows from memory before invoking the RETURN? ...

good books for sql server 2005?

David Cho - 26 Jul 2006 10:32 PM - 2 messages

These are some of the promising titles I see. * Programming Microsoft SQL Server 2005 Andrew Brust * Inside Microsoft SQL Server 2005: T-SQL Programming Dejan Sarka * Programming SQL Server 2005 Bill Hamilton Recommendations please. *** Sent via Developersdex [link] *** ...

how to get charindex of char between numbers?

suggestions for improving sortable, paging, filterable, fulltext non-dynamic query

Query Rewrite or Stored Procedure?

error message - what to do?

NEED HElP with Properly applying DISTINCT function to Count Aggregate.

Generating Sequential auto numbers

CASE function - result data type

Loop through column names, count values

Clustered index scans

SUM function

Pivoting in SQLServer2000 Again!

Dynamic derived column labels?

XML data to a SQL 2005 vertical table

Cross-Tab for Unique Combinations

False Sense of Security

Please help with difficult query

Wrong number of digit decimal place

Using NOT EXISTS

Re: while doesn't display in Query Analyzer

while doesn't display in Query Analyzer

Displaying parameters in Reporting Services report

Strange Error

Required Tiff IFilter for indexing in Sql Server 2000

a Query performance real slow in 2005

Count duplicate records

convert S9(05) COMP-3 field to SQL Server datetime

auto-complete Comboboxes in Reporting Services?

Availability calendar

Calling WebService from Trigger possible and advisable?

Put a dynamic Boolean expression in an IF condition

Setting ANSI NULLS ON

How to find SP line number

how to get rid of 00:00:00 in date field

Put a dynamic select result in a variable

Query % "up-side-down"

quick insert into help

compare to NULL

How to select multiple fields from a subquery?

sp recompile problem

remove leading , from varchar field

sql question

Query Lasts Years Sales

Syntax Error in Inner Join

Update Help

Curious Conversion Failure During INSERT via SELECT

Summarize data by date only

2005: Quickly Importing Data

SQL Server table data validation

Connection failure from ASP page after Upsizing to SQL server 200

Query Question

T-SQL COUNT() Question

SQL2005: Replication - How to determine remote publisher instance?

multiple calls to same stored procedure

Storing XML

saving sp output to variable

Feedback on Red Gate tools

Re: Pivot related query in SQL Server 2005

How to specify INDEX when adding new column with ALTER statement

How to return database role for all databases on the server...

failure to use the update command with a cursor

Help: don't understand this

Debug Median calculation

CLR equivalent of non existent xp_getfileDetails

Multiple tables into one?

group by month and show month with zero even when no data for it

Database Design ROI

Date format

IS numeric

sql statement problems

query question

Complex group by query

Help with query

process automation

help on SQL Statement

Help on SQL Statement

SQL Job

Rows to Columns

I don't want a distributed transaction!

Executin plan selection

Recommended DBA book(s), course(s), etc.

Having problem with stored procedure and permissions

UPDATE Trigger performance

Can you fix this query : syscolumns and primarykey : SQL 2000

doing search using LIKE and ignore brackets

Hashed passwords and secure data

SQL help!

2005: type defined in .NET

kill transaction

Primary key column additionally in nonclustered indexes

T-Script to create the "Create Table" Script

Assign a "record number" to each row through an UPDATE clause

Find Sum of the fields in the table

Copy data between two tables urgent help

Determining a zero recordset

Questions Concerning Nested SP

PIVOT Table Virgin - Why won't this work?

Command syntax

BUG: PIVOT query causing Msg 8624 (9.00.2047.00)

A Check on a trigger?

Update/select?

Using MAX on column already aggregated using COUNT

Cast assistance required

Pivot related query in SQL Server 2005

Help with SQL statement

Design: How to avoid violation of 2NF/splitting of compound primary key?

kill command

Copying one record to another

SP to save Image datatype to Disk

Returning recordset with "empty" value

Find bit fields with no default

Denormalizing data, flattening data

Checking null values in two tables

how do I write a command in SQL

Creating a New Database using the Sql Server Management Studio

Pick a substring

Use of SELECT TOP 1

Pass table name as parameter in stored procedure

2K5 Encrypted columns and resultant column length

Insert into Select

Pinpoint dead lock

Insert into table or update record.

similar data, same code, tables, stored procedure - production slower than development

Database diagramming tools.

instead of trigger vs stored procedure

Advise

derived columns in Parent - Child relation

Returning table from function

Counting hits in a text column

result set from Sp to a variable

PLEASE HELP

Determine date/time of last Windows Server reboot from a stored pr

Having Clause Question

Query / Report: Data not showing zero for null facility.

How to find out SQL server is running or not

Invalid column name

Trying to serialize number of columns of table

Track who changed a stored procedure

Unknown error

Rollback on error.

How do you do nested ifs??

How do I: Get columns referenced in Stored Procedure?

2005: APPLY?

DROP DEFAULT... how to?

Prevent The Cruelty

memory not available

LIKE restriction against multiple rows

Select one record even if join table datas does not exists

Synchronization

Columnheaders from query analyser to excel - SQL 2005

Automatic triggers

HOW TO USE JOIN QUERIES

SQL Server Memory Issue

Backup log dbname with truncate_only issue

Extracting item detail from an invoice table...

A Complicated problem

Selecting Last, First Names query

thanks

Pattern Matching

select all values that contain something in their group

SQL to update values based on a grouping

Sql Performance

How to Access a remote sqlserver Through a Proxy Server?

SQL Help

if row exist update else insert value