Comments by N Haque - CodeProject

N Haque 9-Apr-14 0:16am View

Deleted

No number no need to consider.

N Haque 11-Jul-13 7:00am View

If you have stateid--statename and countryid then no need to join any where to insert your data. Just write insert statement. If you don't have countryid but have country_name then you need select query to select countryid. Please clarify you question.

N Haque 29-Jan-13 8:53am View

you can try this-
DataTable dt = new DataTable();
// dt=Your DataTable;
DataSet ds = new DataSet();
ds.Tables.Add(dt);
oDocument.SetDataSource(ds);

N Haque 23-May-12 5:06am View

Thanks for your suggestion. But I can’t change existing dll right now.

N Haque 23-May-12 5:06am View

Thanks for your suggestion. But I can’t change existing dll right now.

N Haque 13-Mar-12 9:07am View

you do not need to run loop for that. you can get all rows using UNION

select * from PollingBooth_A
UNION
select * from PollingBooth_B

And then just do sum by party_id.

See Solution 5

N Haque 13-Mar-12 8:38am View

I think It will be working..

N Haque 28-Feb-12 7:34am View

You use 1 not 2 as 3rd Parameter.
Like the following-
declare @RE AS binary(32)
Set @RE =0x0101010101010100000000000000000000000000000000000000000000000000
SELECT SUBSTRING( convert(nvarchar(32), @RE,1),3,LEN(convert(nvarchar(32), @RE,1)))

I have got The following result :-
010101010101010000000000000000

N Haque 28-Feb-12 7:00am View

Sorry You have to convert the binary to String
Try it -

select 'Your binary data is : ' + SUBSTRING( convert(nvarchar(32), @Binval,1),3,LEN(convert(nvarchar(32), @Binval,1)))

OR

Declare @binString nVarchar(32)
Set @binString=convert(nvarchar(32), @Binval,1)
select 'Your binary data is : ' + SUBSTRING( @binString,3,LEN(@binString))

N Haque 28-Feb-12 4:27am View

is "Employee Status" string fixed or not considerable? Can I consider only the [**] third bracketed word??

Comments by N Haque (Top 10 by date)