Search results for query: *

Hi -- I am in VC++ in the VS 2008 .net environment building a WinForm that talks to Microsoft SQL. I have a try/catch block around my call to SQL so I am properly catching the raiserror message from the call to SQL. What I can't seem to find though is how to get to the severity level that the...

The result of datediff(ss, '01/01/1970', '12/31/2050') is a bigint so "datediff" is overflowing. How can I get from a bigint value to its equivalent date and back again if the max a date can be in SQL is "int"??? I need to be able to store number of seconds between '01/01/1970' and...

How is a Cube/Dimension/Measure different than a SQL table View? What are the PROS of a View over the SSAS object? What are the PROS of the SSAS objects over a table view? Don't I still have to write a user facing application for the user to access the data from a SSAS object? THanks. Stay...

I am a relatively newbie to SSAS although I am an experienced SQL programmer. My question is about CUBE's. What is the lifespan of a cube? i.e., I have a CUBE with a datasource to a SQL table that is updated nightly. How/when does the associated CUBE get updated? Does the user have to...

This may not be the right forum for this question and if not, please forgive me. My question/issue has to do with Visio 2010. I need to start a new Software/Database diagram. When I start up Visio 2010 this option is not available in the Template Categories. Does anybody know if there is/was...

Hi -- I am having a terrible time trying to get a regular expression defined to split a string that will look like the following . . . SQL12345,54321SQL XXXXX,XXXXX Where X = [0-9A-Za-z] and can be repeated one or more times on each side of the delimeter (,). The RegEx Pattern...

I am struggling to figure out how to use ADO.Net to connect to SQL in a project I'm writing using C++ (Managed) in VS 2005. I am specifically looking for links to tutorials or code samples. It's just NOT working for me! Thank you! Stay Cool Ya'll! [smile2] -- Kristin

Is it possible for a SQL View to degrade performance vs. querying the tables directly? I have two different views. One is just a single table query. The table is not indexed (long story). The other view joins with one other table which also is not indexed. So is it possible for the Views as...

So I have a job in adTempus that uses a script written using VB Script. I need to be able to pass as parameter to the adTempus script. This is preferred over hardcoding the script with the variables. Does anybody know how or even if it's possible to call a VBScript from adTempus and pass it a...

Does anybody know if it's possible (and if so, how) to define a desktop shortcut to an applications EXE file that exists on a network share in the CAB file? I need to republish the applications CAB file so that users do not install the application EXE directly on the workstation but I am having...

I need a way to force a NULL value to return in a simple query instead of just an empty result set if the "where" clause does not yield any results. Example . . . Table A Table B NameColumn char (15) StreetColumn char (20) NumberColumn int NumberColumn...

Is there a way to identify in SysObjects or some other T-SQL tool the last time a stored procedure, function, or user table was referenced/used/called ? Stay Cool Ya'll! [smile2] -- Kristin

DOH! Thank you! Stay Cool Ya'll! [smile2] -- Kristin

I'm trying to write a "case" statement with the "in" clause and am getting compile errors. So here's my code . . . where . . . IdCapPlusSrc in case when @Status = 4004 then (select distinct IdCapPlusSrc from CapPlus with (nolock) where TmsSent is NULL) else (select...

I have a ListView with Checkboxes = TRUE What I need to do is to be able to highlight each row that is selected? I know how to highlight one selected row, but am having trouble highlighting every row that is selected with the Check Box. Ideas? Stay Cool Ya'll! [smile2] -- Kristin

Does anybody know the name of or where I can get my hands on the file that contains the "Question" icon image for the MessageBox? Stay Cool Ya'll! [smile2] -- Kristin

Good idea. Do you name the Config file with the machines mac addr at the time of install, or can this be dynamic? How do you then access the INI file from the VB code? How do you get to the mac addr in vb code? Stay Cool Ya'll! [smile2] -- Kristin

Let me set up the situation. I have a VB6 app running from a network share. Users access the EXE through a short cut on their desktop. The EXE automatically accesses it's INI file from the same directory where the EXE lives. What I need to be able to do is to allow the users to have their...

What's the trick to catching or handling a raiserror generated out of SQL? Even though I'm iterating through the ado Errors collection, the raiserror is actally coming out as a "Run Time Error". The part in my code where I actually look for errors is not being touched because the runtime error...

I found it best to use the "Shown" event. Thanks for all the help and input on this one. Stay Cool Ya'll! [smile2] -- Kristin