Hi Anil, quote: I am trying to migrate to SQL Server from Oracle and I have trouble finding an equivalent to ROWNUM (Oracle) in SQL Server. Is it possible in SQL Server 2000 to number the result set in a sequence? same topic as in a different category. Crosspost? Cheers, Frank
2003-07-21
1 reads
create table test(Account int, fMonth int, PTDDebit int, YTDDebit int) insert test select 10001 ,01, 100,null union all select 10001 ,02, 150,null union all select 10001, 03 ,200,null union all select 10002, 01, 200,null union all select 10002,02 ,300,null union all select 10002, 03, 350 ,null go create view view1 as SELECT a.fmonth, a.account, a.PTDDebit, […]
2003-07-18
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-18
Here I think this is right. quote: EIGHTBALL 'Eightball' is a highly uncomplimentary slang word standing for a rather objectionable character ('gold brick', 'goof'). The word owes its origin to the billiard game where the number 8 ball has some restrictive associations which make it an object of disapproval. Namely, in a pocket billiard game, […]
2003-07-18
1 reads
I can get to Call type. The problem is, if I don't use count I get duplicate records; in One field I get call type and in another eventdate (I am doing a count on event_date). Some how I have to merge records in one field getting columns from other rows that’s what I am […]
2003-07-17
Hello Chris, quote: Is it possible, within T-sql, to name a variable or key and include the value of another variable within that name. I imagine the code may look something like this: set @myvar = 'new' alter table mytable add constraint fk_+@myvar foreign key (col2) references myothertable(col3) should be possible using dynamic sql. You […]
2003-07-17
1 reads
From the OpenHack 4 config and with confirmation of Richard Waymire at Microsoft. quote: I only know of ONE - the table master..spt_server_info This isn't one. It's revoked from public. quote: But I think I'm wrong about this, because if I was right, you could just run DENY SELECT ON SPT_SERVER_INFO TO GUEST in the […]
2003-07-16
I feel this is a really good beginners guide: http://www.functionx.com/sqlserver At one point in the guide it says "Another technique used to perform data entry consists of importing already existing data from another database or from any other recognizable data file. Microsoft SQL Server provides various techniques and means of importing data into Microsoft SQL […]
2003-07-15
Hi jabalshah, quote: how do i store an image in sql server 7.0 selected by user in a vb 6.0 form. please help.... take a look at the ADO Stream Object and the image data type or search this site on this. There are countless threads about this Cheers, Frank
2003-07-15
1 reads
Then you need more parentheses. I think this is what you are looking for: WHERE ( (dbo.mainb.tarih >= CONVERT(varchar, DATEADD([day], 0, GETDATE()), 112) + ' 16:00:00') AND (dbo.mainb.tarihb <= CONVERT(varchar, DATEADD([day], 1, GETDATE()), 112) + ' 16:00:00') ) OR ( (dbo.mainb.tarih <= CONVERT(varchar, DATEADD([day], 0, GETDATE()), 112) + ' 16:00:00') AND (dbo.mainb.tarihb >= CONVERT(varchar, DATEADD([day], […]
2003-07-14
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers