15,917,455 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by RDBurmon (Top 200 by date)
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
Show More