Hi, I am trying to use the following UDF - Split in an SQL statement. ------------------------------------------------------------------------------ -------------------------------------- CREATE FUNCTION dbo.Split(@String nvarchar(4000), @Delimiter char(1)) RETURNS @Results TABLE (Items nva...more >>

L.S. This is the first time I'm creating an ADP file. I've connected to the SQL server and using the source data of an empty sql table, I've created a form. When opening this form it is totally blank without the possibility to enter data. What did I do wrong. Thanks in advance Stella ...more >>

Is it true that as a user of Express Edition I cannot debug T-SQL code? How experienced programmers diagnose errors in T-SQL instead of debugging? Thanks in advance. /RAM/ ...more >>

Hello, I want to develop an application that will have a standalone SQL application on a local machine using VB. Basically I would like to write a program in Visual Studio 2005, use SQL, and when I create the Install, I would like to have the InstallShield create install the application and ...more >>

Hi All I have 2 installations of SQL Servers. Both are the one is 8.00.2039 SP4 Enterprise Edition And the other is: 8.00.2039 SP4 Developer Edition The same query when fired on the same DB on the two servers yield different results (the result set is the same but the sort orders change)...more >>

Hello there I've tried this code: DECLARE @Result table (Field1 varchar(100)) ALTER TABLE @Result ADD COLUMN Field2 varchar(100) and it gives me error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '@Result'. Is there a way to add new column to table variable? ...more >>

Hello there I need functions to get data on my files on the computer. Like Dir() on visual basic. What is the names of these functions? ...more >>

Sorry to repeat myself but I need an answer quick. If I may rephrase a previous append: Is there anyway to do a pivot within a view within SQL Server 2000? (And if not, does anyone have a handy work-around?) (I've been reading and trying but it appears that the essential pivot table ...more >>

I have table that has many colums. the ID col is identity and it is the clustered PK pr_name col has index on it NPI col has index on it. MG_id doesn't have index. the code bellow is behaving differently when uncommenting some of the rows. shouldn't it use the index on PR_name in every ca...more >>

I am using a view to include fields from a second table, using a LEFT OUTER JOIN. Queries are slow when they reference any fields from the 2nd table. The indexed view seems like a hassle with schemabinding and other rules. Is there any alternative? Any way to include certain fields from the...more >>

I want to write a script that will generate a script an execute script for all the stored procedures in my database with the parameters that need to be entered. So far I have: SELECT N'Exec Procedure ' + ROUTINE_TYPE + N' ' + QUOTENAME(ROUTINE_SCHEMA) + N'.' + QUOTENAME(ROUTINE_NAME) + N' ...more >>

I have an INTEGER column that I want to convert to a primary key. However, some of the values currently in the dataset are not unique. What query will delete any records with duplicate values of the intended index? Many thanks! ...more >>

I accidently truncated the log of a production database (on the source server) that is log shipped. Will Sql Server 2000 self-heal? Or do I need to tear down and re-do log shipping?...more >>

I took a look at a lot of the docs the MS put out to encrypt and decrypt columns and then looked at their database used to secure membership of a web site to see it in action (aspnet.mdf). I can see that the appropriate fields are encrypted but nowhere can I see HOW they encrypt the fields. Th...more >>

How can I check for a null value in one of my columns before binding to a gridview? GridView3.DataSource = cmd2.ExecuteReader(); //check for DBNull value here Thanks, Trint ...more >>

Hi, I have a multilingual database with the following design: Cities CityID [int] Name [varchar(256)] ("neutral" name of the city) Cities_Localized CityID [int] LCID [int] (Language ID) Name [varchar(256)] (translated name of the city) Now ...more >>

I am trying to edit a current stored procedure I have to add a different choice for the ORDER BY clause. Here is my original SP, CREATE PROCEDURE SSNList @sortOrder VARCHAR(5) AS SELECT E.EmpID, EF.StateEmpID, E.EmpFName, E.EmpLName, EmpMName, EP.EmpSSN, D.DeptName, EmpStatus FROM ...more >>

Hi, I have Table1 with an Id column and this is the primary key for this table. I have another table, Table2 which has an Id column which is a foreign key and references the primary key of Table1. Is there a way to bulk insert rows to both tables? Also can I use bulk insert if one of the co...more >>

I want to write a query to find an executing job. For instance I have a maintenance plan that runs weekly occasionaly the job hangs due to various problems that are out of our control such as network outages, server maintenance, etc.. Sometimes the operation folks don't talk to the administr...more >>

Someone refresh my memory. I am attempting to create a view. Assuming a conventional one-to-many header/detail relation between 2 tables, is there a way under sql to display in one line of view return, multiple records of one field of the detail table, each under a different alias and ea...more >>

Greetings, I need to select rows from tbl1 join tbl2 on t1.a = t2.a and t1.b =t2.b ... where the characters after the first 3 in the CompanyID column for tbl1 don't match the characters after the first 3 in the CompanyID column in tbl2. Here is my pseudocode. (pseudocode...) where sub...more >>

hi, i have a table with an index on a datetime field. i would like to query out all records with yesterday's date using the index. i did the following: DECLARE @dt_start VARCHAR(10) DECLARE @dt_end VARCHAR(10) SELECT @dt_start = CONVERT(VARCHAR(10), DATEDIFF(d, -1, GETDATE()), 110), @dt_...more >>

Is there a way in which I can programatically check the last time that an index was rebuilt/reorganized/updated statistics?...more >>

I am trying to calculate SUM()s by customer from our order tables; however, our ERP system has some values only at the line level, i.e., quantity, and others only at the header level, i.e., paid to date. I currently have two queries, one doing the sums at the header level: SELECT SUM(T0...more >>

Hi, need a general tip: I have an old .net program that pushes data to SQL Server 2000 using DMO objects (the ImportData method). I need to convert that to push to SQL 2005 . what are the best options? use SMO objects? create an SSIS package and use some objects to run it? (which objects?) shel...more >>

I am starting to learn writing Stored procedure by reading some examples. I am stuck when using quotes. Can someone give me some links to read about how to use them. An example: It is so confusing to me when I read a statement such as the following, where there are so many single quotes. ...more >>

1. Is it possible to set the filename for the report genereated for a job step inside the same job step (like if the report was first generated/Written upon completion of the step) ? update msdb..sysjobsteps Set output_file_name = 'E:\MSSQL\LOG\MyDatabase_' + @BackupDateTime + '.txt' Where ...more >>

Hi Everyone, i am using full text search with spanish sql. where i am running query with contains and the sign '*' in search i am getting the error: Server: Msg 7643, Level 16, State 1, Line 1 Your search generated too many results. Please perform a more specific search. i get the error ...more >>

Hello, I am Migrating one database of Mysql to SQL server 2005, I am facing problem with Views where in Mysql they have GROUP_Concat (aggregate Function) which is not available with SQL i found some solution on Google. 1. Use of Cursors (T-SQL) 2. Creating an functions. but again now i...more >>

how can i add blank line between @query1 and @query2? Thanks. **************************************** set @query0=@query1 + @query2 + @query3 exec master.dbo.xp_sendmail @recipients='abc@abc.com', @subject=@subjecttext, @query=@query0 ...more >>

I'm facing problem of designing DB, for not really "relative" data. Let's say there is some kind of object, which is described by it's primary attributes (identity data, some core characteristics), and some additional properties. The functional requirement is, that user should be able to ext...more >>

how to drop(delete) all store procedure from database? ...more >>

Any stored procedure can be used to export the database to a text file? ...more >>