Recent content by Luvsql

I'm using this syntax in a Where statement in my sp in SQL 2008. I run my sp in SQL and there is data for this particular field. However, when I access this sp this one field is BLANK in Crystal Report. I doesn't even acknowledge the datatype. I know in CR it uses dateadd('yyyy',-1,@MyDate)...

I am running SQL Server 2012. The stored procedures I'm trying to use in Report Builder 3.0 run successfully within Enterprise Manager and use these with SAP Crystal Reports 2013 without issue. When I choose the sp within the Table/Matrix wizard, it doesn't list ANY fields. I've tried the SET...

I have SQL Server 2012 with SP 2 and Report Builder 3.0. I've created a shared data source in Report Manager, then created a shared dataset in Report Builder and saved into Report Manager. I can see the shared dataset in Report Manager and it does show the data source under dependencies as...

Which field would I use in the formula? The field names/number of fields in the table change every time the report is run. You're assuming this one field is static but it's dynamic. Here is what the table is when I choose parameter is 3 (Field Name - field values) Code - STAND0001 1 Thur...

I don't want all the values to display across the top. I only want the last field. If I enter 7 days, 30 days, 120 days that would put up to 120 columns across the top. I only want to very last one.

Yes I know the column name will be that but need the value in that field to display. The column names are +1 Wed Nov 26 etc, but the field values for each of these columns is different.

I have a stored procedure with a parameter called #Days so depending on how many days you enter when running the report, the table will be updated with different values. For example, if I enter 10 as the parameter, the end columns of the table will be +1 Wed Nov 26, +2 Thur Nov 27 up to +10 Fri...

Good point. I'll add another step to backup the databases again IF the maintenance succeeds. Thanks.

The databases that I do weekly maintenance on are those databases with Full recovery mode, which have their logs backed up hourly. When maintenance is run (DBCC checkdb, reindexing, update stats etc) the log files grow to almost the same size of the database. As a workaround I change the...

That's what I thought. To rebuild the indexes on 11 databases takes under an hour (it's very fast). Our databases are also all under 15Gb so we have no issues.

I have never taken our production databases offline to do weekly maintenance as it occurs when no one is using the applciations that access the databases and all the maintenance runs without issues. I'm now being questioned why they are not all taken offline to perform the maintenance. I run...

I have a table like the following: Code Qty CODE1 12 CODE2 5 CODE3 10 What I need to do is create x amount of unique rows for each code where x is the quantity by an incremeting value. The value I could actually do manually with exporting the results to excel, so I somehow need...

I'm simply trying to delete a database from SQL 2012 manangement studio by right-clicking and selecting delete. I have waited over 10 minutes then had to end task. I tried this directly on the server itself and same thing. In 2008 it took seconds. Why is this not working?

I know that it's not supported but it was working fine before I formatted my laptop and reinstall Windows. It doesn't matter what the default report location is (locally etc.) I cannot click Open (nothing happens), I just created a new report and cannot save, save as. Nothing happens. I see...

I've checked another random trace and in the trace file that I saved and view within profiler I have CPU 265 and Duration 275. In the SQL table that I saved it to the CPU is 265 and the Duration is 275793. The CPU doesn't change. I'm assuming that 275 in the trace is actually 0.275...