Topics
Started by
Posts
Last post
hi! i have an unsolved problem: i want to use 'select distinct & into' to insert datas from a …
15 replies
I'm starting with a normal date table: Date_ID int, (in yyyymmdd format so for example today's en…
3 replies
Hi, Just want to share a tip: I use Excel Pivot Tables for reporting from SQL Server. In SQL Server…
1 replies
hello, i have an easy query for one of your braniacs. id number …
5 replies
I have the choise to restrict the result of a INNER JOIN SELECT statement in the WHERE or in the ON…
5 replies
i made a stored procedure list data for a given tabelname I would like to use this procedure in a v…
5 replies
Hi I’m trying to suss out how to write a query to produce a grouped report giving columns&nb…
14 replies
We have so far used scripts to update our database. Update means adding rows in tables, altering ta…
5 replies
Hi, I'm trying to access an excel spreadsheet using jet.4 and openrowset I am issuing the command S…
5 replies
Hi All!! I am trying to write a query in which i have a table with three columns named c_id (intege…
5 replies
Hey, I have one table. This table I check of update. And now I want to insert into 2 other table th…
1 replies
I am having some weird performance hits when comparing date fields - I want to compare dates only a…
8 replies
When I run the following OPENROWSET query against a Visual FoxPro table uder my SA login, it works …
2 replies
Hello...... I had the following error number 4701 when checking BOL it gave no futher information a…
3 replies
I am using OPENQUERY within a UDF to call a stored procedure (yes feel free to flame me for doing s…
3 replies
Viewing 15 topics - 8,101 through 8,115 (of 17,082 total)
You must be logged in to create new topics.