Search results for query: *

If I have a user set up in SQL Server w/ Windows Authentication as both a login and a member of a group, do the groups rights and privileges supersede the login's or vice-versa?

Not sure what this type of query would be called. I apologize if the title is confusing. Gist: I need to exclude the top count of rows from a query. The example below is to better illustrate this. Example: Table Data ID, Rank, ItemDesc 1, 1, Basketballs 2, 2, Soccer balls 3, 3, Baseballs...

I have a basic audit/history table that I am querying. The table is pretty basic, the columns are as follows: ID, Store#, DaysServiced, ChangeDate A record is inserted every time a store's DaysServiced has been changed. Basically, what I need from this table is whether or not a store has...

Trying to take a DATETIME data type and CAST/CONVERT it to just display as month day or mm/dd 04/04 and leave off the year. Have not been able to find this anywhere. Thanks in Advance.

Anyway to calculate an average across a row, without using a cursor? Ex. col1, col2, col3, avg of columns 1, 2, 1, 1.33 Thanks,

How do I summarize this data to display like this: 1 Toy Balls A B C 1.09 2.09 3.09 ??? Thanks! lngItemID strDescription Date1RANK Date2RANK Date3RANK Date1PPP Date2PPP Date3PPP ----------- -------------- --------- ---------...

Trying to export from SQL into an Excel spreadsheet, but am getting an ISM error. "[Execute SQL Task] Error: Executing the query "DELETE FROM `ItemForecastingExport$` " failed with the following error: "Deleting data in a linked table is not supported by this ISAM.". Possible failure reasons...

Access 2002 Having an issue when trying to pass a string variable to a sub forms recordsource property. Error: Run-time error '103': the identifier that starts with 'partial query string' is too long. Maximum length is 128. Any insight. Dim strVendorCriteria As String Dim...

I am attempting to update a column for an entire recordset. I have the code to update the record that has focus, but not the entire record set. Any and all help is greatly appreciated. Thanks in advance, Private Sub cmdForecastReset_Click() Dim AvgShipped As Integer...

I would like to change the backcolor of a textbox to grey (RGB(128,128,128), After Update. The issues I am having are, one, VBA is not effective and does not change the back color randtxtboxname.BackColor = RGB(128, 128, 128) and , second, the only other way I know of accomplishing this is...

What I have is a simple SSIS package that I am using to run a simple SELECT statement that places the result set into an Excel spread sheet. I need for it to pull records by category with an empty record in between each Category on the spreadsheet. So, basically I have tried to use Named...

Is there anyway whether it be in TSQL or SSIS, that you can export to Excel and include formatting. Ex. Column C is bold, column D is highlighted in yellow. I have experience exporting plain worksheets in SSIS, but without formatting. Thanks in advance.

I have a query I have been working on that I am trying to code to calculate duration of time. Need a bit of help and any and all wil be appreciated. Ex. UID|Date|Toy|Out of Stock 001|1/1/2009|Balls|Yes 002|1/3/2009|Balls|Yes 003|1/5/2009|Balls|Yes 004|1/2/2009|Straws|Yes...

Have some strange behavior mucking up my combobox. For some reason when the data is pulled it is displayed vertically. So, the recruiters name looks like this: T o m S a w y e r Not sure why this is happening, any help is greatly appreciated. FYI ~ .Net noob here, so I am at a white belt...

Let me preface this post by explaining that I am VERY new to .Net and usually have my head stuck up SQL Server Management Studio. I am trying to modify a combobox so that it displays the values returned from a stored procedure. Seems pretty simple, but when Debugging, the only values that are...

Let me preface this post by explaining that I am VERY new to .Net and usually have my head stuck up SQL Server Management Studio. I am trying to modify a combobox so that it displays the values returned from a stored procedure. Seems pretty simple, but when Debugging, the only values that are...

Having a simple issue that I can't solve. When a parameter is passed via the stored procedure I have created, the value passed (varchar) has the correct quotes around when viewed via SQL Profiler. Somehow the quotes are removed when the parameter is used in the body of the procedure, so I...

I have been using SQL Server 2008 for about 8 months now, but I am having naming issues. When I first began upgrading our database the name was only the given SQL Server name. Now when I try to name SQL Servers the name is the physical machine/servername then the SQL Server name. Ex...

What is wrong with my statement ? ? ? Keep getting an "Msg 156, Level 15, State 1, Line 13 Incorrect syntax near the keyword 'AS'." error. SELECT * ,CASE WHEN EXISTS( SELECT * FROM tblStores WHERE lngDivisionID IN ( SELECT lngDivisionID...

Is there anyway to create a new file from within SSIS without having a Destination file? I have an excel file I am using as a destination, but everytime the SSIS is called it appends the file instead of creating a new sheet with current data. Any ideas?