Hi, I am using the On-Line Help in SQL Server 2005 and did a search on the following text: "OR (Transact-SQL)" There is a "Copy Code" icon next to the example that illustrates the use of the OR operator. I copied the code and pasted it into a query window to execute it. However, the copy of...more >>

I'm curious; what do people here think about AdventureWorks? Do you use it often when you need to demonstrate something? -- BG, SQL Server MVP www.SolidQualityLearning.com www.insidetsql.com ...more >>

Hi all, I am getting this error when trying to connect to SQL Server 2005 express. The user is not associated with a trusted SQL Server connection. I am assuming it has to do with the server being configured for windows only authentication, but can't seems to find where i can rectify this...more >>

Hi, I have a Sales Table the structure is as follows : ID INT StoreID INT Month INT Year INT Sales MONEY the Data in the table is as follows ID STOREID MONTH YEAR SALES 1 1000 ...more >>

sql server = server A sybase = server B (set up as a linked server in A) I have a stored procedure in A that contains the following statement: SELECT * FROM OPENQUERY(B, 'exec storedproc') which runs the procedure in B just fine. It truncates a table in B and then populates it with data f...more >>

The below code (except for "CREATE PROCEDURE stp_RES_PopDL AS") works fine in QA. But when I try to create the SP, I get an error: Table #Comps does not exist. How do I get around this? thanks! CREATE PROCEDURE stp_RES_PopDL AS -- DROP THE TEMP TABLE IF IT EXISTS if exists (select * fro...more >>

Please help declare @t table (id1 int not null, id2 int not null, id3 int null) insert @t values (1,2,null) -- middle null insert @t values (10,20,1) -- middle 10 insert @t values (11,23,12) -- middle 12 insert @t values (20,100,123) -- middle 100 select *, middle(ID1,id2,id3) ...more >>

I have a project I am working on that has two tables. One is a reference table, and the other is a table that stores incoming data from an outside vendor. The customer wants us to write a "solution" that will compare the incoming data table to the lookup table, and find records that don't matc...more >>

Can someone guide me in the correct direction as to what's going on with this case statement: This was derived from and access IIF statement Access IIF statement: IIf([meterreading] & ""="" Or [previousreading] & ""="",Null, (IIf([MeterReading]>=[PreviousReading],[MeterReading]-[previousre...more >>

Hi, what's the syntax for a derived table? select count(*) from (select hostname, program_name from sysprocesses where program_name='mydb' group by hostname, program_name) as DB1? I want to return how many rows after group by hostname, program_name. How to do this in a query? Please he...more >>

Hi! I have small testing sqldmo.vbs script to check sqldmo connectivity: Dim srv Set srv = CreateObject("SQLDMO.SQLServer") srv.LoginSecure = True srv.Connect "(local)" ' Here is error when trying to connect to Express Edition MsgBox srv.VersionString Under Windows 2000 with SQL Serv...more >>

How to Change column name dynamically Declare @Column_name Varchar(30) Set @Column_name = (Select Name from Customer where ...) Create table #temp ( Name Varchar(30) Date datetime Sales Money ) EXEC sp_rename '#temp.Name', @Column_name, 'COLUMN' It fails ...more >>

Hi, Can I check and limit number occurrence users connect to sql server? Please advice. Thanks. ...more >>

Hi, I'm trying to query a vew that has spaces in the field names. For example: The view is defined with: select id as "User ID", address as "Home Address", zip as "Zip Code"... And I'm trying to query this view like this: Select User ID, Home Address from some_table left outer join myV...more >>

Does anyone know the valid parameters for xp_readerrorlog? Thanks in advance! Brent ...more >>

Hello I've been using that nested modeltree that Celko uses, and it's superb, but I've encountered a problem with a table (some unforseen things happened when i tried to move subtrees from A to B), and a really huge tree ended up with gaps, structure of tree isnt messed up or anything, just ha...more >>

I need to SUM the individual digits in an integer. My integer will always be less than 99 DECLARE @TestInt tinyint SET @TestInt = 21 How do I return 3. ...more >>

Hi all, I'm doing some scripts in a schedule job. Looks like I have some limitations on the size of the code inside of the steps. It's a way to fix this? Tks JFB ...more >>

I have a table that contains a large list of UserIDs. One column in this table tells whether that user is allowed to have entries in a second table. ex: TABLE USER USERNAME | AUTH User 1 | true User 2 | false TABLE 2 USERNAME | Some other columns IF A...more >>

I'm sure this has been asked a bunch of times, but I can't find samples that apply to many groups and columns. I also found ROW_NUMBER() function for SQL 2005. Unfortunately, I have SQL 2000. I realize this should be done in the display of data but I have to get it done in a table. I believe R...more >>

i tried to run this script: ALTER TABLE RDKCOCUS DROP COLUMN [Administration Executive], DROP COLUMN [Administrator], DROP COLUMN [Auditor], DROP COLUMN [Chairman], DROP COLUMN [Chief Executive Officer], DROP COLUMN [Chief Financial Officer], DROP COLUMN [Chief Operating Officer], ...more >>

I need a way to convert names for example like MPX 22 to first name MPX and lastname =22. Below is the code I am currently using but returns null for both fields 'User_First_Name' =Case when rtrim(agent) is null or rtrim(agent) ='' then 'NA' else rtrim(rtrim(Substring(agent,patindex...more >>

/** DESCRIPTION Okay, I have an app that I need to compare information from two dates in. The two dates are whatever date is passed to it, and its equivalent business day from last year. For instance, today is January 10th, 2006. January 10th is the tuesday of the second week in 2006. I need t...more >>

We have a deployed website with many concurrent users who are mostly reading from the database although there are frequent inserts/updates as well. At scheduled intervals, we run multiple matching queries against a table with around 120,000 rows. We used to run it WITH (NOLOCK), but we decided...more >>

I have some legacy data (codes) that I need to integrate into a new application. The new application will only accept 3 characters, my legacy data is 3 or more characters. My plan is to: 1) run a one-time UPDATE to create new data that is a unique 3-character code. Given my DDL I want to look ...more >>

I am trying to write a query that looks at a linked server. What I want to do is return an error through SQL to let me know if that SQLServer instance is in fact running. Currently I keep getting the following message back Server: Msg 17, Level 16, State 1,Line 1 SQL Server Does not exist or a...more >>

I should want to be able to dynamic create a picture in SQL 2005. I have looked at CLR and this look very intresstning but i can not import System.Drawing into my project. Is it possible to do this in any way? The dynamic picture will be returned in a SELECT so i need to use UDF. /Martin...more >>

I have inherited a stored procedure that receives a varchar parameter @values. @values is supposed to be a comma separated list of integers, for example '34, 873, 2347, 9873, 23894732' This is then used in some dynamic SQL to say 'select * from table where table.value in (' + @values + '...more >>

How to check when a specific stored procedure was last re-compiled ? ...more >>

I have a stored procedure that I want to look like this: SELECT * FROM Table WHERE Key IN (@keyIds) How can I declare the @keyIds (ints) in the SP so that I can pass multiple values? I know SQL Reporting Services can do this, but I don't want to use SRS. -mdb...more >>

We are experiencing a problem with a migrated database. Seems that the end of line character(s) is being treated differently in the stored procedures from one installation of the database to the new installation. The problem we are seeing is explained here: http://support.microsoft.com/kb/19...more >>

I have the following table with datetime and varchar(10) columns. CREATE TABLE tblA ( fillDated datetime NULL , fillDate varchar (10) ) Sample data: fillDated fillDate 1/13/2006 1/13/2006 12/19/2005 12/19/2005 I would like to query those records where the date is >= toda...more >>

I have an app that uses both SQL 2005 and SQL 2000 as the DB. My question is when I run a query with ADO.NET throught VB.NET without specifing the "WITH INDEX" in the query, does SQL automatically use any indexes available? Also, I tried running the SQL Tunning Wizard w/ SQL2005 and after I g...more >>

Hi, Just looking at the RAND option to be used in SQL, is it at all possible to also include a random selection of Upper Case letter in the random select and then to check that this value has not been used before by checking the value in another table? The end code shoule be 10 character...more >>

I need a scalar function that I can call from a select statement (with other criteria) that will dynamically return all the columns (And sometimes their datatypes with a mode option), from a table or view from any database on that server. The function needs to work in both SQL 2000 and SQL 20...more >>

I am wiriting a C# application that stores availabilty information in a table ie UserName, UserAvailable (just to keep it simple) I am looking for a recommendation for the best way to have the SQL database notify my c# client that any data in this table has been changed. In my old non .n...more >>

In the SQL Server 2005 Express Edition Overview document on MSDN located here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp It states, under the Language Support section: "The SQL Server Express database engine supports all of the 12 languages tha...more >>

Hi All, I am trying to create a cursor that inserts new records from one table into another where they are not present in the second table First Table Name Address Postcode Code Ben 3 High Street SSL 124L James 5 Lower Street CH6 ...more >>

hello, i have a large table with invoices ~ 8 Mio entries, with a structure ->customNr,ProductNr,SellPrice,InvoiceDate example TInvoices 100001 22 23,22 19991129 100001 14 23,22 20051222 100001 22 23,22 20061230 * 100001 15 23,22 20051229 100001 11 23,22 20060101 100...more >>

Hi everybody! Is there a way to find what objects(tables, stored procedures) have changed in the database since the certain date? Colleague is absent and I need to extract schema changes he made in the database....more >>

Hi again, I was hoping someone could help me create a sql query to minimizing the content in my table based on a few rules. Further to my previous post... http://groups.google.com.au/group/microsoft.public.sqlserver.programming/browse_thread/thread/b14260359bc66088/33f57129f2b9da63?lnk=st&q=...more >>

Dear all, I've got two DTS with a lot of transformations and within of them VbScript snippets and so on. My issue is that both has been modified incorrectly but I haven't idea where and how. So this way I was wondering if exists any third-tool on the market (I'm not thinking in the own Sql ...more >>

Hi All, I have a simple problem with GROUP BY If I have sample data as follows: id group id type date 1 400 I 10/12/05 2 400 I 11/12/05 3 ...more >>