Search results for query: *

I have no experience of this since I am trawling this forum trying to create a Visio drawing of a group of SQL tables, but my first thought is can you not create a View in SQL that selects only "active" inventory and then link that to Visio instead of the table ? Just a thought.

Hi Katgirl, In your last post here you say you found "a great script at SQL mag online that calculates all the data you see in taskpad view and stores it in a table so you can track data growth over time. ". Is there any chance you would share that script ? It sounds like you were looking to...

Background to problem: We have a problem in that for the last two weeks at the start of business on Thursday morning a single row from a Customer Master table has been missing. The first time we were confused but thought it was accidental, the second time it became more obvious that it may be a...

Is there any way to identify the name of the table last updated (just like @@identity provides the last updated row identity). We have a need to update one of several tables based on dynamic sql statement and then need to trigger further updates based on knowing the table name rather than...

Hi Denny, Sorry it's taken a few days to respond again. It's taken until now to get a failure, but the message worked just fine. And as for the messages when maintenance jobs are working successfully ... they've disappeared !! I have no idea what's different, but hopefully all is OK now...

Hi Denny, Because it was sending so many "wrong" messages I've turned them all off. I'll set some to Notify for tonight's maintenance jobs and let you know tomorrow. Cheers, Paul

Hi Denny, I have a question on a similar subject and while searching for an answer found this posting - maybe you can help ? I have SQL Mail working just fine, notifying of scheduled Stored Procedures failing and sending spreadsheet or csv enclosures to customers etc. I'd like to set it up...

Thanks for your response CG. As for solving the problem, it remains a mystery. I've tried your suggestion & it works fine in a new spreadsheet with copied data, but unfortunately this looses much of the historic data due to truncation. Nothing I've tried so far has worked on the original...

I have a user who is adding text to cells within a spreadsheet. When these are full she used the Format / Cell Wrap option to allow the full text to be visible. Then she double clicked on the lower row nukber divider to re-siae teh height of the cell and in each case the row height changes to be...

that sounds like a plan. I'll give it a try tmoorrow & get back to you. Thanks. Paul

Thanks for response. Not sure which bracket I've missed, but I should have clarified that I've already listed them exactly as you have shown & it works perfectly (except the 'Order By' column name needs to be in the Select list - as I'm sure you'd have seen from syntax checker if you were...

I am trying to identify from a table of clients, only those who have handled a particular type of case (kf1.WorkSource2 = 4). This is in addition to more standard cases (there are some who never have kf1.WorkSource2 = 4 so the COUNT would be 0), so I want to ignore those where the COUNT is 0...

OK, so I can now answer part of my own question. If you use the "save as" option to save the DTS Package as a "Visual Basic file" then you can compare the scripts in VB. Having compared them, the only difference I can see between the two versions is the Connection Server...

I have inherited two DTS packages with the same name (in two different SQL (2000) Servers). I need to find out what they do to see why we have two versions so I right click to "Design Package" to see the Source is a Text file (csv) and the Destination or Result is a SQL table. However...

This worked just fine, thanks. Sorry it took a while to get back to you, "changing business priorities" have altered my project priorities over the last few weeks. If only we could get on with what we have to do without the users & without the interfering management !¬)

Thanks Terry, That looks like it makes a lot of sense. I'm between meetings right now and am in the UK so finish for the weekend soon. I'll check it on Monday and let you know how it goes, although as I said before it looks a lot cleaner than the way I was trying to approach this. The...

If you need it to be in a "front end" application, you could create a Table as mentioned above, then export it to Excel using SQL's Data Transformation Services.

Hi, I need to calculate average response times in days (from the date a letter is posted to when a reply is received). I use the following to get the total days difference, and when output to Excel with the count of letters sent it works just fine. DECLARE @DAYDIFF INT SET @DAYDIFF = (SELECT...

Many thanks Terry for your persistence, my problem is now cured, and I've learned a lot. I thoroughly agree with SQLSister's comments, I'm coming across several interesting design "features" like this one, but unfortunately I'm not in a position to do anything about them. At this...

When I just run this code to display the field from the file it works SELECT LTRIM(STR(CAST(lcd.ClaimNo AS INT),50,0)) FROM lawCallDataRaw lcd (but when I run "SELECT lcd.ClaimNo FROM lawCallDataRaw lcd" it displays with the " .0 ". When I add it to the full query as you...