Topics
Started by
Posts
Last post
Hi guys, the below query works fine until I try to put it into SSRS when it complains that I have a…
1 replies
Hello. Given a list of SiteId/date combinations and a date tally table I'm trying to figure out wha…
2 replies
Hi, I need help on data level error handling. I have csv file with Data like First row is column he…
22 replies
I have 2 database exmp: db1 and db2 I have a procedure named proc1 which is already present in db1 …
12 replies
is it possible to create a function which is available for all Databases(i.e) when i create a proce…
3 replies
Hi, We have two similar files, one header file and one line file. Under certain conditions*, the li…
3 replies
Following are the table details 1. name: time_tbl columns: time_id employee_id time_date (date) tim…
2 replies
Hi, I have table Student with these columns names student_code , stud_act_id , fee , discount_…
1 replies
Hi, I have two SQL tables which are referenced within a trigger. I have tested the trigger in a 'de…
5 replies
Hi Guys I am new to sql server and require a procedure which is able to output data to a text file …
22 replies
I have the following data in my single table. create table dbo.test_table (part varchar(5), stat va…
3 replies
I have a column that holds zip codes I need to remove 4 trailing zeros how can I do this? the zip c…
6 replies
I am trying to export data into Excel file using OPENROWSET. USE [AdventureWorks]; GO INSERT INTO O…
6 replies
Hi all. First of all, i am relatively unexperienced with tsql, so please do not judge too hard if m…
3 replies
I am querying a database with values recorded every 15 minutes. But its not exactly every 15 minute…
3 replies
Viewing 15 topics - 1,366 through 1,380 (of 12,230 total)
You must be logged in to create new topics.