Database

you are wellcome

friendly now iam reading microsoft training kite 70-448 book. http://www.4shared.com/document/3-NC18pi/MCTS_70-448_Training_Kit_MS_SQ.htm[^] i hope it will help you. :rolleyes: modified on Thursday, April 21, 2011 5:15 PM

Why? I would suspect there isn't one. If you are attempting SQL independence that means you can't use stored procs and must be using another language to wrap it, so just use that language to extract the month. If using in a where clause then construct an appropriate timestamp value that represents a month range. This has the advantage that it is probably faster as well.

You could possibly get and store the date before opening the file and restore it after closing. But I doubt it's worth the trouble.

Filip Dossche wrote: but I wanted to do it with less code if it was possible Just to be clear (it wasn;t explicit from my original post), that I had shown the code for a User Defined Function (UDF), and therefore this code would be written once, and not repeated every time you needed this logic. Thereafter, the usage would be as simple as SELECT * FROM Whatever WHERE date>dbo.FloorDate('DD',GetDate()) or perhaps INSERT INTO somewhere (someInfo,someDate) VALUES ('abc',dbo.FloorDate('DD',GetDate()))

Yes this is not much helpful for me . i am tring SSIS Package to do so. Can anyone help me on topic "SSIS Package for Importing XML files"?

Move your sub query from the join to the select and add the mandateID to the where clause. This can be repeated for different feature types. Caveat this type of sub select can be very slow and expensive. Another way would be to left join out to the feature table multiple times (1 for each feature type) using a case statement on the if field (case featureid when is null then 0 else 1 end), group by your mandate fields and sum each feature field. Another way is to use the same multiple joins and then pivot the rows so each feature is in it's own column. Never underestimate the power of human stupidity RAH

Thanks Holmes, you're absolutely right, actually, I never used the designer when it comes to database programming and this's exactly why I'm asking now.. Guess I'll just have to forget about the designer.. I thought if it will make my life easier, why not to go for it.

Ugh, I had too much faith in the admin. I moved the files for my Database to the E drive with enough space. He had a C drive as the OS drive with only 12 gig, and a D drive that was, from my understanding, supposed to be for programs, including SQL. The clown admin installed SQL to the system C drive with very limited space. It turns out the temp table and log files were getting full, jamming up the OS/SQL D: drive. I should say that this definitely is not my fault, as I don't remote to the machine ever, just use SQL Server Management Studio. So there was no way for me to be worried about it, or know about it even. Craigslist Troll: litaly@comcast.net "I have a theory that the truth is never told during the nine-to-five hours. " — Hunter S. Thompson

The “ORA-01033: ORACLE initialization or shutdown in progress.” error can also happen when Oracle is attempting startup or shutdown and is "hanging" on a resource such as a failed disk, writing to redo, etc. Wait for few minutes and retry.. If after few tries it comes, restart your machine. ♫ 99 little bugs in the code, 99 bugs in the code We fix a bug, compile it again 101 little bugs in the code ♫

Luc Pattyn wrote: Pick the correct join: Visual Representation of SQL Joins[^] Gr8..entry for SQL Join, It's really helpful to understand SQL join. Thanks Md. Marufuzzaman I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

I think you need to be more specific, cause your above scenario probably not indicate the actual issues. Thanks Md. Marufuzzaman I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Thanks, it works fine now.. I just had to reinstall VS!!

I have develop 3 binary tree related package. ( MLM and Microfinance). Just try to put Parent Id and thats enough to proceeds.. And if u have left right combination is there then put Position with varchar. which ontain Only R or L ( for left or Right.

Thanks! That sounds like what I need :) Small clarification for posterity: Each LAN installation has one databas and several C#-clients. THis installation is then done on several LANs.

Yes it is. And since it's native for Sql Server, I'd say you have lot's of opportunities when you play with it :) The need to optimize rises from a bad design.My articles[^]

Glad to hear you got it resolved! The need to optimize rises from a bad design.My articles[^]

read complete summery of this question. Do't waste your time in Closed Questions. If you can think then I Can.

http://guru-code.blogspot.com/[^] Its a very good blog . Select Sqlserver from the tab.