Hi,

I think you can used the stored procedure SP_WHO, SP_WHO2 to identified how many users.

I hope this will slove your problem

Hi,

The problem in your code is that you declare the variable for the date as varchar. By default if you did not specify the length of the varchar parameter then...

have a look on this artical to get the IP address using the TSQL...

http://www.sqlmag.com/articles/index.cfm?articleid=48303&

Hope this will slove your problem.

Hi,

You should need to use the SQL  transaction in this SP and check either the sp_password generate the error and not if it generate then roll back the transaction otherwise...

Sorry, but the code in the union class also need the same modification. I think you have got the problem... when ever you need to concate a string and numeric...

Hi ,

as you are using the field SupplyGroupSeqID  which indicate and interger value and can not be concate with string. you need to convert this...

Hi,

ALTER Procedure [dbo].[INSERT_Header]

(

 @admin_menu_id int,

 @admin_submenu_id int,

 @header_file varchar(150),

 @header_alt varchar(150),

 @header_caption varchar(200),

 @language_id int,

 @fk_header_id int OUTPUT,

 @outid int OUTPUT

)

AS

BEGIN

-- Insert the into headers --

 INSERT INTO [headers]

  (

   [header_file]

  ,[fk_admin_menu_id]

  ,[fk_admin_submenu_id]

 &nbsp

 VALUES

  (

   @header_file

  ,@admin_menu_id

  ,@admin_submenu_id

 &nbsp

Hi,

select distinct customerID , eventtext from tblCustomer C

where eventtimestamp = (select Max(eventtimestamp) From tblCustomer where customerID = C. customerID )

Hope this will slove your problem

Hi,

Have a look on the transaction log file and check that it has the enough space. I think its due to the transaction log file.

Take the backup of transaction long...

Hi,

I can't understand why you are using the like to compare the date field. You should used the equal operater then the performance will significally improve.

Other thing is that...

Hi,

Bellow is the code to get the return value from dyanamic SQL

DECLARE @SQLString NVARCHAR(500)

, @ParmDefinition NVARCHAR(500)

, @Lastlname varchar(30)

SET @SQLString = N' SELECT @LastlnameOUT = Name FROM...

Hi,

Use the bellow query, If the data exists then surly it will return your required result.

SELECT     p.product_id, p.special_offer_id,

  bikes.bike_id, bikes.bike_model, bikes.bike_description, bikes.bike_online, bikes.bike_cc, bikes.bike_price_pounds, bikes.bike_price_pence, bikes.bike_description,

  parts.part_id, parts.part_name, parts.part_description, parts.part_price_pounds, parts.part_price_pence, parts.part_online

FROM      ...

hi,

used the builtin funtions LTRIM, RTRIM to trim the extra spaces on the left or right side.

hope this will slove your problem

thanks

ijaz

Hi,

This need to create a new table changing the identity column to your requirement and migrate the data from the old one.

Here is sample script for this.

CREATE TABLE dbo.Table1

 (

 id int identity(1,1)...

Hi,

You should used the between operator used to compare date.

Declare @Date varchar(30),

SET @Date = '20061024'

you can used any date which fulfill your requirement.

WHERE FieldName Between @Date + '05:05AM' AND...