Search results for query: *

Never mind got it. The error was a space in the var name in the Declare. Thank you

the FROM was a typo. I am getting a syntax error on line above the "SET NOCOUNT ON" line

Hi, I am new to T-SQL and I am trying to use "declare" in a stored procedure. I am getting a syntax error not sure why, any help appreciated. Here's the code :- ALTER PROCEDURE [dbo].[TOTALCOUNT] @StartDate DateTime, @EndDate DateTime AS BEGIN SET NOCOUNT ON; DEclare @TOTALPEOPLE int...

'[' was a typo. pls ignore. Query: SELECT COUNT(D1.*) AS [Col1] FROM Database1 AS D1 INNER JOIN Database2 AS D2 ON D1.CoL1 = D2.CoL1 Same error. thank you.

Here's the modified query minus the '[' bracket Query: SELECT COUNT(D1.*) AS [Col1] FROM Database1 AS D1 INNER JOIN Database2 AS D2 ON D1.CoL1 = D2.CoL1

Hi, I am trying to do the following query and I get a Syntax error Query: SELECT COUNT[D1.*) AS [Col1] FROM Database1 AS D1 INNER JOIN Database2 AS D2 ON D1.CoL1 = D2.CoL1 Error: incorrect syntax near '*' What am I missing. Thank you.

Thank you. So IF cannot be used at all in SELECT ?h

Can I use "IF" in a Select stmt e.g. SELECT Db1.Value1, IF (Db1.Value2 != 'good','bad','ok') FROM Database1 as Db1 I am getting a syntax error on IF any help appreciated.

Hi, I need to move a SQL server 2005 database nearly 9 GB to another machine on a different domain. What is the best way to do this ? I tried taking a backup then do a restore on the new machine and it failed with an "Access denied error". thanks for your help.

I am new to t-SQL and was looking for some help. Is there a way to display a "space" or Null value in a column when no data is returned for a query. E.g. If I run the query below SELECT EMPNAME, EMPMIDDLE Where EMPName='bob' When I run this query and if there is no Empname as 'bob' then at...

Can anybody tell me what is the best way to change the attribute value on a particualar node in a axml file ? Thank you. <Vehicle> <Cars> <Hybirds id='Toyota' cost='2500'>Available</Hybrids> <Hybrids id='Honda' cost='3500'>Available</Hybrids> </Cars> I want to change the value for cost where...

thanks, Brings me to another question, I want to display count of people passed and failed as two columns in a single table. Can you help?

Hi, I am new to TSQL and have a problem with temp tables CREATE TABLE #TCOUNT( PASSED INT, FAILED INT ) INSERT INTO #TCOUNT(PASSED,FAILED) VALUES (SELECT count(ID) FROM ExamResults er WHERE (er.[lastresult] = @mark1) AND ( er.[curresult] = @mark3 or er.curresult= @mark4 or er.[curresult]...

Has anybody used C# to register for Windows device events? I am trying to capture "CMP_WaitNoPendingInstallEvents" is there a way to do this in in C#. Any help appreciated.

I have a similar problem I am trying to return an integer <CODE> ALTER PROC [dbo].[sp_CheckIDExists] ( @id varchar(30), @RETURNVALUE int OUTPUT ) AS If (@id) Is NULL return 1 If EXISTS(SELECT ID FROM dbo.v_CI_DRIVERINFO WHERE ID= @id) @RETURNVALUE = 0 Else @RETURNVALUE = 1 return...

Thank you. Do you have any resources handy that I can use, I am looking on the net and so far, I have figured out the following :- 1. Recompile dll as COM - Soln: Select the "Register for COM" in Project Properties. How do I define which classes are COM visible? Thank you.

Thanx that worked.

How can I convert a C# dll to a COM object, so I can use it in VBScript or JavaScript. Thank you.

No change, same problem. Both the forms show up as blank white space like it is thinking something. Any other suggestions. how do I stop the processing until the Input form is clicked?

Here it goes :- <CODE> 1 - The Dll InputBox.cs namespace MsgBox { public class InputBox { private string _textValue; public string textValue { get { return _textValue; } set { _textValue = value; } } public...