Search results for query: *

Hi I need to export just the app roles from one db to another... please is urgent !!!!! thanjk a lot...

I have a DB mssql server 2000 that works with application roles. I need to read some data from an asp.net page, but I don't know how. I know this is not the correct forum, if somebody can help me, it will be great. regards. cmn

because I've to add some business rules to that query, something like this: SET @STRING='SELECT COUNT(*) FROM MY_TABLE ' IF @PARAMETER=1 SET @STRING=@STRING + 'WHERE FIELD1 IS NULL' ELSE SET @STRING=@STRING + 'WHERE FIELD1 IS NOT NULL' thanks for answer me Regards

Hi dear friends !!! I need obtain a return value from a function. In this function, I work with a query built dynamically, from which I get the value. So the thing is: DECLARE @X INTEGER DECLARE @STRING NVARCHAR(4000) SET @STRING='SELECT COUNT(*) FROM MY_TABLE' EXECUTE(@STRING) i need to...

Hi, I've a table with a IDENTITY column, when I execute "SELECT IDENT_CURRENT('mytable')", this statement returns 161. Now I wanna change this value (for example,to 100). I'm sure you masters have an answer for this. Thanks in advance Regards

Hi, I've some Sql code with a INNER JOIN for two tables. I put this code inside a Stored Procedure. This SP has 2 parameters (varchar both) that work like filters. When I run the SP sending the parameters, this takes up to 2 minutes for the results. When I execute the same code but now with 2...

I wanna make a report in Crystal Reports 4.6 using a store procedure from SQL SERVER 2000 as datasource. This SP was made with dinamic code, and has 4 paremeters. At the end of the SP, I wrote "EXECUTE(string)", executing the code. In the Query Analizer(SQL S 2000) I don't have any problems, but...

hi, i have a problem with my sql server connection. we have some .net aplications running over SQL SERVER 2000 and Windows 2000. Sometimes, I get this error message: "Cannot generate SPPI context" when i wanna open the query analyzer. The same thing occurs with this aplications, the conection is...

hi everybody, I've the next statement: SELECT DATEDIFF(YY,'1977-11-15',GETDATE()) The difference between the 2 dates, in years, should be 27, but it returns 28. ¿ what's going on ? Regards

hi, I need to print from a vb.net form directly to my printer ( dot style). I wanna print a lot of data, and don't need a page jump in every page I make. I try with the 'printdocument' object ( graphics.drawstring...) without success. Thanks in advance

hi, you can copy and replace a DTS package using a "dts package". you can find all details in: http://www.sqldts.com/default.aspx?204 Regards, Cmn

hi, you can't update a view if in the "select" statement you have a "TOP" clause... regards, cmn

ok, I get this help from Books on line: SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions so I do the same, but I ignore what means the "...xactions" part. I guess this is the...

hi, I've a problem with the OPENDATASOURCE function. I wanna open a .xls file on QA but just can't do it. ¿ anybody with a idea or solution ? a lot of thanks in advance. Regards, CMN

hi, can you write a example ? something like "I have this record.... and wanna get this..." regards, Camaleon CHILE

I've copied de backup file to another server and I have the problem there.... thanks in advance atte CamaleON CHILE

hi everyone, i need some help urgently....the situation is this: I've made a backup of my database in the Enterprise Manager, but when I want to restore it in another machine, it said that the "back up is off line or there is a device error".... ¿ what i'm doing wrong ? any suggestions will be...

Sonya: calling a SP into another SP is a good way to perform a task, so you are rigth. In this example in particular, you should try the next code in the "if exists" part: IF EXISTS(select b_sNME FROM table2 WHERE (UPPER(b_sNME) = @sNME) AND (b_cID= @cID)) BEGIN UPDATE table3...

Lonnie, I'm not sure about what you want, anyway in SQL SERVER 2000 exists a tool named 'DTS' where you can write code in vb or vbscript ( DTS was designed for data migration). If you want more info, click this www.sqldts.com regards cmn

I hope be a help for you, regards cmn try this: SELECT TIME_IN,TIME_OUT,(DATEDIFF(minute,TIME_IN,TIME_OUT)/15)/4 AS HOURS, DATEDIFF(MINUTE,DATEADD(HOUR,((DATEDIFF(minute,TIME_IN,TIME_OUT)/15)/4),TIME_IN),TIME_OUT) AS MINUTES, TOTAL_TIME=CASE WHEN...