unit testing

Technical Article

RE: QOD 11/25

  • Reply

No research, just remembered that when you want to allow users access to specific data, building views is the way to go. quote: Although this question is highly technical, I was able to get the answer in only a few minutes of research using online help. I suspect that most of the people that got […]

2003-12-09

Technical Article

RE: DTS output from stored procedure to Excel

  • Reply

hi approach the problem from the other direction get the data from Excel, use [menubar] Data/Get External data... attach to the SQL Server DSN and access your data (or sp) using MS query. You can even automate the process to pass parameters (assigned in your spreadsheet) to the sp using VBA. i've been doing this […]

2003-11-28

1 reads

Technical Article

RE: grouping not grouping right(maybe?)

  • Reply

There are 4 distinct combinations of intLandUseCode and intMixedLandUseCode. intLandUseCode intMixedLandUseCode -------------- ------------------- 1 0 1 82 49 0 49 82 To get this to only two lines, you will need to remove one of these two columns. Brian

2003-11-20

2 reads

Technical Article

RE: Multi Row Insert?

  • Reply

Thanx for the help.... I'm getting a different error.... here it is: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xda0 Thread 0xa90 DBC 0x10a6004 Jet'. I'm using MS Access, here is the connection string..... do I […]

You rated this post out of 5. Change rating

2003-06-27

Technical Article

RE: How much do you earn?

  • Reply

Hi Larry, quote: Envious would have been a better word choice than jealous. As a college student working part-time and admittedly a "DBA newbie", you don't have a justification for being jealous. Keep studying, building skills, and gathering experience. Sooner or later, you will arrive at that rate. When you do, you will rightly be […]

You rated this post out of 5. Change rating

2003-06-25

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers