Comments by RDBurmon - CodeProject

RDBurmon 23-Mar-18 2:51am View

perfect, if that worked then accept and vote the answer

RDBurmon 6-Mar-18 3:18am View

Are you trying the drive eject from code or manually?

RDBurmon 6-Mar-18 1:51am View

thanks

RDBurmon 5-Mar-18 2:35am View

try this one also
https://www.docusign.com/developer-center/dsa/local_02

RDBurmon 5-Mar-18 1:06am View

Thank you

RDBurmon 1-Mar-18 5:33am View

agree, it will prevent SQL injection

RDBurmon 1-Mar-18 2:37am View

Expiry date for what? about your software support ?

RDBurmon 27-Feb-18 2:52am View

you can accept and vote answer

RDBurmon 27-Feb-18 2:51am View

you can accept and vote the answer

RDBurmon 26-Feb-18 4:55am View

try other four tricks , how about cLng()?

RDBurmon 23-Feb-18 4:39am View

Are you trying to create multilanguage setup?

RDBurmon 23-Feb-18 4:38am View

ok , have you tried this -
http://documentation.installshield.com/robo/projects/helplib/IHelpSetup_EXECmdLine.htm

RDBurmon 23-Feb-18 4:36am View

thanks

RDBurmon 23-Feb-18 1:29am View

can you paste your connection string here?

RDBurmon 22-Feb-18 6:26am View

is this screen shot from your gridview? bcz I can see the order is correct as per values in NumeroCapitolo (1,1,2,2)

RDBurmon 22-Feb-18 6:02am View

which error? can you paste detail error message here?

RDBurmon 7-Feb-18 6:08am View

then how the data will go into the chart? Manually ? hard coded in to code?

RDBurmon 7-Feb-18 1:39am View

Should the total be 3800.00 (1000 + 800 + 900 + 1100) ?

RDBurmon 7-Feb-18 1:26am View

thanks

RDBurmon 22-Jan-18 1:19am View

No need to modify the trigger and that's why we are storing details in extra field (point #2), you need to write that trigger which will run the CRUD on the database using the connection details mentioned in that extra field, of course you need remote database connection and that's why we are adding remote server connection (point # 3)

RDBurmon 19-Jan-18 1:41am View

so you like to insert record in first table "df" with auto increment ID (suppose 1) and then would like to insert the record in second table "mf" with similar id like in table "DF" (which is also 1)

am I correct?

RDBurmon 18-Jan-18 6:33am View

updated my solutions. if worked please accept and vote

RDBurmon 18-Jan-18 6:32am View

ohh yeah , that should be +

RDBurmon 4-Jan-18 6:33am View

yes

RDBurmon 4-Jan-18 6:16am View

vote and accept if you like the answer

RDBurmon 4-Jan-18 6:15am View

see here , how processor and memory works while query execution
https://msdn.microsoft.com/en-us/library/ff647793.aspx

RDBurmon 21-Dec-17 1:45am View

what do you want to compare? just a table name or data inside that table

RDBurmon 20-Dec-17 1:03am View

If my understanding is correct then you want this type of audit
"In tableA , I have ran update query for EMP001 to update COUNTRY value from NA to INDIA" then audit should show "COUNTRY has been updated from NA to INDIA for EMPLOYEE EMP001"

correct?

RDBurmon 14-Dec-17 4:13am View

we can not see your code, don't have access to your system sorry
Do you want to smell coffee by looking Asam in india map :)

don't you think that you need to give us query details and other details here

RDBurmon 5-Dec-17 1:40am View

Can you give us some examples?

RDBurmon 5-Dec-17 0:41am View

What is the foreign key between these two table? I guess "Id" but I don't find any common IDs between table which which we can join and use the date field to make the calculation

RDBurmon 1-Dec-17 2:20am View

Do they contain same data sets? Can you give us some sample?

RDBurmon 1-Dec-17 2:20am View

do they have same columns?

RDBurmon 1-Dec-17 2:18am View

Hi , are you looking for any data import tool which your user can use to import data from excel to SQL without any hassle?
I have one with me, self developed - can guide you with this?

RDBurmon 28-Nov-17 1:36am View

by posting this as answer makes more sense to me, there are many open questions in this forum which submitter couldn't mark it as solved because no answer posted there

Trying to manage the queue in better way

RDBurmon 28-Jul-16 4:36am View

You can loop through the drid view and send SMS. I don't know the SMS API code/call/command. Here is sort of command you can use -

For each loop
CALL SenSMS gridview1.cells(rowindex,1).value , gridview1.cells(rowindex,2).value
Next

RDBurmon 27-Jul-16 2:49am View

Thanks, it worked

RDBurmon 27-Jul-16 1:46am View

send? where? in mail?
could you please elaborate more? May be one example of the output you would expected

RDBurmon 12-Jun-16 8:32am View

are you still looking for an answer?

RDBurmon 27-Feb-16 5:10am View

Hi MrAliv3, Is it VB.net or VB6.0?

RDBurmon 14-Feb-16 9:18am View

Deleted

are you processing any action/steps in ControlFile under the for loop? If yes then

RDBurmon 13-Feb-16 22:41pm View

Is use of Powershell mandatory in task? If I had the same exercise then I would have achieved it using C#. Let me know if that works for you. I know how to achieve this through C#

RDBurmon 13-Feb-16 22:38pm View

its very risky to add row in database on each click of combobox
just imaging what would happen if user clicks the combobox multiple times then table would have multiple entries. isn't it? The best way to achieve this scenario is add a "Update/SAVE" button and write code on button click event.

So user will add as much entries in to data grid view as they want and click on button to save the value to the database

RDBurmon 13-Feb-16 3:00am View

are you getting any error?

RDBurmon 12-Feb-16 22:45pm View

where you want row to be added? in database or in datagrid view?

RDBurmon 12-Feb-16 21:49pm View

Sql server reporting needs separate license. Why don't you use Visual Studio data report
Its free and easy unless you have to do some advance reporting

RDBurmon 11-Feb-16 9:07am View

execute the FillComboCenter() function on SelectedTextIndexChanged event
See this -
https://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.selectedindexchanged(v=vs.110).aspx

RDBurmon 11-Feb-16 8:06am View

Are you getting any error? Have you tried to run the above code?

RDBurmon 7-Feb-16 8:34am View

and the question is........................

RDBurmon 7-Feb-16 8:31am View

CP , I have updated your question and added the perfect answer for you. Having said that, read my updated question carefully and that will help you to understand how to ask question in CP portal

RDBurmon 6-Feb-16 23:36pm View

are you still looking for an answer?

RDBurmon 6-Feb-16 22:10pm View

Great solution but it only answers half of what CP asked

RDBurmon 1-Feb-16 5:17am View

Thanks, you can vote the answer if you like it

RDBurmon 31-Jan-16 22:23pm View

See this link -
http://stackoverflow.com/questions/10685999/how-to-get-filename-with-timestamp-in-ssis

RDBurmon 31-Jan-16 10:23am View

where you want this be displayed to?

RDBurmon 31-Jan-16 4:42am View

Sorry, It was again my mistake

See the updated proc in answer

RDBurmon 29-Jan-16 23:18pm View

Sorry, It was my mistake. See the improved answer now

RDBurmon 29-Jan-16 7:57am View

See the updated answer above

RDBurmon 28-Jan-16 6:52am View

Read this document-
http://www.oracle.com/technetwork/database/availability/ha-oracle12c-sqlserver2012-2049933.pdf

RDBurmon 28-Jan-16 0:39am View

Hi Ravi,

Provide the tabular data which will be helpful to understand I guess

RDBurmon 28-Jan-16 0:15am View

Give me your data in FeeAssigned and FeeExemption tables

RDBurmon 26-Jan-16 11:39am View

ok got it, Are you using database?

RDBurmon 26-Jan-16 9:43am View

I understand your question and has implemented in my previous projects
quick question - Do you want this feature in your website or desktop app or any thing which can pop up reminder on system?

RDBurmon 24-Jan-16 8:01am View

Do you want to concatenate all three rows into single value? If yes then I am confused bcz as per concatenation rule "9420" should be there after "9502"

Isn't it?

RDBurmon 6-Jun-15 9:57am View

Good answer!! My five

RDBurmon 27-May-15 23:01pm View

Is your query resolved? I have implemented similar solution so can guide
Let me know

RDBurmon 27-May-15 12:37pm View

If this does work then accept the my answer as solution so that your case can be marked as closed

RDBurmon 26-May-15 14:11pm View

I have created the small project to demonstrate my suggestion. There is no option to attach file here so I have uploaded my project on this site -
Download the project and implement the same with your project. I have only considered 8 columns but you can implement the same with 2000 columns
Link 1 :
http://www.filedropper.com/994781how-can-i-divide-large-excel-csv-file-and-stored

If doesn't work then try this -
Link 2
http://s000.tinyupload.com/?file_id=75711810551485871114

RDBurmon 15-Jun-14 2:37am View

Isn't you excel has fixed sequence of columns?

RDBurmon 1-Jun-14 2:35am View

agreed :)

RDBurmon 1-Jun-14 2:34am View

Hope my solution works for you. :)

RDBurmon 1-Jun-14 2:29am View

My +5

RDBurmon 1-Jun-14 1:09am View

:) my +5

RDBurmon 1-Jun-14 1:08am View

Hope this helps :)

RDBurmon 30-May-14 11:31am View

perfect solution +5

RDBurmon 30-May-14 11:30am View

+3

RDBurmon 30-May-14 11:30am View

my +5

RDBurmon 30-May-14 11:30am View

good explanation

RDBurmon 30-May-14 11:29am View

:)

RDBurmon 30-May-14 11:28am View

good solution

RDBurmon 30-May-14 11:27am View

perfect +5

RDBurmon 30-May-14 11:23am View

Its not that easy. Search for any third party tool, DLL

RDBurmon 30-May-14 11:22am View

+5

RDBurmon 30-May-14 11:21am View

Probably, you have to read this document and try to co-relate your code with the methods specified in the blog

RDBurmon 30-May-14 11:20am View

:) +5

RDBurmon 30-May-14 11:19am View

good explanation. My +5

RDBurmon 30-May-14 10:23am View

Or share content which are there in app.xaml

RDBurmon 30-May-14 10:19am View

Do explain you query using some examples or code

RDBurmon 30-May-14 10:06am View

not clear
Can you some example or code may be?

RDBurmon 30-May-14 10:06am View

Please explain your problem in short

RDBurmon 30-May-14 10:05am View

OP, this type of solution can be found on www.google.com with very easy search. Please search before posting question

RDBurmon 30-May-14 10:01am View

what is an error??

RDBurmon 30-May-14 10:00am View

whats the error??

RDBurmon 30-May-14 10:00am View

Can you share App.xaml file ?

RDBurmon 30-May-14 8:58am View

Can you post code here? so that we can understand what you have tried so far

RDBurmon 30-May-14 8:54am View

First tell us what you have tried so far, don't expect spoon feeding

RDBurmon 27-May-14 9:24am View

http://www.codeproject.com/Questions/177747/Show-Image-in-Listview-retrieve-from-database-in-A

RDBurmon 25-May-14 10:18am View

Alisha , Can you predict smell of coffee by seeing "ASAM" in indian map ?
We are CP member not astrologers.

RDBurmon 25-May-14 10:17am View

:)

RDBurmon 25-May-14 10:16am View

:)

RDBurmon 25-May-14 10:16am View

:)

RDBurmon 24-May-14 2:23am View

Does table "AllAssetSurveyReport" have any indexes?

RDBurmon 20-May-14 10:06am View

Thanks. Please accept the answer

RDBurmon 19-May-14 13:33pm View

insert some example of xml value and the result that you are expecting

RDBurmon 17-May-14 2:52am View

I have updated question with script that I am using
Could you please suggest what I am doing wrong? With this code , I am able to display subreport in main report
But it doesn't show any data

RDBurmon 14-May-14 14:03pm View

What is your source for this report? Revert back with
1) table structure
2) Sample data if you could post

RDBurmon 14-May-14 13:58pm View

Hi Jinu,
just checking with you , If you could help me for my query. I am new in crystal report development
Any help would be appreciated
here is my question link
http://www.codeproject.com/Questions/772444/How-do-I-display-two-different-query-results-in-tw

RDBurmon 14-May-14 13:55pm View

These links would be enough to understand the concept
Sp_oacreate
http://technet.microsoft.com/en-us/library/aa238863%28v=sql.80%29.aspx
Sp_oadestroy
http://technet.microsoft.com/en-us/library/ms173866.aspx
sp_OAMethod
http://technet.microsoft.com/en-us/library/ms174984.aspx

But if still you need any information then reach out to me with an example where you want to use these function :)

RDBurmon 13-May-14 15:00pm View

Thanks, I have to attach data source to this subreport using C# so Do I need to update dataset in first report or in second report
in any case how I can bind data set to the subreport?

RDBurmon 13-May-14 14:57pm View

Do you need to update
1) Many addresses in many tables
Or
2) Many addresses in one table

RDBurmon 13-May-14 14:21pm View

I have totally different format for both results
1) In first result, I need to show only 3 columns
2) In second result, I need to show 6 columns

Could you please let me know how to show two different tables in crystal report?

RDBurmon 12-May-14 14:59pm View

I tried to create another crystal report and added that as subreport in main crystal report
but it didn't show result in subreport
I can see lable values but couldn't see any data

RDBurmon 1-May-14 11:12am View

Provide answer to below questions to understand your query and give you solution
1) How many columns are there in source tables?
2) Do you want to UNION all three tables and dump it to destination table?
4) Or do you want to concatenate each row value to respective row values from other two tables in source database and then dump into destination table?

RDBurmon 1-May-14 10:55am View

Hi mikeoabban,
I suggest you to place bookmark at line "StrQuery = @"INSERT INTO...." (Line where your store insert query into StrQuery variable
then run your code and see the value of StrQuery variable when error occures

Post the value of StrQuery variable here. I would like to debug that

RDBurmon 30-Apr-14 9:19am View

So Is this resolved your query? Do you have any other query?
I would like to help you.

RDBurmon 26-Apr-14 23:10pm View

I don't think we can use SQLParamer with Access database. Can we?

RDBurmon 19-Sep-13 7:34am View

Is you sheet contain only one date value or multiple date values ?

RDBurmon 17-Sep-13 1:52am View

Sure . I am happy to help you in this regard. Send me mail on itsmekitanjal at the rate rediff mail dot com

RDBurmon 17-Sep-13 1:50am View

Thanks Mubin

RDBurmon 6-May-13 8:19am View

Thank you. I understood first part.
Could you please explain me below statement using code ?
"From that collection you can update any record. if no records for your criteria u can directly add that row into the datatable."

RDBurmon 17-Apr-13 2:45am View

I am sorry , I don't know about this term . I just need one detail grid where I can show this details as well as image in last column which will be refresh in every 10 mins

RDBurmon 17-Apr-13 2:22am View

See this :
http://www.imagecross.com/d/image-hosting-view-02.php?id=4825Listview.png

RDBurmon 29-Mar-13 7:47am View

Could you please give me one example ?

RDBurmon 3-Mar-13 23:43pm View

Do you want to save those 100 values in one single row of database table ?
or 100 rows where each value in each row

Give me your "Symptom" table structure to understand your problem better ?

RDBurmon 3-Mar-13 10:48am View

Did you setup ROWCOUNT before ran this procedure ?

RDBurmon 3-Mar-13 6:22am View

Why ?

RDBurmon 3-Mar-13 6:21am View

You are correct it should display information.
Thanks for sharing what you are doing in life.

By the way How did you come here .......

RDBurmon 3-Mar-13 6:18am View

Can you add some live example ?

RDBurmon 3-Mar-13 6:17am View

Sumeet Kumaar G ,
This is not a project guidance forum. You have start with your project in whatever language you want and if you stuck in some particular point then ask CP member to help you by providing right solution and CP member does.

So let delete this post and start your project and will see you in next post where you would ask for help.

Hope this helps to understand this forum
--RDBurmon

RDBurmon 3-Mar-13 6:13am View

Welcome

RDBurmon 28-Feb-13 8:04am View

Is this in any file ?

RDBurmon 27-Feb-13 4:12am View

And error is ......
To be continued..

RDBurmon 27-Feb-13 4:11am View

You have to add some more details in your question ? use IMPROVE QUESTION option to do this

RDBurmon 27-Feb-13 4:06am View

Why you always want debate ? instead of just provide answer if you know

RDBurmon 27-Feb-13 3:47am View

What you have tried by using code in above blog ?

RDBurmon 26-Feb-13 2:18am View

Good explanation

RDBurmon 26-Feb-13 2:07am View

Could you please provide image of your form to get more clarity on your searching method ?
You can upload your image in free image hosting site and paste a link here

See this http://postimage.org/

RDBurmon 26-Feb-13 2:03am View

Sumit : What was value of Lable12.text when you received an error ?

RDBurmon 26-Feb-13 1:58am View

Cesitar Ps : take some effort to explain your problem with some more word. It will have more clarity

RDBurmon 26-Feb-13 1:57am View

Post you code

RDBurmon 26-Feb-13 1:07am View

I will help you. Provide detail information on what exactly you want

RDBurmon 25-Feb-13 12:33pm View

Please add some examples in your question.

RDBurmon 25-Feb-13 12:31pm View

What does it mean "The full path character is exceeding 255 character" ?

RDBurmon 25-Feb-13 12:15pm View

are you using any database to store state and district ?

RDBurmon 25-Feb-13 6:47am View

select data_type
from information_schema.columns
where table_schema = 'myschema'
and table_name = 'mytable'
and column_name = 'mycol'

RDBurmon 25-Feb-13 6:35am View

You asked Sandeep207 for query changes which will give you information about only one column
that changes you can see in my solution.

RDBurmon 25-Feb-13 4:44am View

See my solution

RDBurmon 25-Feb-13 1:30am View

Dear AnnuBhai ,

Lots of solutions you have now, see below
Create your solution by reading all these suggestion and post your final code here so that everyone can understand what you have done to resolve this.

RDBurmon 23-Feb-13 0:56am View

Can you share you code ?

RDBurmon 23-Feb-13 0:54am View

Any way you did it and worked for you.
Accept and close this solution

RDBurmon 23-Feb-13 0:53am View

Yes XML nodes are case sensitive

RDBurmon 21-Feb-13 2:17am View

From where is "RS!Id" coming in the first line of code?

RDBurmon 13-Feb-13 5:59am View

Which language are you using ? C# or VB.net

RDBurmon 8-Feb-13 0:35am View

Post your error which dot net gave you

RDBurmon 8-Feb-13 0:28am View

Post your code

RDBurmon 8-Feb-13 0:16am View

There is no such functionality available.
you have to make it manually

RDBurmon 7-Feb-13 4:21am View

Agreed. I would have given 5+ vote if feature available

RDBurmon 7-Feb-13 4:09am View

Don't shout . Capital words means shouting

Read this before posting any query
Does typing a word in all capital letters mean your yelling?

RDBurmon 7-Feb-13 0:49am View

are you using any database to store item prices ?

RDBurmon 6-Feb-13 2:21am View

Is this related to code ?

RDBurmon 6-Feb-13 2:02am View

Start the SQL profiler and run this report and see what query you received in profiler.
then run this query manually and see if you get result from sql database.

RDBurmon 5-Feb-13 4:18am View

and the problem is....

to be continued.....

Waiting for second episode

RDBurmon 5-Feb-13 3:48am View

avmvijay , Can you predict smell of coffee by seeing "ASAM" in indian map ?
We are CP member not astrologers.

RDBurmon 5-Feb-13 1:46am View

It will increase my points

RDBurmon 5-Feb-13 1:21am View

Gr8 then please accept my solution and vote it

RDBurmon 5-Feb-13 0:46am View

Hello Minnu Sanju ,

Read below solution and if works accept and close this question.

RDBurmon 4-Feb-13 23:58pm View

Post your code here and mark the error line.

RDBurmon 4-Feb-13 1:46am View

I have commented obj.close in my solution. Try now

RDBurmon 4-Feb-13 0:16am View

and error is..............

to be continued..

Waiting for second episode

RDBurmon 3-Feb-13 23:12pm View

I have updated solutions. Add MultipleActiveResultSets=True; in connection string and try again

RDBurmon 1-Feb-13 8:17am View

Yes you can . Reread blog from link given by me in above solution.
Or search on google how to export ssrs reoprt using Querystring(Providing parameter and report name in the link itself)

RDBurmon 1-Feb-13 8:04am View

Yes we can . See my updated solution

RDBurmon 1-Feb-13 7:35am View

As you have exported this into PDF on some drive . Then as using SQL Database mail you can mail this pdf as attachment to multiple users and you can schedule this job to run after your package run

RDBurmon 1-Feb-13 7:32am View

Ok remove SET and run it . If you get any error then paste your code and tell me which line throwing error.

RDBurmon 1-Feb-13 5:28am View

See my updated solution

RDBurmon 1-Feb-13 1:47am View

Read this from exporting ssrs report in pdf using ssis

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/7adb2621-f95a-4abf-9b41-141d9caab298

RDBurmon 1-Feb-13 1:46am View

Updated my solution . Try now

RDBurmon 31-Jan-13 10:30am View

I have updated my answer . Try it.
I am online for next an hour.

RDBurmon 31-Jan-13 7:18am View

Yes put it back and see what happen.

RDBurmon 30-Jan-13 6:10am View

Try this

DECLARE @STARTDATE AS DATE;
DECLARE @EntDt AS DATE;

SET @STARTDATE = '06/01/2012';
SET @EntDt = '12/31/2012';

DECLARE @dcnt AS INT;;

WITH DateList
AS (
SELECT convert(VARCHAR(15),@STARTDATE,101) DateValue

UNION ALL

SELECT convert(VARCHAR(15),DATEADD(dd,1,DateValue ),101) DateValue
FROM DateList
WHERE convert(VARCHAR(15),DATEADD(dd,1,DateValue ),101) < convert(VARCHAR(15), @EntDt, 101)
)
SELECT DateValue
FROM DateList;

RDBurmon 30-Jan-13 5:52am View

Image

RDBurmon 30-Jan-13 5:49am View

Try this

DECLARE @STARTDATE AS DATE;
DECLARE @EntDt AS DATE;

SET @STARTDATE = '06/01/2012';
SET @EntDt = '12/31/2012';

DECLARE @dcnt AS INT;;

WITH DateList
AS (
SELECT @STARTDATE DateValue

UNION ALL

SELECT convert(VARCHAR(15),DATEADD(dd,1,DateValue ),101)
FROM DateList
WHERE convert(VARCHAR(15),DATEADD(dd,1,DateValue ),101) < convert(VARCHAR(15), @EntDt, 101)
)
SELECT DateValue
FROM DateList;

RDBurmon 30-Jan-13 5:41am View

Amrutha , I just you to improve question with some better word include some more examples

RDBurmon 30-Jan-13 5:35am View

I don't have SQL 2008 to validate

DECLARE @STARTDATE AS DATE;
DECLARE @EntDt AS DATE;

SET @STARTDATE = '06/01/2012';
SET @EntDt = '12/31/2012';

DECLARE @dcnt AS INT;;

WITH DateList
AS (
SELECT @STARTDATE DateValue

UNION ALL

SELECT convert(VARCHAR(15),DateValue + 1,101)
FROM DateList
WHERE convert(VARCHAR(15),DateValue + 1,101) < convert(VARCHAR(15), @EntDt, 101)
)
SELECT DateValue
FROM DateList;

Try this

RDBurmon 30-Jan-13 5:06am View

DECLARE @STARTDATE AS DATE;
DECLARE @EntDt AS DATE;

SET @STARTDATE = '06/01/2012';
SET @EntDt = '12/31/2012';

DECLARE @dcnt AS INT;

;WITH DateList
AS (
SELECT @STARTDATE DateValue

UNION ALL

SELECT DateValue + 1
FROM DateList
WHERE DateValue + 1 < convert(VARCHAR(15), @EntDt, 101)
)
SELECT DateValue FROM DateList;
Try this

RDBurmon 30-Jan-13 3:19am View

Remove ; and then try

RDBurmon 30-Jan-13 2:29am View

Try this
DECLARE @STARTDATE AS DATE;
DECLARE @EntDt AS DATE;

SET @STARTDATE = '06/01/2012';
SET @EntDt = '12/31/2012';

DECLARE @dcnt AS INT;

WITH DateList
AS (
SELECT @STARTDATE DateValue

UNION ALL

SELECT DateValue + 1
FROM DateList
WHERE DateValue + 1 < convert(VARCHAR(15), @EntDt, 101)
) ;

RDBurmon 30-Jan-13 2:27am View

Deleted

DECLARE @STARTDATE AS DATE; DECLARE @EntDt AS DATE; set @STARTDATE = '06/01/2012'; set @EntDt = '12/31/2012'; declare @dcnt AS int; with DateList as ( select @STARTDATE DateValue union all select DateValue + 1 from DateList where DateValue + 1 < convert(VARCHAR(15),@EntDt,101) ); --INSERT INTO mtblAttendance --select u.User_Id, --Convert(VARCHAR(10),CONVERT(DATETIME,CONVERT(VARCHAR(10), DateValue, 121)) + ' 09:30:00', 121) As In_Time, --Convert(VARCHAR(10),CONVERT(DATETIME,CONVERT(VARCHAR(10), DateValue, 121)) + ' 09:30:00', 121) As Out_Time --from DateList, mtblEmployee u --where DATENAME (dw, DateValue ) not IN ( 'Saturday','Sunday' ) --option (maxrecursion 365); shows error Incorrect syntax near ')'.

RDBurmon 30-Jan-13 2:27am View

Attach image

RDBurmon 30-Jan-13 2:25am View

not comma try (;)

RDBurmon 30-Jan-13 2:20am View

attach image

RDBurmon 30-Jan-13 2:16am View

Ok then comment out last sentence also and put comma before Insert . rerun and revert back

RDBurmon 30-Jan-13 2:05am View

Uncomment last line and try

RDBurmon 30-Jan-13 1:51am View

Comments "Insert statement" and try to run

RDBurmon 30-Jan-13 1:49am View

Deleted

Hello Raji......,
One of our CP member provided good solution to you . Please go through it.
Accept if helps otherwise revert back.

RDBurmon 30-Jan-13 1:12am View

What is type of "DateValue" in DateList table ?

RDBurmon 30-Jan-13 1:06am View

Hello Madhu ,

One of CP member has provided good link.Please go through it and if works then accept and mark this question as 'SOLVED'

RDBurmon 30-Jan-13 0:17am View

Thanks

RDBurmon 30-Jan-13 0:15am View

Try now and if any problem share the image by same method

RDBurmon 29-Jan-13 6:43am View

Try now

Comments by RDBurmon (Top 200 by date)