Hi, how we can find out no of days in a particular month. I am using sql server 2000 Rahul ...more >>

Hi, how we can find out no of days in a particular month. I am using sql server 2000 Rahul ...more >>

Hi, I'm trying to copy from one DB to another but I'm getting an error when doing so. The error I get is: The column prefix 'DB1.dbo.MenuView' does not match with a table name or alias name used in the query. This is the query: insert DB1.dbo.MenuView select * from DB2.dbo.MenuV...more >>

Hi. I have a database named SUTDNet on a server on my computer. I created a few users for this database and i restricted any one's interests for this database. However, i can't hide my database's datas when anyone copies SUTDNet.mdf database file from my computer and attaches this file on other...more >>

Hi, I have a situation where I have to poll the SQL Server 2000 database for certain rows with a particular status. I would like to avoid polling, but for now it seems and easy way out. Would it be possible for a trigger on the table to post a message on a queue, in this case MSMQ and can T-S...more >>

Hi All, I have text files which has lots of records in it. Each column is seperated / delimited by pipe (|) sign. The problem i am facing is, after importing the textfile into sql server i find that all empty values are replaced by hyphen (-) within the DB. One way normally i will do is...more >>

Hi, i'm conerting a asp.net application from Access to Sql server express 2005. I have problem with cdate() and with date() within the sql string. My question is : how to translate this query for use with sql server? sql = "SELECT count(*)" _ & "FROM mytable " _ & ...more >>

Hello! I thought this was an easy one (and probably it is)!?!? I have a trigger that I want to do almost the same thing if a row is updated or inserted, but I can't figure out how to find out if a row is inserted or updated. How do I do that? Best regards /Magnus ...more >>

sql2000 is there some clever way to enumerate records in ordered query, so the enumeration reflects the order of records in query? one option is to use cursor to traverse the result set, but is too slow easy example could be, f.e.: set @recno_new = @recno_last +1 executed for each row...more >>

Hi! I have on my PC about 30MB DB mssql. I want to upload this DB on some commercial server with mysql. This will not be a big deal until I can generate special sql query using PHP. The problem is, that the BD on the server need to have the same records as on my PC. I use special account pro...more >>

Hey All. I have a stored procedure that, in the where clause has 4 subqueries. I just ran a sql trace on the db and it's usinq quite a bit of CPU (compared to the other queries). Aside from indexing, are there any other ways to optimize such a query? Thanks. ...more >>

Hi ,=20 I need same help. I have this query.... declare @local_variable varchar (MAX) -- BAD !!!=20 Set @local_variable =3D '' Select @local_variable =3D @local_variable + V.type from master.dbo.spt_values V order by 1 select Len ( @local_variable ) -- Fine !! Set @local_vari...more >>

Hi People, What is the best way to render a date in MMDDYY format using T-SQL? I need to include a zero in MM if the month is 1-9. Thanks, Eric ...more >>

Hello, I have two databases on one sql server. How can I run a single query on two databases? both databases have identical tables. servername: DB1 database1: operations01 database2: operations02 table: Usr_organizations I've put together a sql script to count channels from both databas...more >>

Is there a way to count averages all in one Select statement? Obviously I am a newbie at this, so here is what I am attempting to do. My table is made up of 3 columns, StudentName, TestDate, Score. I want to average the students score between date 1 and date 2 and then count those averages tha...more >>

I would like to set Isolation Level to READ UNCOMMITTED for reading from a view. This is in an effort to prevent SQLError 1205, State 50. Can I use an SqlTransaction object as follows? (using C# - I have tested this code and it does not crash and it does return the correct result set) ...more >>

Hi I came across this example that returns a result set with arbitrary start and end rows and was wondering if anyone could help me modify it so that it'll take an arbitrary column as for ordering. The SP was created fine but when I try to run it with say get_users 10, 20, 'username' it gives me...more >>

Assuming my database contains two tables. Each table with one clustered index and no non-clustered indexes. Given that these tables may share a data page within an extent. Is there any benefit to using different fill factors for each of these tables when creating the table indexes? I und...more >>

Hi Freinds, Trying to run this select a.memberid,a.adminactionmask,a.insertdate into #tmp2 from clsql5.db1.dbo.adminactionlog a where a.insertdate = (select max(b.insertdate) from clsql5.db1.dbo.adminactionlog b where a.memberid = b.memberid ) and a.adminactionmask & 4 = 4 and a.insertd...more >>

I'm trying to read a file into a string.. this code has worked in vb.net/asp.net.. but won't an ssis script task. Imports system.io ... Dim FILENAME as String = Server.MapPath("chat.txt") Dim objStreamReader as StreamReader objStreamReader = File.OpenText(FILENAME) Dim contents as String = ...more >>

Stumped??? We are running SQL SERVER 2005, SP2. We are trying to bcp a small amount of rows (40,000) into our DB. When we run the bcp command by typing it directly into Server Studio, it run w/o an issue. Again, just 40, 000 rows. When we try to run it through our application (this is ...more >>

I am trying to use SQL Server Management Studio to create a DTS (.dtsx) package for a SQL Server 2005 database. Unfortunately, the program that uses it complains that there are insufficient rights to perform a "TRUNCATE TABLE" operation. One solution is to create the DTS package using the sy...more >>

Greetings, I need to pull some rows where the date column does not fall on a weekend. I was experimenting with the Day function, but that only give me the day of the month. How can filter out weekend dates? Thanks, Rich...more >>

I'm writing several stored procedures that test the value of Integers which are represented by enumerated values in the VB application. My procedures are testing for 0,1,2 . . ., instead of new, scheduled, sent, cancelled, . . . I've considered using a user defined function such as uf_pmntS...more >>

Hello, I have 3 tables with their columns as follows: + LabelsInDocs [LabelId] PK FK , [DocsId] PK FK + Labels [LabelId] PK , [LabelName] + Docs [DocId] PK , [DocUrl] I set Cascade Delete On so when I delete a Doc all records in LabelsInDocs will be deleted. However, when a...more >>

I am starting a project where I will be using the XML data type in SQL = Server 2005, and ASP.NET to display and update the content of the XML. I've been digging around for a bit trying to find some sources that will = explain the process of doing data binding in ASP.NET with the SQL XML, = bu...more >>

Hi all -- I've searched but can't seem to figure this out -- trying to write a query that returns an average of one column grouped by another set of criteria, as in: Table columns: item_id, rater_id, rating Output: item_id, rater_id, rating, average rating (all raters, per item) Can I do...more >>

Question for the SQL gurus: I have a table that has two text columns, named ShortDesc and FullDesc. The users didn't start using the FullDesc field until a few years ago, it is blank in most of the records that are more than 3 years old. I want to write a query that returns the FullDesc column...more >>

Hi, There is a folder on the network (FolderMain) that gets populated with .xml files. It is not known at what time of the day the folder gets populated with files. But it does happen every now and then. i.e. every few days or once a day, etc... What is the best way in .net 2.0 or sql serve...more >>

I've got a 2000 server (SP4) with a Page Life Expectancy that often dips below 300. Is this truly a problem, i.e. does this mean I need more RAM? I guess what I'm asking is if there are "legitimate" reasons - admittedly I can't think of any - that would explain Page Life Expectancy < 300? ...more >>

I am writing some dynamic sql and I need to 'pivot' a column of field names from the syscolumns table; I need to convert this: name FIELD1 FIELD2 FIELD3 FIELD4 To this: 'FIELD1,FIELD2,FIELD3,FIELD4' I can do it fairly easily with VBS but before I do, is there a simple way of d...more >>

Do I need a cursor to do this? ...more >>

The Format File [_format.txt] 8.0 9 1 SQLCHAR 0 0 "|" 1 col1 "" 2 SQLCHAR 0 0 "|" 2 col2 "" 3 SQLINT 0 0 "|" 3 col3 "" 4 SQLCHAR 0 0 "|" 4 col4 "" 5 SQLCHAR 0 0 "|" 5 col5 "" 6 SQLCHAR 0 0 "|" 6 col6 "" 7 SQLCHAR 0 0 "|" 7 col7 "" 8 SQLCHAR 0 0 "|" 8 col8 "" 9 SQLCHAR 0 0 "|" 9 col9 "" ...more >>

Client is using SQL Server 2000 SP4. They are getting SQL Error 1205, State 50 while reading results from a view as follows: string connStr = "Server=MyServer;" + "IntegratedSecurity=SSPI;" "Pooling=true;" + "Initia...more >>

I want to grab the Min of a set of numbers, which works out fine. How can I grab the second lowest number? I tried to run another Min and exclude items from first Min, logically this would exclude the lowest and the second lowest would now be the first lowest, but it doesnt work. Does any...more >>

Hi, There is a table which I regularly run a select query on. The select query always has a fixed where clause on only three of the columns with different parameters. This is a query that runs each time: select * from tblData where PersonNo = 2 and EmployeeType = 4 and DataDate = getdat...more >>

I have a load of tables named RESULT1,RESULT2,RESULT3, etc. What I want to do is automatically load the contents of all of these tables into one large table. The problem is that the number of columns varies dramatically.. For example; RESULT1 may have 5 columns, RESULT2 may have 3 columns...more >>

hello. Say I have a string as follows "hello my name is bob #smith#_#jones#_goodbye' I only want to grab the first string #smith#. The below does not work. set @pattern = '%#%#%' select @s = PATINDEX (@pattern,@Parmin) Thanks for any help or information. ...more >>

Please bear with me I am just learning SQL I have a table that contains the following data, these are monthly useage counts Prod Oct2007 Nov2006 Dec2006 Jan2007 Feb2007 Mar2007 XXXXV031 52 9 18 8 18 102 XXXXV011 0 0 0 0 0 0 XXXXV040 ...more >>

I have a 'Number' which has multiple descriptions, and I want them to return on the same line in multiple columns instead of returning duplicate records. The info in all the other columns is identical. There is a number tied to the Desc items; so if you were to say Where Desc1 = 1 it would only ...more >>

I receive this error when i try to create and save a new view on in one database of my server. The message is: "Impossible to resolve the expression for the tie or the associated object schema" I try to create the view with t-sql and also with SQL Management Studio. I access to the databa...more >>

Hi there, Hope that anyone can help me on this one. I want to create a key column which consists of the following: Year/Dept.nr/Incrementnumber By that I mean when I insert a record in the table I want de field Project_ID to be like this: 20070551 being the year 2007 dept.nr being 055 ...more >>

sql2000 entprs manager shows "created" date-time for stored procs. is there some way to have also shown "modified" date-time, as in win explorer for files? this could help me to separate procs that are modified inlast time. thnx ...more >>

Hi, How can I view tables I have im my DB? I have SQL server 2005 MSDE and I havent seen any component to view what's in my DB and to insert sql commands.... Regards, Areq ...more >>

I found that OpenXML seems to be case sensitive, it means that it cannot find match columnname if case is different. Case-Sensitive is not good for me, I hope to set it up to case insensitive, is it possible? ---Frank Lee, using SQL2005 development sp1 ...more >>

Hi there, I would like to know how to accomplish the following; The Outer query is retrieving Sales numbers from a date range and the Inner Query should retrieve numbers from each date from the outer query od last year. @StartDate datetime, @EndDate datetime SELECT Sum(Sales) As Sale...more >>